MySQL QPS debugging? I see 5 Kqps on my DB server during 5 mins interval on zabbix dashboard. But sum of all max queries(Delete/select/Insert/Update/Replace) during that interval come out to be 1300.
Not sure how come max 5kqps is displaying but sum of all max is 1300 ? My objective is to find which specific DML(insert/update/select/delete) is causing high QPS here  and get some direction from here ? Another point is to understand is there anything else that can cause high QPS apart from these DML so that I can move in right direction. I am bit confused how come Max QPS can be some of individual DML QPS or I am missing anything here ?
Also IOPS during that shows 1Kops, if each query is is even hitting disk, shouldn't it be close to 5Kops ? Where can be the gap ?
As SQL, show global status like 'com_%' will show you a break down of the types of queries. Any high volume of update, replace, delete should be an indication that you shouldn't be using MyISAM.
Given there are 5kqps SHOW FULL PROCESSLIST at any instant should give you a sample of activity.
Don't worry about IOPs, focus on the queries and watch the benefits flow from that. If queries are contained to the primary key there is no reason for them to result in disk IOPs. Filesystem cache is also used so that's another buffer preventing IOPs.
If its the IOPs (hardware not handling it) that's the problem consider moving to InnoDB. If you value your data, move to InnoDB.