MySQL 8 Query Performance Tuning
A Systematic Method for Improving Execution Speeds
| Price | $19.24 - $28.25
|
| Rating |   |
| Author | Jesper Wisborg Krogh |
| Publisher | Apress |
| Published | 2020 |
| Pages | 965 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484255836 |
| ISBN-13 | 9781484255834 |
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.
- Jesper Wisborg Krogh (3 books)
4 5 6
Similar Books
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: $53.39 | Publisher: Apress | Release: 2018
SQL Server 2022 Query Performance Tuning, 6th Edition
by Grant Fritchey
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expand...
Price: $44.99 | Publisher: Apress | Release: 2022
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 20...
Price: $46.34 | Publisher: Apress | Release: 2012
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 ...
Price: $77.64 | Publisher: Apress | Release: 2014
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 le...
Price: $46.46 | Publisher: Apress | Release: 2013
SQL Server Advanced Troubleshooting and Performance Tuning
by Dmitri Korotkevitch
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts ...
Price: $56.95 | Publisher: O'Reilly Media | Release: 2022
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 ...
Price: $32.99 | Publisher: Packt Publishing | Release: 2012
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 pro...
Price: $5.99 | Publisher: O'Reilly Media | Release: 2000