The Percona eBook, "MySQL Logs," is comprised of 4 chapters. The first, by Percona Senior Knowledge Manager Bill Karwin, focuses on Percona Toolkit's pt-query-digest, a tool indispensable for identifying your top SQL queries, and analyzing which queries are accounting for your database load. In Chapter 2, "Rotating MySQL slow logs safely," Peter Boros shares key lessons he learned when logging a high volume of queries to the slow log. In Chapter 3, "Impact of logging on MySQL's performance," Aleksandr Kuzminsky uses Percona's microslow patch to reveal logging impacts on performance. Chapter 4, by Percona CEO and founder Peter Zaitsev, answers the question: "How to find MySQL queries worth optimizing?”
Visit Percona's eBook Library for more selections (new additions added regularly).