Find the answer to your Linux question:
Results 1 to 2 of 2
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    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?

  2. #2
    Linux Guru
    Join Date
    Apr 2003
    London, UK
    if its load on your database server, you may want to use a command like:

    mysqladmin -h <hostname> -u <username> -p processlist
    It will show you if any tables are locked etc preventing queries going through.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts