Get mysql last uptime

Question

I just restarted the MySQL service.

I know how to get the current Uptime, but by any chance is there a way to get the uptime before last restart ?

Thanks

Answer 1

I had almost the same problem. I solved it this way:

1) Insert into my.cnf this line:

init_file = /some-path/startup.sql

2) In the file startup.sql you have these MySQL commands:

CREATE TABLE IF NOT EXISTS MySqlServerLog ( MySqlServerStarted DATETIME );
INSERT INTO MySqlServerLog SET MySqlServerStarted = NOW();

Each time you start/restart the MySQL server this script is executed and it logs very simple the exact start time.

The uptime can be then very easy calculated for each start/restart.