大网数据广告活动
服务器运维问答

Get mysql last uptime

· 52CE 我爱测

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

问题原文

原帖链接 · 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.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2016-04-04)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。