슬로우 쿼리 확인하기

 

 

 [root@sk4 18:41:08 /env/mysql/data]# mysqladmin -i5 status -u root -p
Enter password:
Uptime: 682506  Threads: 1  Questions: 1840965  Slow queries: 17742  Opens: 15198  Flush tables: 1  Open tables: 256  Queries per second avg: 2.697
Uptime: 682511  Threads: 1  Questions: 1840965  Slow queries: 17742  Opens: 15198  Flush tables: 1  Open tables: 256  Queries per second avg: 2.697
Uptime: 682516  Threads: 1  Questions: 1840976  Slow queries: 17742  Opens: 15198  Flush tables: 1  Open tables: 256  Queries per second avg: 2.697
Uptime: 682521  Threads: 1  Questions: 1840980  Slow queries: 17742  Opens: 15198  Flush tables: 1  Open tables: 256  Queries per second avg: 2.697

Posted by 김용환 '김용환'

댓글을 달아 주세요