View run status under MySQL command line

To view the running status of MySQL
Use the command line's show statement
Show status is a look at MySQL running, similar to the one seen above through PMA.

Show VARIABLES is a view of MySQL configuration parameters and can also be used similar to show VARIABLES like ' key% '

Show Processlist is a review of the processes currently in progress and is useful for troubleshooting situations such as locking tables. In general, turning on MySQL's slow query record is also useful for troubleshooting.

Show open tables is a list of tables that are currently open.

Use MySQL mysqladmin to view
Use the Mysqladmin tool that comes with MySQL to view status, using the following command
Mysqladmin-uroot-p Password Status

The results shown are as follows:
uptime:502963 threads:2 questions:8561820 Slow queries:734681 opens:553
Tables:1 Open tables:85 Queries per second avg:17.023
You can also add the-I 5 parameter to automatically refresh every five seconds.
Mysqladmin-uroot-p Password Status-i 5

View run status under MySQL command line