]]> ]]>

You are here

MySQL Logs

March, 2014

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). 

Stored Under:

Authors

Aleksandr Kuzminsky

Aleksandr Kuzminsky

Software Engineer

Aleksandr'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.


Bill Karwin

Bill Karwin

Senior Knowledge Manager

Bill 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 Boros

Peter Boros

Principal Architect

Peter 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

Peter Zaitsev

CEO

Peter co-founded Percona in 2006, assuming the role of CEO. Percona helps companies of all sizes maximize their success with MySQL. Percona was named to the Inc. 5000 in 2013. 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. As CEO of Percona, Peter enjoys mixing business leadership with hands on technical expertise.



]]>