Blog

MySQL Performance

Optimizing MySQL 8 Performance with Group Commit

Comprehensive Guide to Optimizing MySQL 8 Performance with Group Commit: Understanding, Fine-Tuning System Variables, and Monitoring Techniques for Enhanced Throughput and Reduced Disk I/O Overhead Group commit in MySQL 8 is a critical feature that […]
No Picture
PostgreSQL Troubleshooting

How to monitor live sessions in PostgreSQL?

In PostgreSQL, you can monitor live sessions using a few different methods: You can use any of these methods to monitor live sessions in PostgreSQL, depending on your needs and the resources available to you. […]
No Picture
PostgreSQL Internals

How to use Hash Joins in PostgreSQL?

In PostgreSQL, hash joins are used to join two tables based on a join condition that involves equality comparisons. The optimizer automatically chooses this join method if it determines that a hash join would be […]
No Picture
PostgreSQL Internals

Optimizer index caching in PostgreSQL

Optimizer index caching in PostgreSQL is the process by which the database caches the index pages in memory to speed up the execution of queries. This feature helps improve the performance of queries by reducing […]
No Picture
MySQL Performance

When MySQL ignores histograms?

MySQL can ignore histograms in the query optimizer when it determines that using the histograms would not provide any benefit to the query execution plan. This can occur in several cases, including: Why MySQL ignores […]