Bug #64876 MySQL + 2 x Intel Xeon (6 cores) performance problem
Submitted: 5 Apr 2012 13:14 Modified: 5 Apr 2012 13:45
Reporter: Alex Bizal Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any

[5 Apr 2012 13:14] Alex Bizal
Description:
We've bought a new server for using it like MySql server. 

Configuration: 
Motherboard: Supero X8DTL-6 
CPU: 2 x Intel Xeon E5645 Six-core (12M Cache, 2.4 GHz, 5.86 GT/s IntelĀ® QPI, LGA1366). 
Intel SSD 320 Series 120Gb (SSDSA2CW120G3) 
RAM: 16 GB 
OS: Debian 6 (64 bit); CentOS-6.2; Windows7; 
MySQL 5.5 (5.0, 5.1) 

But we've got an issue when tried to run MySql in multithread mode on the Intel Xeon E5645. 
Different builds and fine-tuning haven't given any result. 

For testing we used 'mysqlslap' with following parameters: 
mysqlslap --concurrency=64 --iterations=1 --number-of-queries=10 --query=/var/tmp/query.sql --create=/var/tmp/create.sql --delimiter=";" 

Testing results: 
- 2CPU x 12cores(physical + HT) = 24 cores : query execution time - 12s 
- 2CPU x 2cores(physical + HT) = 4 cores : query execution time - 7s 
- 2CPU x 1core(physical) = 2 cores : query execution time - 5s 
- 1CPU x 1core(physical) = 1 core : query execution time - 4s 

The same tests on the AMD Phenom 2 (6 cores) took 3.5s 
Please, help us to solve this issue. 

additional: 
While running the tests, all cores are 100% loaded; 
- when we tested on 24 cores, 80% of load went for system needs and 20% for testing process; 
- on the 1 core configuration: 1% was taken by system and 99% by testing process; 

How to repeat:
-

Suggested fix:
-
[5 Apr 2012 13:45] Valeriy Kravchuk
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.