MySQL

Low Value in range_optimizer_max_mem_size Might Cause Full Table Scan

range_optimizer_max_mem_size Might Cause Full Table Scan

Although how range_optimizer_max_mem_size operates is explained in the official doc, it’s not a well-known variable and surely not a variable you need to modify under most circumstances. But from time to time we get some performance tickets related to this.
What problem does this variable cause if it is not properly sized? Let’s find out […]

Read more

MySQL 8.0.23 Is Available: Highlighting Some Important Points

MySQL 8.0.23 Is Available

As many of you have seen already, MySQL 8.0.23 is available for download (release notes).
Today our dear LeFred thanked all the numerous contributors to bug fixes.  About this: let me mention our two people involved in bug fixing, Venkatesh Prasad Venugopal and Kamil Hołubicki. Great work guys!
On my side, I have reviewed the release […]

Read more

The MySQL Clone Wars: Plugin vs. Percona XtraBackup

MySQL Plugin vs. Percona XtraBackup

Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a replica from another server.
The Clone Plugin, available since MySQL 8.0.17, is a great feature that allows cloning databases out of the box. It is easy to rebuild a replica or to add new nodes […]

Read more

MySQL 8.0.22: SHOW PROCESSLIST Version 2 – Now Available From PERFORMANCE_SCHEMA

SHOW PROCESSLIST Version 2

The “SHOW PROCESSLIST” command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the thread manager, and it needs the global mutex. From MySQL 8.0.22, we have an alternative […]

Read more

How to Store MySQL Audit Logs in MongoDB in a Maintenance-Free Setup

Store MySQL Audit Logs in MongoDB

I was once helping one of our customers on how to load MySQL audit logs into a MySQL database and analyze them. But immediately I thought: “Hey, this is not the most efficient solution! MySQL or typical RDBMS, in general, were not really meant to store logs after all.”
So, I decided to explore an […]

Read more