Differences

This shows you the differences between two versions of the page.

Link to this comparison view

display_mysql_uptime [2019-03-20 12:16:07] (current)
shaun.reitan created
Line 1: Line 1:
 +====== How to display MySQL or MariaDB server uptime ======
 +
 +The following command is a example of how to display your MySQL, or MariaDB server uptime.
 +
 +In the example below we are connecting to the SQL server as the user root and telling the client utility to prompt us for the password. If your my.cnf already contains a user and password you can remove the -u and -p options as they are not needed.
 +
 +<code console>
 +mysql -u root -p -e '​\s'​
 +</​code>​
 +
 +Below is an example of what the output should look like
 +<code console>
 +[root@server ~]# mysql -e '​\s'​
 +Enter password: <​hidden>​
 +
 +mysql  Ver 15.1 Distrib 10.2.22-MariaDB,​ for Linux (x86_64) using readline 5.1
 +
 +Connection id:          383224
 +Current database:
 +Current user:           ​root@localhost
 +SSL:                    Not in use
 +Current pager: ​         stdout
 +Using outfile: ​         ''​
 +Using delimiter: ​       ;
 +Server: ​                ​MariaDB
 +Server version: ​        ​10.2.22-MariaDB MariaDB Server
 +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: ​                7 hours 46 min 2 sec
 +
 +Threads: 66  Questions: 18880499 ​ Slow queries: 0  Opens: 824083 ​ Flush tables: 1  Open tables: 2000  Queries per second avg: 675.219
 +</​code>​
 +