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';
mysql> 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';
+----------------+---------------------+----------------------------+-------------+
| Uptime_seconds | Now | Up since | Uptime_days |
+----------------+---------------------+----------------------------+-------------+
| 100752 | 2021-12-27 10:02:34 | 2021-12-26 06:03:22.000000 | 1 |
+----------------+---------------------+----------------------------+-------------+
1 row in set (0.01 sec)
mysql> SHOW GLOBAL STATUS LIKE '%UPTIME%';
+---------------------------+--------+
| Variable_name | Value |
+---------------------------+--------+
| Uptime | 100776 |
| Uptime_since_flush_status | 100776 |
+---------------------------+--------+
2 rows in set (0.00 sec)
No comments:
Post a Comment