pt-slave-delay is another great utility in the Percona Toolkit. Percona recently published a quick guide to using it, including how it can be helpful when somebody screws up.
http://www.mysqlperformanceblog.com/2012/09/11/how-to-lag-a-slave-behind-to-avoid-a-disaster
There's a great post over at the MySQL Performance Blog about visualization tools for pt-query-digest. If you haven't heard of the Percona Toolkit, you should get to know more about it. It is the successor to Maatkit and Aspersa, and is a great collection of utilities for MySQL database administrators. pt-query-digest can parse the slow query log, the general query log, the binlog, TCP dump files of the MySQL protocol, and even PostgreSQL, memcached, and HTTP packet dumps. It will aggregate the queries it finds into similar queries where possible, and has several report formats. It's a great tool for finding out what queries are really going to your database, so you can find and remove bottlenecks.
There are lots of other great tools in the Percona Toolkit, which I'll discuss in later posts.
There are lots of other great tools in the Percona Toolkit, which I'll discuss in later posts.
Subscribe to:
Posts
(
Atom
)