MySQL Performance Blog

Percona's MySQL & InnoDB performance and scalability blog

Latest articles

Getting Started with MongoDB in OpenShift Using the Percona Server for MongoDB Kubernetes Operator

Kubernetes has become an integral part of many architectures and has continued to rise in popularity.  Kubernetes is an open source platform for managing containerized workloads and services.  One approach to running Kubernetes is Redhat’s OpenShift.  OpenShift is RedHat’s name for its family of containerization products.  The main part of OpenShift...

PostgreSQL on ARM-based AWS EC2 Instances: Is It Any Good?

The expected growth of ARM processors in data centers has been a hot topic for discussion for quite some time, and we were curious to see how it performs with PostgreSQL. The general availability of ARM-based servers for testing and evaluation was a major obstacle. The icebreaker was when AWS announced their ARM-based processors offering in their cloud...

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 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 with an example!...

Drain Kubernetes Nodes… Wisely

What is Node Draining? Anyone who ever worked with containers knows how ephemeral they are. In Kubernetes, not only can containers and pods be replaced, but the nodes as well. Nodes in Kubernetes are VMs, servers, and other entities with computational power where pods and containers run. Node draining is the mechanism that allows users to gracefully...

Keeping Open Source Open, or, Why Open is Better

Last week Elastic announced that they were “Doubling Down” on open source by changing their licensing to a non-open license – MongoDB’s Server Side Public License, or SSPL.  Let me clarify in my opinion this is not doubling down – unless, as our good friend @gabidavila highlighted, that maybe the thinking was a double negative makes a positive? VM Brasseur...

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 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 note yesterday...

The MySQL Clone Wars: 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 to a cluster using the plugin....

pg_stat_monitor: A New Way Of Looking At PostgreSQL Metrics

Enter pg_stat_monitor: this extension, created here at Percona, has been developed as an advanced replacement of pg_stat_statement, providing new capabilities in addition to the standard fare. As you may recall, PostgreSQL’s pg_stat_statements extension provides a means of tracking execution statistics of all SQL statements executed by the server....

Updates to Percona XtraDB Cluster, New Features in Percona Toolkit 3.3.0: Release Roundup January 18, 2021

It’s release roundup time here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Today’s post includes...

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 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 way to get the process...

Discover, share and read the best on the web

Subscribe to RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters! Get unfiltered news feeds or filter them to your liking.

Get Inoreader
Inoreader - Subscribe to RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters!