Find the answer to your Linux question:
Results 1 to 2 of 2
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jun 2004
    Posts
    4

    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??

    Scenario:

    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
    Location
    London, UK
    Posts
    3,284
    if its load on your database server, you may want to use a command like:

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

    Jason

Posting Permissions

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