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.