Detecting MySQL loading
I've seen strange and randomize increasing of the MySQL db loading but mytop did not help to sorted out with this issue. I'm not Mike Tyson and my reaction is more slow then CPU. If I don't catch this dynamically I will catch this statistically.
Select active request by cron and write it ti file. After this statistic analyze for long period of time sort this problem out.
Selecting information from MySQLPlease add python mod MySQLdb and set correct credentials up.
After this add executing this script by cron daemon.
I've ignored 'COMMIT' request but you can update it easy. Script analyzes log file and build dictionary with based on command & table and summarize running time .
!-- HTML generated using hilite.me -->
Also you can set different period of time for longer checking. All questions are welcomed.