My 2c on the matter as its been awhile since I've worked with MySQL.
Yes, query optimization is extremely important for performance. The
question really becomes, what are my physical bottlenecks?

Multi-core CPUs allow for multiple simultaneous queries as I believe
each query uses a thread. However, the biggest thing you can do for
database performance is making sure you have enough disk IOPs to
handle pulling and writing data.

-Mike


On Feb 21, 2013, at 1:04 PM, Nathan England <nathan@nmecs.com> wrote:

>
> Hello All,
>
> I'm interested in learning how to optimize MySQL or MariaDB for a multi-core
> cpu. Can the database itself benefit from newer quad-core or more cpus?
>
> I have been trying to find this information, but it seems to me that the
> largest benefit does not come from the database using more than one core, but
> in the design of the query and running multiple queries... is this true?
>
> I would appreciate thoughts, articles, opinions, smacks upside the head...
> Though I generally do not like arguments like "don't waste time with MariaDB,
> just use PostgreSQL", I would even consider these...
>
> Thanks!
>
> --
> Regards,
>
> Nathan England
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> NME Computer Services http://www.nmecs.com
> Nathan England (nathan@nmecs.com)
> Systems Administration / Web Application Development
> Information Security Consulting
> (480) 559.9681
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss