
MySQL Performance


Optimizing MySQL 8 for Enhanced Write Performance: Key Configuration Strategies

Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?

How to configure the Number of Background InnoDB I/O Threads in MySQL 8 for performance?

How Parallel Redo Logs works in InnoDB works in MySQL 8?

Enhancing MySQL 8 on Modern Hardware: A Guide to Tuning InnoDB I/O Threads for Optimal Performance

Advanced Troubleshooting of MySQL Query Latency and Index Usage with eBPF: Scripts and Methodologies

Optimizing Complex SQL Joins in MySQL: The Impact of Multicolumn Indexes on Execution Plans
Multicolumn indexes, also known as composite indexes in MySQL, can significantly impact the execution plans of complex SQL JOIN operations. These indexes are defined on two or more columns of a table and can be highly effective in optimizing queries that involve conditions on those columns. […]

Troubleshooting MySQL Query Performance with Strace: A Practical Guide
After following the steps outlined in this guide, you should be able to diagnose and optimize the performance of a specific MySQL query using strace. By tracing the MySQL thread and analyzing the system calls captured in the mysql_strace.log file, you can identify potential bottlenecks and take appropriate optimization steps. […]

Effective Annotating of Strace Output for MySQL Performance Troubleshooting
“Annotating strace output is like adding signposts to the path of performance optimization, leading you to the heart of MySQL’s efficiency.” – MinervaDB What is Linux Process Snapper? Linux Process Snapper, commonly known as strace, is […]