How to know Mysql Server status

Server status

Interactive mode

mysqladmin -p status

This command will give informations on MySQL server status, after entering the password.


From a Shell script

mysqladmin --password=MyPassword status

This command will give the informations on MySQL server status

Process used by the system

Interactive mode

mysqladmin -p processlist

This command will list all process in memory, after entering the password.


From a Shell script

mysqladmin --password=MonMotDePasse processlist

This command will list all process in memory.