Wednesday, 26 December 2018

Get the MySQL Uptime, version and port details at one query

 mysql> status
--------------
mysql  Ver 14.14 Distrib 5.7.19, for Win64 (x86_64)

Connection id:          9
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.7.19-log MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3307
Uptime:                 38 min 53 sec

Threads: 5  Questions: 300  Slow queries: 0  Opens: 1323  Flush tables: 1  Open
tables: 402  Queries per second avg: 0.128
--------------

No comments:

Post a Comment