MySQL / MariaDB and Multi-Core CPUs

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