MySQL Uptime 확인

MySQL Uptime 확인
MySQL 업타임 확인
mysqld 프로세스 수행시간 확인

1 방법 1[ | ]

Bash

Copy

mysql -uroot -p패스워드 -e "status;" | grep Uptime

Console

Copy

[root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e "status;" | grep Uptime
Uptime:			85 days 9 hours 17 min 59 sec

2 방법 2[ | ]

Console

Copy

mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.5.34, for Linux (x86_64) using readline 5.1

Connection id:		1964519
Current database:	
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.5.34 MySQL Community Server (GPL)
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/var/lib/mysql/mysql.sock
Uptime:			85 days 9 hours 16 min 51 sec

Threads: 1  Questions: 28864214  Slow queries: 4  Opens: 424  Flush tables: 1  Open tables: 161  Queries per second avg: 3.912
--------------

3 방법 3: mysqladmin[ | ]

Console

Copy

[root@zetawiki ~]# mysqladmin stat -uroot -pP@ssw0rd
Uptime: 5047792  Threads: 1  Questions: 30711934  Slow queries: 0  Opens: 118  Flush tables: 1  Open tables: 111  Queries per second avg: 6.084

Console

Copy

[root@zetawiki ~]# mysqladmin status -uroot -pP@ssw0rd
Uptime: 5047792  Threads: 1  Questions: 30711934  Slow queries: 0  Opens: 118  Flush tables: 1  Open tables: 111  Queries per second avg: 6.084

→ 수행시간: 5047792 초

Console

Copy

[root@zetawiki ~]# mysqladmin version -uroot -pP@ssw0rd | grep ^Uptime
Uptime:			58 days 10 hours 9 min 31 sec

→ 수행시간: 58일 10시간 9분 31초

4 같이 보기[ | ]