Archive for February, 2010

SBDavid

Checking mysql extended-status

Checking mysql extended-status

mysqladmin is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, and more.

root@dell:~# mysqladmin status -uroot -p
Enter password:
Uptime: 197 Threads: 1 Questions: 135 Slow queries: 0 Opens: 40 Flush tables: 1 Open tables: 34 Queries per second avg: 0.685

For Extended Status

root@dell:~# mysqladmin extended-status -uroot -p

« Prev