February 20 2015

Practical Query Optimization for MySQL and PostgreSQL

Practical Query Optimization for MySQL and PostgreSQL

In this book, you’ll learn how to find, evaluate, and improve the queries running on your database servers.

Query Optimization

Profiling database workload - the first step to optimizing performance

Your database’s sole purpose is to store data and enable you and your applications to query and manipulate the data. Given that queries (statements, more generally) are the single most important function your servers perform, one of your most important tasks as a DBA or developer is to understand your overall server workload and ensure servers are doing their jobs optimally. There are several reasons to optimize your queries, and each is important for different user, application, and business goals:

  • Improve user experience
  • Boost revenues
  • Reduce server load and increase capacity
  • Reduce collateral damage
  • Prevent future problems

In this 33-page ebook, you’ll learn how to find, evaluate, and improve the queries running on your database servers. It provides a simple, logical process for making sure your database’s workload is optimal. If a query is causing a problem or needs to be optimized or eliminated, you’ll find it. You won’t wonder “can anything be improved?” because you’ll know.

This book is the first in a series. It teaches you the tools and techniques you’ll need to profile one or many MySQL or PostgreSQL databases. Further books will explain how to speed up the queries that you select for optimization as a result of profiling, so stay tuned for more!

 

Download Your Free Copy Today!