Re: MySQL / MariaDB and Multi-Core CPUs

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Mike Bydalek
Date:  
To: nathan@nmecs.com, Main PLUG discussion list
Subject: Re: MySQL / MariaDB and Multi-Core CPUs
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 <> 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 ()
> Systems Administration / Web Application Development
> Information Security Consulting
> (480) 559.9681
>
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss

---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss