问题原文
原帖链接 · FLX · CC BY-SA 3.0
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
已采纳解答
原帖链接 · Peter VARGA · CC BY-SA 3.0
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.
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
