• View
• Edit
• History
• Print

How-to-check-mysql-status

How to check your mysql server status.

mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.5.27, for Linux (i686) using readline 5.1

Connection id:		2
Current database:	
Current user:		fedora@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.5.27 MySQL Community Server (GPL)
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/var/lib/mysql/mysql.sock
Uptime:			32 min 10 sec

Threads: 1  Questions: 16  Slow queries: 0  Opens: 33  
Flush tables: 1  Open tables: 26  Queries per second avg: 0.008
--------------

mysql>