Intermittent KVM performance issues causing performance glitches
Solution 1:
Rate Per Second = RPS
Suggestions to consider for your my.cnf [mysqld]
read_rnd_buffer_size=128K # from 256K to reduce handler_read_rnd_next RPS of 262756
innodb_lru_scan_depth=100 # from 1024 to conserve 90% of CPU cycles used for function
innodb_flush_neighbors=2 # from 0 to speed reduction of innodb_buffer_pool_pages_dirty of 148,465
sort_buffer_size=512K # from 256K to reduce sort_merge_passes RPhr of 1370
innodb_io_capacity=1900 # from 200 to use more of available SSD IOPS capacity
This is only first five performance improving suggestions. There are many more to consider. Please view profile, Network profile for contact info and free downloadable Utility Scripts to assist with performance tuning.