Fév 192012
 

Installation :

Debian :

gpg --keyserver  hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
gpg -a --export CD2EFD2A | apt-key add -
echo "deb http://repo.percona.com/apt lenny main" >> /etc/apt/sources.list.d/percona.list
echo "deb-src http://repo.percona.com/apt lenny main" >> /etc/apt/sources.list.d/percona.list
apt-get update
apt-get install percona-toolkit

Quelques commandes pour analyser les requêts MySQL :

Avec un tcpdump :

tcpdump -i eth0 port 3306 -s 65535 -c 10000 -x -n -q -tttt | pt-query-digest --type tcpdump --report-format=profile --limit=10

Avec les logs slow-query :

pt-query-digest --limit=10 /var/log/mysql/mysql-slow.log

Avec les binlogs :

mysqlbinlog /var/log/mysql/mysql-bin.XXXXXX | pt-query-digest --type binlog --limit=10

La documentation de Percona :
http://www.percona.com/doc/percona-toolkit/2.0/pt-query-digest.html

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre lang="" line="" escaped="" cssfile="">

(required)

(required)

Spam protection by WP Captcha-Free