4

Good day. We have an 8 core server for mariadb 10.1 on Centos 7. IT's a production database as well as a replication master. I am not sure if it's using more than one of the cores.

We also have a one-core virtual server acting as a slave.

Searching on this tells me that most queries are about using more than one core per query, which are repeatedly answered with NO, that's not possible. I get that.

I just want to know if multiple queries can be apportioned out to multiple cores, whether configuration settings are required to do this, and how to tell if it's working.

I also need to know whether slave throughput could be improved by adding cores.

Thanks,

Ed Greenberg

3
  • 1
    Hi, I guess your question is related to this one dba.stackexchange.com/questions/5666/… Commented Apr 30, 2018 at 10:29
  • 1
    Usually MySQL is I/O-bound before it is CPU-bound.
    – Rick James
    Commented May 15, 2018 at 20:21
  • Is your question about the Master? Or the Slave? The answers are quite different.
    – Rick James
    Commented May 15, 2018 at 20:22

1 Answer 1

3

The short answer is yes. It will use a thread per connection by default which you can delegate queries to concurrently, which will utilize multiple cores on the operating system level.

Slave throughput can be dramatically improved by adding cores using parallel replication which is not enabled by default. https://mariadb.com/kb/en/library/parallel-replication/

Not the answer you're looking for? Browse other questions tagged or ask your own question.