Take the 2-minute tour ×
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.

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:

    [client]
port        = 3306
socket      = /tmp/mysql.sock

[mysqld]
port        = 3306
socket      = /tmp/mysql.sock
skip-external-locking
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

log-bin=mysql-bin

log-error="errorquery.log"
general_log=1
general_log_file= "generalquery.log"

binlog_format=mixed

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

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

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

share|improve this question

migrated from stackoverflow.com Apr 30 '13 at 14:33

This question came from our site for professional and enthusiast programmers.

1  
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
1  
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.