Oracle supports sql queries to
SYS.V_$SYSMETRIC to find out Database Wait Time Ratio (% of wait or bottlenecks experienced in time spent on user-level calls) http://www.oracle.com/technetwork/articles/schumacher-analysis-099313.html. What is an equivalent query to find similar stats for MySQL database?
I have looked at
information_schema.PROCESSLIST tables to calculate a similar measure but unable to comprehend what values to use / address.
I need it for both Windows and Linux Platforms with remote MySql server. I think a light-weight DB query would help as opposed to gathering CPU Utilization for the machine hosting MySQL server.