Minitoring mysqld process activities
Hi all, I'm running a small database as backend of a relatively quiet website, This is the version Im running: mysql Ver 11.15 Distrib 3.23.47, for dec-osf5.1 (alphaev6) yesterday for the first time, mysql process response time dropped significantly and when I monitored running processes I realized that mysql process is very busy, utilizing %95 of CPU time, and I was unable to refresh or reload,... so I shut it down and restart it and everything works fine again. I was wondering If there is a way to monitor what mysql process is doing at anytime Thanks in advanced for your answers. Regards Mohammad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Minitoring mysqld process activities
Have you checked the slow query log and the error log? -Original Message- From: Mohammad shojatalab To: [EMAIL PROTECTED] Sent: 6/30/04 11:58 AM Subject: Minitoring mysqld process activities Hi all, I'm running a small database as backend of a relatively quiet website, This is the version Im running: mysql Ver 11.15 Distrib 3.23.47, for dec-osf5.1 (alphaev6) yesterday for the first time, mysql process response time dropped significantly and when I monitored running processes I realized that mysql process is very busy, utilizing %95 of CPU time, and I was unable to refresh or reload,... so I shut it down and restart it and everything works fine again. I was wondering If there is a way to monitor what mysql process is doing at anytime Thanks in advanced for your answers. Regards Mohammad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Minitoring mysqld process activities
I've not seen this on MySQL but under Informix 7.24 on Solaris 2.6 I noticed a similar problem when doing a lot of number crunching and transaction logging was turned on. If you are running with transaction logging switched on then you might want to try turning it off. For some reason the database seems to get backed up writing to the log and this stalls everything else on the system, iowait figures go sky-high and I can only stop the process by doing 'kill -9 pid. Cheers Andrew. - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'Mohammad shojatalab ' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 7:27 PM Subject: RE: Minitoring mysqld process activities Have you checked the slow query log and the error log? -Original Message- From: Mohammad shojatalab To: [EMAIL PROTECTED] Sent: 6/30/04 11:58 AM Subject: Minitoring mysqld process activities Hi all, I'm running a small database as backend of a relatively quiet website, This is the version Im running: mysql Ver 11.15 Distrib 3.23.47, for dec-osf5.1 (alphaev6) yesterday for the first time, mysql process response time dropped significantly and when I monitored running processes I realized that mysql process is very busy, utilizing %95 of CPU time, and I was unable to refresh or reload,... so I shut it down and restart it and everything works fine again. I was wondering If there is a way to monitor what mysql process is doing at anytime Thanks in advanced for your answers. Regards Mohammad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Minitoring mysqld process activities
You could also use 'show full processlist;' at the mysql prompt. even better is an app called mytop whis looks/acts like top but is specifically used for mysql. Victor Pendleton wrote: Have you checked the slow query log and the error log? you could also che -Original Message- From: Mohammad shojatalab To: [EMAIL PROTECTED] Sent: 6/30/04 11:58 AM Subject: Minitoring mysqld process activities Hi all, I'm running a small database as backend of a relatively quiet website, This is the version Im running: mysql Ver 11.15 Distrib 3.23.47, for dec-osf5.1 (alphaev6) yesterday for the first time, mysql process response time dropped significantly and when I monitored running processes I realized that mysql process is very busy, utilizing %95 of CPU time, and I was unable to refresh or reload,... so I shut it down and restart it and everything works fine again. I was wondering If there is a way to monitor what mysql process is doing at anytime Thanks in advanced for your answers. Regards Mohammad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
