Query - When MySQL server/databas has been started

sholtan · #1 (**permalink**) 09-05-10, 15:30

I'm trying to find out when MySQL DATABASE/SERVER started and how long it has been running. Is there query or command in that I can use to check this? Is there more than one option to find this out and is it same for all MySQL versions or diffferent from version to version?

Thanks

guelphdad · #2 (**permalink**) 09-05-10, 15:49

from the mysql prompt:

Code:

\s

it-iss.com · #3 (**permalink**) 09-07-10, 10:55

If your server is running on Linux you can also use OS commands to determine the start date of the process. For instance:

Code:

ps -fu mysql

This will return the process information including the process ID and start time.

Code:

# ps -fu mysql
UID        PID  PPID  C STIME TTY          TIME CMD
mysql     3436  3385  0 Sep06 ?        00:02:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-external-locking --port=3306 --socket=/var/lib/

If the start time (STIME) is not sufficient in this case you can have a look at the process directory (using root):

Code:

ls -lad /proc/3436
dr-xr-xr-x 6 mysql mysql 0 Sep  6 21:45 /proc/3436

This directory is created when the process gets created and one exists for each process running on the server.

Internet Services

Web Development

Digital Marketing

Consumer Tech