I’m having constant IO problems on one of my servers, iotop tells me that the majority of IO is used by MySQL(Percona).
What’s the best way to identity who is using all of the IO from within MySQL?
I’ve been looking at BYTES_RECEIVED AND BYTES_SENT from INFORMATION_SCHEMA.USER_STATISTICS. Is there anything else I should be looking at that would tell me disk activity from a certain user?