MySQL 5.5 multi-core CPU support

MySQL 5.5 supports multi-core CPUs. When we test how many MySQL instances can be supported by a single machine today, we accidentally find that MySQL 5.5 supports multiple cores quite well, 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 result is as follows: cpu usage when one instance is running: cpu usage when www.2cto.com runs two instances: cpu usage when four instances are running: when www.2cto.com runs 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. Author zbszhangbosen