History of MySQL Processes

Portal Home > Knowledgebase > Articles Database > History of MySQL Processes

Posted by constantine, 09-12-2008, 08:51 AM
Hi there , I want to check which users Excessive mysql processes in my server today ? I'm using centos - cpanel linux . I can check current MySQL Processes only . Any Idea ?
Posted by AnandVK, 09-12-2008, 03:15 PM
To view mysql processes you can use the command from the shell # mysqladmin proc (will list current running process along with its database and user name) From the output you can view the user taking the load.
Posted by constantine, 09-12-2008, 03:59 PM
Hi , I want to list mysql processes at special time . ( for example a hour ago ) I don't ask to list current running process . I need a script for logging mysql process . Is there any script for this ?
Posted by constantine, 09-15-2008, 08:47 AM
How do you monitor mysql ?
Posted by david510, 09-15-2008, 10:15 AM
Use the following script to append the mysql process to a file with the date and time. Run the script as a cron say every 20 minutes, to append the log file.