MySQL Uptime
SELECT
VARIABLE_VALUE AS Uptime_seconds,
NOW() AS “Now”,
NOW() – INTERVAL VARIABLE_VALUE SECOND AS “Up since”,
DATEDIFF(NOW(), NOW() – INTERVAL VARIABLE_VALUE SECOND) AS “Uptime_days”
FROM performance_schema.session_status
WHERE VARIABLE_NAME = ‘Uptime’;
Output Example:
+—————-+———————+—————————-+————-+
| Uptime_seconds | Now | Up since | Uptime_days |
+—————-+———————+—————————-+————-+
| 16430228 | 2021-04-09 14:11:58 | 2020-10-01 10:14:50.000000 | 190 |
+—————-+———————+—————————-+————-+
Leave a Reply