Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi I have a decent setup: 16Gb RAM and a 4 cored CPU. I'm on a 64-bit Windows OS with MySQL Ver 14.14 Distrib 5.5.24 Win64 (x86). I am also using InnoDB.

The query I am using to test the setup is a procedure that makes numerous SET calculations from a record. So for each record in one table it makes about 25 SET and SELECT statements, and then inserts it into another table. And that is a cursor for the whole database.

My I/O performance is sitting at about 15% during this operation. CPU maxes out at about 36% usage and RAM remains at about 25% usage - same as when system is idle.

I have set my MYSQL my.ini file as follows:

port        = 3306
socket      = /tmp/mysql.sock

port        = 3306
socket      = /tmp/mysql.sock
key_buffer_size = 512M
max_allowed_packet = 32M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 128M
thread_cache_size = 16
query_cache_size= 32M
thread_concurrency = 0


general_log_file= "generalquery.log"


server-id   = 1

**innodb_buffer_pool_size = 12G**
innodb_log_buffer_size = 256M
innodb_flush_log_at_trx_commit = 2
innodb_read_io_threads = 64
innodb_write_io_threads = 64
innodb_buffer_pool_instances = 4

max_allowed_packet = 16M


key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M


Is it a problem with the test, is there a better way to stress test or is it a problem with my setup?


migration rejected from Jun 3 '15 at 12:54

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, dezso, Colin 't Hart, RolandoMySQLDBA, RLF Jun 3 '15 at 12:54

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, dezso, RLF
If this question can be reworded to fit the rules in the help center, please edit the question.

No, I tried there...unsuccessful, I don't mean to spam it all over but I feel there is a larger community on this site with a higher probability of the question being answered. Thank you for your consideration. – Stephen H Apr 30 '13 at 12:58
That's not a very successful strategy, nor is it within the spirit of the stackexchange framework. Stick with it over there and I'm sure someone will help. – Burhan Khalid Apr 30 '13 at 13:00
How did you test for I/O? – N.B. Apr 30 '13 at 13:01
I used resmon, windows standard resource monitor – Stephen H Apr 30 '13 at 13:20
@StephenH show your test protocole – Sebas Apr 30 '13 at 13:20

Browse other questions tagged or ask your own question.