1 頁 (共 1 頁)

Percona Toolkit

發表於 : 2016-10-12 11:19:56
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

Re: Percona Toolkit

發表於 : 2016-10-12 11:29:21
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