MySQL enhances its performance through an optimization technique called Index Condition Pushdown (ICP). Let’s delve into the depths of ICP.
MySQL – Identifying Unused Indexes in Databases
Unused indexes slow down writes and waste space. Identifying unused indexes in your MySQL database is easy with INFORMATION_SCHEMA. Here is how.
MySQL – Identifying and Optimizing the Busiest Tables
Let us learn Identifying and Optimizing the Busiest Tables in MySQL. MySQL provides an easy way to identify the busiest tables using the performance_schema.
Reflections on Fireside Chat about Future of MySQL
I had the honor of participating in the Fireside Chat organized by Idera, where the discussion revolved around many different topics.
Long Running Queries in MySQL: Find Them in Two Ways
Find long running queries in MySQL with two built-in methods: the slow query log and the Performance Schema digest table. See the settings, a ready query and how to choose between them.
MySQL Configuration Changes: Track What Changed and When
MySQL configuration changes explain many sudden slowdowns. See how innodb_read_ahead_threshold works, what MySQL 8.0 records about a change and how to keep your own history.
MySQL – Wait For Seconds Using SELECT SLEEP()
For a WAIT FOR test in MySQL, I use SLEEP with a bounded delay. A customer asked for the corresponding command.