In my last blog post, I showed how we can get some raw
performance information from /proc into the MySQL database using
a LOAD DATA INFILE (LDI) command.
I've modified that LDI call slightly to set the `other` column to equal the sum total of the CPU counters for those rows which begin with 'cpu'.
other = IF(@the_key like 'cpu%', NULL , @val1);
other = IF(@the_key like 'cpu%', user + nice + system + idle + iowait + irq + softirq + steal + guest, @val1);
Top provides a useful output that looks something like the following:
top - 04:59:14 up 14 days, 3:34, 1 user, load …[Read more...]