MySQL Quick Status

By: Javier on 1/24/2013

Si deseas obtener información sencilla pero útil de tu base de datos, únicamente ejecuta \s, con la que obtendrás una pequeña salida del estado del servidor.

mysql> \s
--------------
mysql  Ver 14.14 Distrib 5.5.25a, for Linux (i686) using readline 5.1

Connection id:      464882
Current database:    test
Current user:      root@localhost
SSL:       Not in use
Current pager:      stdout
Using outfile:      ''
Using delimiter:     ;
Server version:      5.5.25a-27.1-log Percona Server (GPL), Release 27.1
Protocol version:    10
Connection:      Localhost via UNIX socket
Insert id:      6
Server characterset: latin1
Db     characterset: latin1
Client characterset: latin1
Conn.  characterset: latin1
UNIX socket:      /var/run/mysqld/mysqld.sock
Uptime:       71 days 19 hours 46 min 2 sec

Threads: 10
Questions: 67830202
Slow queries: 30
Opens: 10555
Flush tables: 1
Open tables: 400
Queries per second avg: 10.930
--------------