How can I find, since when my MySQL Instance is running
login to your MySQL server and execute
mysql> show status like 'Uptime';
+---------------+---------+
| Variable_name | Value |
+---------------+---------+
| Uptime | 2507101 |
+---------------+---------+
1 row in set (0.00 sec)
Note:- The Uptime value displayed here is in Seconds. My MySQL instance is running since
2507101 seconds
OR
mysql> \s;
--------------
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
Connection id: 289795
Current database:
Current user: oracle@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.73-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 29 days 21 min 3 sec
Threads: 6 Questions: 14313149 Slow queries: 9 Opens: 77 Flush tables: 1 Open tables: 57 Queries per second avg: 5.709
--------------
ERROR:
No query specified
OR
mysql> status
--------------
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
Connection id: 289820
Current database:
Current user: oracle@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.73-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 29 days 28 min 45 sec
Threads: 6 Questions: 14314196 Slow queries: 9 Opens: 77 Flush tables: 1 Open tables: 57 Queries per second avg: 5.708
--------------
mysql>
No comments:
Post a Comment