Re: Does MySQL use multiple cores?

[Rick James]

For one query, MySQL won't use more than one CPU/core/hyperthread.

Multiple connections can use multiple cpu units. After about 8 cores, the interactions between the threads becomes a bottleneck and performance stops increasing. Percona's version of InnoDB stretches that considerably.

No, PARTITIONing does not lead to a single query using multiple cores. This seems like the first (and easiest) case that ought to be remedied.

Rumor has it that the InfoBright engine can use multiple cores. (It's a "column store" that is excellent at huge data warehousing tables with ad hoc queries.)

> I'm newbie in MySQL (I'm Oracle DBA)
How much overhead does it cost to figure out how to split up a query for spreading across cpus? And stitching the results back together?

If a query takes more than a few seconds, there is a pretty good chance that it can be redesigned to run much faster, even without throwing hardware (CPUs) at it.