mysqldumpslow

slowquery.log 를 분석한다

/etc/my.cnf 에

[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data

를 설정한다.


mysqldumpslow -s c

-s sort_type
How to sort the output. The value of sort_type should be chosen from the following list:
t, at: Sort by query time or average query time
l, al: Sort by lock time or average lock time
r, ar: Sort by rows sent or average rows sent
c: Sort by count
By default, mysqldumpslow sorts by average query time (equivalent to -s at).<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>