HostOnNet Blog

mysqladmin

Looking for Linux Server Admin or WordPress Expert? We can help.

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.