DBA Hub

📋Steps in this guide1/1

How to find startup time and uptime MySQL

MariaDB [(none)]> status; -------------- mysql Ver 15.1 Distrib 10.4.18-MariaDB, for Win64 (AMD64), source revision 53123dfa3e365138591fd2f160c6057aca00a3e6

mysql configurationintermediate
by MYSQL
12 views
1

How to find startup time and uptime MySQL

Alternative command Server startup time:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
MariaDB [(none)]>
status;
--------------
mysql Ver 15.1 Distrib 10.4.18-MariaDB, for Win64 (AMD64), source revision 53123dfa3e365138591fd2f160c6057aca00a3e6
Connection id: 26
Current database:
.............
TCP port: 3306
Uptime: 4 days 19 hours 28 min 14 sec
MariaDB [(none)]>
\s
MariaDB [(none)]>
select TIME_FORMAT(SEC_TO_TIME(VARIABLE_VALUE ),'%Hh %im') as Uptime from information_schema.GLOBAL_STATUS where VARIABLE_NAME='Uptime';
+----------+
| Uptime.  |
+----------+m
|
115h 30m
|
+----------+
1 row in set (0.007 sec)
C:\Program Files\MariaDB 10.4\bin>
mysqladmin version -u root -p
Enter password: ****
mysqladmin Ver 9.1 Distrib 10.4.18-MariaDB, for Win64 on AMD64 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version 10.4.18-MariaDB
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 4 days 19 hours 33 min 2 sec

Comments (0)

Please to add comments

No comments yet. Be the first to comment!