Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 21, 2021
Low Value in 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 [...]
January 20, 2021
MySQL 8.0.23 Is Available: Highlighting Some Important Points
As many of you have seen already, MySQL 8.0.23 is available for download (release notes). Today our dear LeFred thanked [...]
January 15, 2021
MySQL 8.0.22: SHOW PROCESSLIST Version 2 – Now Available From PERFORMANCE_SCHEMA
The “SHOW PROCESSLIST” command is very famous and very useful for MySQL DBAs. It will help you to understand the [...]
January 11, 2021
A Snippet of Features: Reviewing PostgreSQL Version 13
This latest and greatest version of PostgreSQL, version 13, has been here since last summer and continues the tradition of [...]
January 8, 2021
Updated MySQL OSMetrics Plugins
It has been some time since I have posted updates to my plugins. After the initial version, I decided to [...]
January 4, 2021
Percona Monthly Bug Report: December 2020
Here at Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best [...]
November 23, 2020
Uncommon Sense MySQL – When EXPLAIN Can Trash Your Database
If I ask you if running EXPLAIN on the query can change your database, you will probably tell me NO; [...]
November 9, 2020
OpenEBS for the Management of Kubernetes Storage Volumes
I recently wrote about OpenEBS in regard to local volumes in my post Deploying Percona Kubernetes Operators with OpenEBS Local [...]
November 6, 2020
Various Backup Compression Methods Using Mysqlpump
Mysqlpump is a client program that was released with MySQL 5.7.8 and is used to perform logical backups in a [...]
November 5, 2020
New in MongoDB 4.4: Hidden Index
We already presented a previous article on the index types available on MongoDB. MongoDB 4.4 was released a few months [...]
October 30, 2020
Percona Monthly Bug Report: October 2020
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source [...]
October 27, 2020
Using MySQL 8 Persisted System Variables
This blog discusses new features about the persisted system variables and how we can use it to make variable changes [...]
October 26, 2020
MySQL 8.0.22: Asynchronous Replication Automatic Connection (IO Thread) Failover
MySQL 8.0.22 was released on Oct 19, 2020, and came with nice features and a lot of bug fixes. Now, [...]
October 26, 2020
Community Contributors Invited to Update Percona Monitoring and Management Documentation
Percona is making changes in its documentation processes for Percona Monitoring and Management (PMM) to make it easier and more [...]
October 19, 2020
PMM 101: Troubleshooting MongoDB with Percona Monitoring and Management
Percona Monitoring and Management (PMM) is an open-source tool developed by Percona that allows you to monitor and manage your [...]
October 19, 2020
5 Things Developers Should Know Before Deploying MongoDB
MongoDB is one of the most popular databases and is one of the easiest NoSQL databases to set up. Oftentimes, [...]
October 7, 2020
Webinar October 27: Disaster Recovery and High Availability – The Concepts, The Mistakes, and How To Properly Plan For Failure
Any good system must be built to expect the unexpected. None are perfect and at some point, something WILL happen [...]
October 7, 2020
Our Approach to Percona Monitoring and Management Upgrade Testing
Hey Community! This is my first blog post so let me introduce myself. My name is Vasyl Yurkovych. I am [...]
October 2, 2020
How to Use CHECK Constraint in MySQL 8
Hello everyone, in this little post we will review a new feature in MySQL 8. What is “CHECK Constraint”? This [...]
October 2, 2020
Rate Limit (Throttle) for MySQL with ProxySQL
Maybe one of the more “obscure” operations when dealing with replica lag, or, in general, when one needs to control [...]