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
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
show 2 more comments

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

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

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.