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.
MYSQL Long Running Queries
The data that used to be available freely now starts to get locked, and queries sprinting are now turning into long running queries.
Tracking Changes in MySQL Configuration
The next logical place to check what has changed is the configuration. Let us learn about Tracking Changes in MySQL Configuration.
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.