DBA Archives

Best Practices to Optimize Pagination Queries in MariaDB

Pagination in MariaDB, like in other databases, requires careful consideration of performance and consistency. Basic pagination with LIMIT and OFFSET is straightforward but might not be the best approach for large datasets due to performance issues. […]

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

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

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

What’s new and changed with MariaDB 10.8?

What’s new and changed with MariaDB 10.8? Added support for IN,OUT and INOUT qualifying parameters for stored functions in MariaDB 10.8, MariaDB already supports IN, OUT and INOUT parameters. This contribution was made by ManoharKB […]

Amazon Aurora Multi-Master expands availability to 8 AWS Regions

Amazon Aurora Multi-Master expands availability to 8 AWS Regions Amazon Aurora Multi-Master is a single database that allows you to create multiple read-write instances of your Aurora database across multiple Availability Zones, which enables uptime-sensitive […]

Choosing Backup and DR Strategies for your MariaDB Infrastructure

Choosing Backup and DR Strategies for your MariaDB Infrastructure Backup in simple terms is just copying data and retaining the same in some persistent storage ( in logical / SQL or binary format ) to […]