Friday, May 7, 2010

How to check MYSQL server status on linux

There are two ways to check-
1. Use command -
    # mysqladmin -u root -p status
   -> it will give you uptime , threads etc , if server is runing otherwise it will give error report
2  Use -
   $ mysql -u user -p
    mysql> show status;
 -> show status wil give you status in tabular form.

No comments: