dbtop

Utility to monitor MySQL usage. Requires db_governor to be running. It shows usage for the current, mid and long intervals.

Options:

-c                show one time user list (no interactive mode)
-r interval        refresh interval for interactive mode (in seconds)

Control keys:

z        toggle color mode and two-color mode
q                F10, Ctrl-c - quit program
u                sort table by username
c                sort table by cpu column
r                sort table by read column
w                sort table by write column
l                sort by restriction level
t                sort by time before restrictions will be lifted.

Control keys, that sort table, displays into header of table bold and underlined symbol.
Sorted field will be highlighted by *.
CAUSE field shows current stage, reason for restriction and number of seconds before restriction will be lifted:
Values of column 'CAUSE' - cause of throttling:
Possible stages: - - OK, 1 - Restriction 1, 2 - Restriction 2, 3 - Restriction 3, 4 -- restriction level 4
c - current (current value of parameter)
s - short (average value of 5 last values of parameter)
m - middle (average value of 15 last values of parameter)
l - long (average value of 30 last values of parameter)
and parameter which is cause of restriction

1/s:busy_time/12 - first level restricted account with short average restriction by busy_time with 12 seconds left before re-enabled.

Display fields:
{{{• cpu - number in %, shows cpu usage by user • read - number of bytes (kbytes, mbytes, gbytes) which user reads per second • write - number of bytes (kbytes, mbytes, gbytes) write user reads per second }}}

Color conventions:
Accounts highlighted in red color means that the account is throttled.
Accounts highlighted in blue color are in cool down period

Command line parameters of dbtop utility:
-r - dbtop refresh period in seconds( dbtop -r12 )