Percona Toolkit

[yehlu]

http://blog.chinaunix.net/uid-25266990-id-3405952.html

https://www.percona.com/downloads/percona-toolkit/

代碼: 選擇全部

wget https://www.percona.com/downloads/percona-toolkit/2.2.19/deb/percona-toolkit_2.2.19-1_all.deb
sudo dpkg -i percona-toolkit_2.2.19-1_all.deb
sudo apt-get install libdbi-perl
sudo apt-get -f install

代碼: 選擇全部

wget https://www.percona.com/downloads/percona-toolkit/2.2.19/RPM/percona-toolkit-2.2.19-1.noarch.rpm
yum install percona-toolkit-2.2.19-1.noarch.rpm

[yehlu]

代碼: 選擇全部

pt-query-digest

--review h=localhost,D=database,t=query_review,p=mysql,u=root \

--review-history h=localhost,D=satabase,t=query_review_history,p=mysql,u=root \

--filter=" \$event->{Bytes} = length(\$event->{arg}) and \$event->{hostname}=\"$HOSTNAME\"" mysqld-slow-queries.log                                

ctrl-D