MySQL Forums
Forum List  »  Performance

MySQL + 2 x Intel Xeon (6 cores) performance problem
Posted by: Alex Bizal
Date: April 05, 2012 07:07AM


We've bought a new server for using it like MySql server.

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.

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;

We are looking forward for hearing from you.

Options: ReplyQuote

Written By
MySQL + 2 x Intel Xeon (6 cores) performance problem
April 05, 2012 07:07AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.