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.
mysql -u root -p -e '\s'
Below is an example of what the output should look like
[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