Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 15, 2019
MySQL: The Impact of Transactions on Query Throughput
Recently I had a customer where every single query was running in a transaction, as well as even the simplest [...]
July 10, 2019
Percona XtraBackup 2.4.15 Is Now Available
Percona is glad to announce the release of Percona XtraBackup 2.4.15 on July 10, 2019. You can download it from our [...]
July 3, 2019
Blog Poll: What Keeps You Up At Night?
Last year, we asked you a few questions in a blog poll and we received a great amount of feedback. [...]
July 3, 2019
Percona Server for MySQL Highlights – binlog_space_limit
I think it is often confusing to compare upstream MySQL and Percona Server for MySQL, and some helpful information can [...]
July 1, 2019
MySQL to the Cloud! Thoughts on Migrating Away from On-Premise
The CTO has issued the decree: “We are moving to the cloud!” Great, so now what do we do? When [...]
July 1, 2019
Setting World-Writable File Permissions Prior to Preparing the Backup Can Break It
It’s bad practice to provide world-writable access to critical files in Linux, though we’ve seen time and time again that [...]
June 27, 2019
InnoDB ALTER TABLE ADD INDEX and INSERT performance
In my previous blog post, I explained the internals of the sorted index build process. The blog ended with saying [...]
June 26, 2019
Percona XtraDB Cluster 5.7.26-31.37 Is Now Available
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from [...]
June 26, 2019
Stored Functions and Temporary Tables are Not a Good Fit
In this blog post, I am going to show why we have to be careful with stored functions in select [...]
June 25, 2019
Adaptive Hash Index on AWS Aurora
Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In [...]
June 24, 2019
pt-kill: How it Works
I receive many questions about errors being reported about pt-kill… and often those errors are not real. The main problem [...]
June 19, 2019
Percona XtraDB Cluster 5.6.44-28.34 Is Now Available
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.44-28.34 on June 19, 2019. Binaries are available from the [...]
June 7, 2019
How pt-online-schema-change Handles Foreign Keys
Foreign key related issues are very common when dealing with DDL changes in MySQL using Percona toolkit. In this blog [...]
June 5, 2019
Enterprise Database Solution – Maximizing Return for the Lowest Cost
It used to be easy: a company developed a new application, chose a database solution, launched the new application and [...]
June 4, 2019
DDL Queries on Foreign Key Columns in MySQL/PXC
Recently, I received a support request where the customer wanted to convert an INTEGER column to BIGINT on two tables. [...]
May 31, 2019
RHEL 8 Packages Available for Percona Products
Redhat Enterprise Linux 8 packages have been released into our repositories. Recent versions of Percona Server for MySQL, Percona XtraDB [...]
May 30, 2019
Percona Live Community Dinner 2019
It was all aboard the Lone Star river boat for the 100 delegates who joined our Community Dinner. Loading took [...]
May 30, 2019
Percona Monitoring and Management (PMM) 2 Beta Is Now Available
We are pleased to announce the release of PMM 2 Beta! PMM (Percona Monitoring and Management) is a free and open-source [...]
May 29, 2019
MySQL Community Awards at Percona Live 2019
It’s that time of year again, and we’ve just had the presentations of the MySQL Community Awards at Percona Live. [...]