슬로우 쿼리 확인하기
| [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 |
'DB' 카테고리의 다른 글
| mysqladmin 활용 (0) | 2007.09.12 |
|---|---|
| mysql 튜닝 관련 (0) | 2007.09.12 |
| mysql MYSQL 슬로우 쿼리 mysql slow query 보기 (0) | 2007.09.12 |
| mysqladmin status 및 mysql 퍼포먼스 요소 찾아내기 (0) | 2007.08.28 |
| mysql에서 쿼리를 파일로 덤프뜨기~ (0) | 2007.08.21 |
