On a big server with many user and website from 11AM - 00AM our MySQL throughput realised in max (60 - 80M) this timestamp our customer website load slowing .
We haven't any Disk IO , and server HDD : 6 * 600 G SAS 15K + 64 G RAM
MySQL config :
innodb_buffer_pool_size=8192M (2 G above mysqltuner recommendation)
Screenshot:
Any idea to solve this problem?
This comment add after first answer :
Hello Dear Damiano : Thank you so much your answer . about your comment : I will attach the complete screen from server monitor . (end of this comment)
about slow query : I have done this , but every 24 hrs we have under 500 slow query . and most them not occur repeatedly .
an other thing , this server big and we have High traffic web site on it , so I can not ask customer don't use server resource .
mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+----------+
| Variable_name | Value |
+-------------------------+----------+
| Qcache_free_blocks | 11573 |
| Qcache_free_memory | 27291504 |
| Qcache_hits | 83817933 |
| Qcache_inserts | 36512628 |
| Qcache_lowmem_prunes | 15633028 |
| Qcache_not_cached | 4338965 |
| Qcache_queries_in_cache | 29930 |
| Qcache_total_blocks | 106130 |
+-------------------------+----------+
Here You are all thing need : http://www.4shared.com/zip/jX54_Dprba/data.html
1 screen shot + 1txt file from output server