Percona Toolkit

回覆文章
yehlu
Site Admin
文章: 3245
註冊時間: 2004-04-15 17:20:21
來自: CodeCharge Support Engineer

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
Site Admin
文章: 3245
註冊時間: 2004-04-15 17:20:21
來自: CodeCharge Support Engineer

Re: Percona Toolkit

文章 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
回覆文章

回到「MySQL」