How to check MySql
I'm running a toaster/mail server and having authentication hang ups. I've narrowed it down to either imap or mysql. How can I tell if mysql is hanging on trying to authenticate??
Web Client-user clicks "login" and it can take up to 80secs to log in. Once they're logged into mail, it flies.
Fat Client-I open Thunderbird and it sits processing....about 40 secs later (up to 80) I'll get the authorization prompt.
This is sporadic, but I believe the issue to be in either IMAP or MySql. How can I tell if MySQL is having trouble authenticating?
if its load on your database server, you may want to use a command like:
It will show you if any tables are locked etc preventing queries going through.
mysqladmin -h <hostname> -u <username> -p processlist