HostOnNet Blog

mysqladmin

mysqladmin is a command line tool provided as part of MySQL.

To list MySQL run time variables, run

mysqladmin variables

To see value of open_files_limit, use grep with mysqladmin, for example

mysqladmin variables | grep open_files_limit

mysqladmin

MySQL Status

mysqladmin status

Example

[root@3blogger ~]# mysqladmin status
Uptime: 77583  Threads: 2  Questions: 6139715  Slow queries: 28173  Opens: 18232  Flush tables: 2  Open tables: 457  Queries per second avg: 79.137
[root@3blogger ~]# 

Posted in MySQL