MySQL High Performance Tuning Guide
Tips for Tuning MySQL like a Pro | Learn how to prevent MySQL performance problems
4.30 (590 reviews)
3,261
students
3 hours
content
Jan 2025
last update
$69.99
regular price
What you will learn
Understand how MySQL optimizes and executes queries.
Find where MySQL spends most time on your query, and Why?
Finding those few queries that are responsible for most of the load on the system.
How to find the relevant information out of the plethora of performance views, and metrics available in MySQL?
How queries are automatically planned before execution, based on statistics and cost decisions?
Understand what a Clustered Index is?
How to choose the optimal Primary Key?
Find which tables are in need for an index, and which tables are better without one.
How we can help the MySQL Optimizer make better decisions?
Which are the common pitfalls, when using indexes on Multiple Columns?
Which are the use-cases, that make Redundant Indexes useful, and when to avoid them?
Cover the Best Practices for making Server Configurations
Which are the three options that MySQL is most likely to benefit, from non-default values, and also how to set them?
Data lifecycle in InnoDB, so that we have background knowledge when making configuration changes.
Get an overview of why Transactions and Locks are needed and some ways to reduce their impact.
Introduction to MySQL Scaling Options
Fundamental Concepts for Scaling Reads with Replication
How to Partition Data in MySQL
Fundamental Concepts for Scaling Writes with Queueing and Sharding
Screenshots
Related Topics
3980730
udemy ID
4/14/2021
course created date
9/9/2021
course indexed date
Bot
course submited by