Add Busy_time, Query_time, and Uptime_hires
I'd like the following global variables in SHOW STATUS:
Busy_time is the total wall-clock time during which user threads were executing queries. This is not the same as Threads_running > 0, because Threads_running is > 0 when there are slaves or event threads executing.
Query_time is the total query time accumulated by the server, including currently executing queries (this is very important).
Uptime_hires is simply a high-resolution Uptime.
The Busy_time is similar to field 10 in /proc/diskstats. The Query_time is similar to field 11. See http://
This information is amazingly powerful for performance analysis. It lets you do all kinds of things with queueing theory and Little's Law. It lets you apply Neil Gunther's universal scalability law to predict the scaling limits of the server. I have gotten the same information from TCP traffic and validated its usefulness. You can see an 'awk' implementation here: http://
This is related to https:/