View MySQL startup time and running time

You can use show and updtime or directly use grep MySQL-related parameters in linux to check the mysql startup time and duration. Let's take a look.

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

Show global status like 'uptime ';

2. Use linux commands to view

[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 this service was launched on July 5, June 5.

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

Www. bKjia. c0m the MySQL server has been running for 0 days, 6 hours, 30 minutes, 16 seconds, and the start time is January 02, 2014.