Articles by Shiv Iyer

About Shiv Iyer

Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.

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 […]

Monitoring Query Memory Consumption in MySQL with Performance Schema

Optimizing MySQL InnoDB I/O: Effective Strategies for Tuning innodb_io_capacity and innodb_io_capacity_max

Optimizing innodb_io_capacity and innodb_io_capacity_max is a crucial step in maximizing the I/O capabilities of your MySQL instance’s underlying storage hardware. By fine-tuning these parameters, you can align InnoDB’s I/O operations with your hardware’s performance characteristics, resulting in improved overall database efficiency. […]

Unlocking MySQL’s Performance Potential: Navigating the Impact of Queue Waits and Optimizing for Peak Efficiency

Queue waits in MySQL occur when processes or threads wait in a queue before execution. This typically happens when system resources are overutilized, and the server cannot immediately process incoming requests. Queue waits can significantly impact MySQL performance, especially in high-concurrency environments. […]

Troubleshooting signal waits happening to MySQL

Troubleshooting signal waits in MySQL can be a challenging task for database administrators. This insightful article delves into the complexities of signal waits, offering valuable guidance on identifying and resolving these issues. […]

Optimizing PostgreSQL Performance: A Guide to Using pg_test_fsync for Effective Fsync Method Selection

Optimizing PostgreSQL performance is an art, and the right fsync method can make all the difference. Explore how to select the most effective fsync method using pg_test_fsync in our latest guide: https://minervadb.xyz/optimizing-postgresql-performance-a-guide-to-using-pg_test_fsync-for-effective-fsync-method-selection/ 🚀 #PostgreSQL #DatabasePerformance […]

Creating and Implementing Custom Sequences in MySQL 8

Introduction – Custom Sequences in MySQL 8 In MySQL, a table-based sequence is used to generate a sequence of numbers, typically for auto-incrementing primary keys. However, unlike some other databases, MySQL does not have a […]

Managing MySQL Connection Overhead: Understanding the CJ Abandoned Connection Cleanup Thread

MySQL Connection In the context of MySQL and its Connector/J (the JDBC driver for MySQL), the “CJ Abandoned Connection Cleanup” thread is a background thread responsible for cleaning up abandoned JDBC connections. The application does […]

Optimizing MySQL Throughput: Fine-Tuning InnoDB Thread Concurrency

Configuring innodb_thread_concurrency allows you to control the number of threads that can enter InnoDB concurrently. Setting this value correctly can greatly improve the performance of your MySQL server, especially during times of high concurrency. Here is […]

Automating MySQL Slow Query Log Management with Logrotate

In managing MySQL databases, it’s crucial to keep the slow query log under control to avoid excessive disk usage and to maintain a clear history of queries that may need optimization. Logrotate serves as an invaluable tool for this task, allowing for automatic weekly archiving of the slow query log, compressing old logs, and thus ensuring your logging system is both efficient and manageable. This routine contributes significantly to a robust and well-maintained MySQL server, leading to improved performance and streamlined troubleshooting. […]