.::: How to Check Uptime MariaDB & Service MariaDB MySQL server was started :::.

 

 

1. uptime 1
SHOW GLOBAL STATUS LIKE 'Uptime';
MariaDB [teguhth]> SHOW GLOBAL STATUS LIKE 'Uptime';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Uptime        | 165   |
+---------------+-------+
1 row in set (0.001 sec)

MariaDB [teguhth]>
 
2. uptime 2
select @@hostname,@@version, TIME_FORMAT(SEC_TO_TIME(VARIABLE_VALUE ),'%Hh %im')  as Uptime
from information_schema.GLOBAL_STATUS
where VARIABLE_NAME='Uptime';

MariaDB [teguhth]> select @@hostname,@@version, TIME_FORMAT(SEC_TO_TIME(VARIABLE_VALUE ),'%Hh %im')  as Uptime
    -> from information_schema.GLOBAL_STATUS
    -> where VARIABLE_NAME='Uptime';
+------------+-----------------+---------+
| @@hostname | @@version       | Uptime  |
+------------+-----------------+---------+
| teguhth    | 10.5.21-MariaDB | 00h 04m |
+------------+-----------------+---------+
1 row in set (0.000 sec)

MariaDB [teguhth]>

3. uptime 3
select @@hostname,@@version,now() - interval variable_value second as 'MySQL started on' from information_schema.global_status where variable_name='Uptime';

MariaDB [(none)]> select @@hostname,@@version,now() - interval variable_value second as 'MySQL started on' from information_schema.global_status where variable_name='Uptime';
+------------+-----------------+----------------------------+
| @@hostname | @@version       | MySQL started on           |
+------------+-----------------+----------------------------+
| teguhth    | 10.5.21-MariaDB | 2023-07-25 11:06:01.000000 |
+------------+-----------------+----------------------------+
1 row in set (0.001 sec)

MariaDB [(none)]>

4. uptime 4 complete
select @@hostname,@@version,now() - interval variable_value second as 'MySQL started on',TIME_FORMAT(SEC_TO_TIME(VARIABLE_VALUE ),'%Hh %im')  as Uptime from information_schema.global_status where variable_name='Uptime';

MariaDB [(none)]> select @@hostname,@@version,now() - interval variable_value second as 'MySQL started on',TIME_FORMAT(SEC_TO_TIME(VARIABLE_VALUE ),'%Hh %im')  as Uptime from information_schema.global_status where variable_name='Uptime';
+------------+-----------------+----------------------------+---------+
| @@hostname | @@version       | MySQL started on           | Uptime  |
+------------+-----------------+----------------------------+---------+
| teguhth    | 10.5.21-MariaDB | 2023-07-25 11:06:01.000000 | 00h 06m |
+------------+-----------------+----------------------------+---------+
1 row in set (0.001 sec)

MariaDB [(none)]>
 

5. uptime from OS 1
service mysqld status | grep running

[root@teguhth data]#  service mysqld status | grep running
Redirecting to /bin/systemctl status mysqld.service
   Active: active (running) since Tue 2023-07-25 11:06:01 WIB; 3min 4s ago
[root@teguhth data]#

6. uptime from mysqladmin

mysqladmin ver|grep Uptime
   
[root@teguhth data]#
[root@teguhth data]# mysqladmin ver|grep Uptime
Uptime:                 3 min 35 sec
[root@teguhth data]#

7. using command 1

 SELECT 
    @@hostname AS Hostname,
    @@version AS Version,
    NOW() - INTERVAL VARIABLE_VALUE SECOND AS 'MySQL started on',
    CONCAT(
        FLOOR(VARIABLE_VALUE / 86400), ' Days ',
        FLOOR(MOD(VARIABLE_VALUE, 86400) / 3600), ' Hours ',
        FLOOR(MOD(VARIABLE_VALUE, 3600) / 60), ' Minutes ',
        MOD(VARIABLE_VALUE, 60), ' Seconds'
    ) AS 'Uptime (dd-hh-mm-ss)'
FROM information_schema.GLOBAL_STATUS
WHERE VARIABLE_NAME = 'Uptime';
 

SELECT 
    @@hostname AS Hostname,
    @@version AS Version,
    NOW() - INTERVAL VARIABLE_VALUE SECOND AS 'MySQL started on',
    CONCAT(
        FLOOR(VARIABLE_VALUE / 86400), ':',
        LPAD(FLOOR(MOD(VARIABLE_VALUE, 86400) / 3600), 2, '0'), ':',
        LPAD(FLOOR(MOD(VARIABLE_VALUE, 3600) / 60), 2, '0'), ':',
        LPAD(MOD(VARIABLE_VALUE, 60), 2, '0')
    ) AS 'Uptime (dd:hh:mm:ss)'
FROM information_schema.GLOBAL_STATUS
WHERE VARIABLE_NAME = 'Uptime';