]]> ]]>

You are here

MySQL Query Optimization

May, 2014

MySQL query optimization should not be based on guesses, but exact measurements. A proper measurement of these units is the first important task in MySQL performance optimization. This Percona eBook explains how to do this with Percona Cloud Tools. We'll also examine the best way to analyze WordPress MySQL queries with "Query Analytics." We'll also share other tools and tips for analyzing MySQL's slow query log; and finally we'll compare PERFORMANCE_SCHEMA vs Slow Query Log.

Stored Under: Best Practices, Operations, Query Tuning and Optimization

Authors

Muhammad Irfan

Muhammad Irfan

Software Engineer

Muhammad Irfan is vastly experienced in the LAMP Stack. He joined Percona in December 2012 as Support Engineer. Prior to joining Percona, he worked in the role of MySQL DBA & LAMP Administrator, maintained high traffic websites, and worked as a Consultant. His professional interests focus on MySQL scalability and on performance optimization. In his spare time, he normally spends time with family and friends and loves to play and watch cricket. He currently lives in Karachi, Pakistan, 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.


Vadim Tkachenko

Vadim Tkachenko

CTO

Vadim leads Percona's Development group which produces the Percona Server, Percona XtraDB, and Percona XtraBackup. He is an expert in LAMP performance, especially optimizing MySQL and InnoDB internals to take full advantage of modern hardware using his multi-threaded programming background. Source code patches authored by Vadim have been incorporated by Oracle Corporation and its predecessors into the mainstream MySQL and InnoDB products. At Percona, Vadim also designs no-gimmicks benchmark tests of hardware, filesystems, storage engines, and databases.



]]>