MySQL / MariaDB and Multi-Core CPUs

[Nathan England]

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 at nmecs.com)
Systems Administration / Web Application Development
Information Security Consulting
(480) 559.9681

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20130221/040a52f3/attachment.pgp>