MySQL 8 Query Performance Tuning

A Systematic Method for Improving Execution Speeds



Bookstore > Books > MySQL 8 Query Performance Tuning

Price$19.24 - $50.51
Rating
AuthorJesper Wisborg Krogh
PublisherApress
Published2020
Pages965
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484255836
ISBN-139781484255834
EBook Hardcover Paperback

Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue for your business. This book will help you make query tuning an integral part of your daily routine through a multi-step process that includes monitoring of execution times, identifying candidate queries for optimization, analyzing their current performance, and improving them to deliver results faster and with less overhead. Author Jesper Krogh systematically discusses each of these steps along with the data sources and the tools used to perform them.

MySQL 8 Query Performance Tuning aims to help you improve query performance using a wide range of strategies. You will know how to analyze queries using both the traditional EXPLAIN command as well as the new EXPLAIN ANALYZE tool. You also will see how to use the Visual Explain feature to provide a visually-oriented view of an execution plan. Coverage of indexes includes indexing strategies and index statistics, and you will learn how histograms can be used to provide input on skewed data distributions that the optimizer can use to improve query performance. You will learn about locks, and how to investigate locking issues. And you will come away with an understanding of how the MySQL optimizer works, including the new hash join algorithm, and how to change the optimizer's behavior when needed to deliver faster execution times. You will gain the tools and skills needed to delight application users and to squeeze the most value from corporate computing resources.

Monitor query performance to identify poor performers; Choose queries to optimize that will provide the greatest gain; Analyze queries using tools such as EXPLAIN ANALYZE and Visual Explain; Improve slow queries through a wide range of strategies; Properly deploy indexes and histograms to aid in creating fast execution plans; Understand and analyze locks to resolve contention and increase throughput.




Similar Books


SQL Server 2017 Query Performance Tuning

SQL Server 2017 Query Performance Tuning

by Grant Fritchey

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.This book covers ...

Price:  $44.98  |  Publisher:  Apress  |  Release:  2018

SQL Server 2012 Query Performance Tuning, 3rd Edition

SQL Server 2012 Query Performance Tuning, 3rd Edition

by Grant Fritchey

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 2012. I...

Price:  $46.34  |  Publisher:  Apress  |  Release:  2012

SQL Server Query Performance Tuning, 4th Edition

SQL Server Query Performance Tuning, 4th Edition

by Grant Fritchey

Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey's book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and t...

Price:  $62.75  |  Publisher:  Apress  |  Release:  2014

Oracle Database 11gR2 Performance Tuning Cookbook

Oracle Database 11gR2 Performance Tuning Cookbook

by Ciro Fiorillo

Oracle's Database offers great performance, scalability, and many features for DBAs and developers. Due to a wide choice of technologies, successful applications are good candidates to run into performance issues and when a problem arises it's very difficult to identify the cause and the right solution to the problem.The Oracle Database 1...

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2012

Java Performance Tuning

Java Performance Tuning

by Jack Shirazi

No matter what language they're programming in, developers always wish things would run faster! Especially when writing mission-critical applications, no one wants to be limited by the programming environment.Java Performance Tuning provides all the details you need to know to "performance tune" any type of Java program ...

Price:  $5.99  |  Publisher:  O'Reilly Media  |  Release:  2000

Professional SQL Server 2005 Performance Tuning

Professional SQL Server 2005 Performance Tuning

by Steven Wort, Christian Bolton, Justin Langford, Michael Cape, Joshua J. Jin, Douglas Hinson, Haidong Ji, Paul A. Mestemaker, Arindam Sen

Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. In addition, the authors demonstrate how to make use of the key tools for SQL Server Performance tuning.Broken into four parts, the book f...

Price:  $3.74  |  Publisher:  Wrox  |  Release:  2008

Oracle Database 11g Performance Tuning Recipes

Oracle Database 11g Performance Tuning Recipes

by Sam Alapati, Darl Kuhn, Bill Padfield

Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to lean back an...

Price:  $50.66  |  Publisher:  Apress  |  Release:  2011

Oracle Database 12c Performance Tuning Recipes

Oracle Database 12c Performance Tuning Recipes

by Sam Alapati, Darl Kuhn, Bill Padfield

Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to lean back an...

Price:  $46.46  |  Publisher:  Apress  |  Release:  2013