Hello. I'm new to this list.
My company runs a MySQL server(3.23.42), PHP, and Apache on a single 1Ghz PIII server for our webhosting customers. Most of our customers don't use it. However, we do have a few largish bulletin board(usually w-Agora) sites that do use MySQL. Recently, our server's CPU load has been hovering around 60-70% usage from mysqld. Since I'm new to MySQL, I was wondering what the best method would be to track down and report which users use the server the most. I've found a few useful commands for the MySQL Monitor: SHOW PROCESSLIST; SHOW VARIABLES; Is there anything else I can use to track user usage loads? -- Jesse Guardiani, Systems Administrator WingNET Internet Services --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
