MySQL supports multi-core CPUs

Today, when I tested how many MySQL instances a machine can support, I accidentally found that MySQL5.5 had a good support for multiple cores. I didn't say that MySQL was a huge one.

Today, when I tested how many MySQL instances a machine can support, I accidentally found that MySQL 5.5 had a good support for multiple cores. I didn't say that MySQL was a huge one.

Today, when I tested how many MySQL instances a machine can support, I accidentally found that MySQL 5.5 had a good support for multiple cores, in the past, I was not talking about a major defect in MySQL. Is it impossible to make good use of the CPU? It seems that MySQL 5.5 is still good. The test tool is sysbench, test-mode = oltp, And the buffer for each instance is 12 GB. About 36 GB of data is generated by sysbench, and buffer accounts for 1/3 of the data. Of course, the tested machine does not rely on: DELL R720XD, 24-core cpu, 96 GB memory. You can also query other parameters online. The test results are as follows:

Cpu usage when one instance is running:

Cpu usage when running two instances:

Cpu usage when four instances are running:

Cpu usage when running six instances:

From the data in the black box above, we can see that the cpu utilization of MySQL 5.5 is indeed good, and a single MySQL instance can achieve 1400 cpu utilization, that is, 14 cores. Prepare to test MySQL 5.1 at that time to see the difference between the two.

BTW, because the user part involves some company information, and I just arrived at the company, I do not know whether to disclose this information, so it will be spent.