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).
About the Authors
Aleksandr KuzminskyAleksandr's first experiences using MySQL were in 2000, as a developer and as a system administrator at an Internet Services Provider. Since then, he has also acquired a great deal of experience in a variety of different Unix variants and network services, as well as in Operational Support Systems and Business Support Systems (OSS/BSS) development. Prior to joining Percona, he taught Cisco courses and built multi-service Multiprotocol Label Switching (MPLS) networks in Ukraine and in the Caucasian countries. At Percona, he specializes in InnoDB and MyISAM data recovery. Aleksandr lives with his family in the suburbs of Kiev. He enjoys playing with his young son and gardening.
Bill KarwinBill Karwin has been a software engineer for over twenty years, developing and supporting applications, libraries, and servers such as Zend Framework for PHP 5, the InterBase relational database, and the Enhydra Java application server. Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems. Bill authored the book "SQL Antipatterns", collecting frequent blunders and showing better solutions.
Peter BorosPeter joined the European consulting team in May 2012. Before joining Percona, among many other things, he worked at Sun Microsystems, specialized there in performance tuning and was a DBA at Hungary's largest social networking site. He also taught many Oracle University MySQL courses. He has been using and working with open source software from early 2000s. Peter's first and foremost professional interest is performance tuning. He currently lives in Herceghalom, Hungary with his wife and son.
Peter Zaitsev co-founded Percona and assumed the role of CEO in 2006. As one of the foremost experts on MySQL strategy and optimization, Peter leveraged both his technical vision and entrepreneurial skills to grow Percona from a two-person shop to one of the most respected open source companies in the business. With over 140 professionals in 30 plus countries, Peter’s venture now serves over 3000 customers – including the “who’s who” of internet giants, large enterprises and many exciting startups. Percona was named to the Inc. 5000 in 2013, 2014, 2015 and 2016. Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science. Peter is a co-author of High Performance MySQL: Optimization, Backups, and Replication, one of the most popular books on MySQL performance. Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog. He has also been tapped as a contributor to Fortune and DZone, and his recent ebook Practical MySQL Performance Optimization Volume 1 is one of percona.com’s most popular downloads. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.