MySQL Forums :: Performance :: MySQL + 2 x Intel Xeon (6 cores) performance problem


Advanced Search

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

Hello.

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;



We are looking forward for hearing from you.

Options: ReplyQuote


Subject Views Written By Posted
MySQL + 2 x Intel Xeon (6 cores) performance problem 2529 Alex Bizal 04/05/2012 07:07AM
Re: MySQL + 2 x Intel Xeon (6 cores) performance problem 1069 Rick James 04/06/2012 09:20AM


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.