I am running MySQL 5.5 with InnoDB tables. There are about 200 queries per second. There are also tables with 500 000 or more rows. But I have big issues with server load and io/wait especially with the jdb2.
jdb2/md2-8 is taking 99% IO/wait see iotop output image: Iotop output
Box Specifications: Xeon 1246 v3, 32 GB RAM, 2x 240 Intel SSD RAID 1
I dont know if I have something wrong in my config or it is problem related to RAID. Any tips ?
My mysql my.cfg:
innodb_file_per_table = 1 join_buffer_size = 1M open_files_limit = 10000 myisam_use_mmap = 1 query_cache_type = 1 table_open_cache = 2000 concurrent_insert = 2 max_connections = 3000 query_cache_size = 16M key_buffer_size = 16M read_buffer_size = 8M query_cache_limit = 4M query_cache_min_res_unit = 1K tmp_table_size = 64M thread_cache_size = 1500 sort_buffer_size = 2M max_heap_table_size = 64M innodb_buffer_pool_size = 5000M read_rnd_buffer_size = 128M thread_concurrency = 8 thread_stack = 1M innodb_log_buffer_size = 2M