How to view how long MySQL has been running

1. uptime can be used to view the system running time

Show global status like 'uptime ';

2. Use linux commands to view

There is an uptime in Linux to view the running time of the system, but MySQL does not have this command.

However, the ps command can also be used.

[Root @ dbserver ~] # Ps aux | grep mysql
Root 29090 0.0 0.0 70232 1364? S Jun05 0: 00/bin/sh/usr/bin/mysqld_safe -- datadir =/data/mysql -- pid-file =/data/mysql/dbserver. pid

As you can see, Jun05 indicates that the service was started on July 22, June 5. How long has it been running?

3. You can view the following information in the phpmyadmin status:

The MySQL server has been running for 6 hours, 30 minutes and 16 seconds, and the start time is January 02, 2014.