How to check mysql uptime (kiểm tra uptime của mysql)

How to check mysql uptime (kiểm tra uptime của mysql)
Display MySQL uptime in days

Để kiểm tra mysql or mariadb uptime bạn dùng lệnh sau:


Chạy lệnh \s trong mysql

mysql> \s
--------------
mysql Ver 14.14 Distrib 5.6.42, for Linux (x86_64) using EditLine wrapper

Connection id: 63078513
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.42-log 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: 45 days 2 hours 43 min 12 sec

Threads: 12 Questions: 2234578887 Slow queries: 610 Opens: 575 Flush tables: 1 Open tables: 512 Queries per second avg: 573.293
--------------