Percona's MySQL & InnoDB performance and scalability blog
91k followers 8 件/週
Resume Your Failed pt-online-schema-change Job

Starting from Percona Toolkit 3.6.0, you can resume pt-online-schema-change if it was interrupted. This blog describes the prerequisites and usage of the new –resume option. To restart the job, you need to know where it failed. This is why the first option you must use is –history. It instructs pt-online-schema-change to store its progress in […]

Fri Jun 14, 2024 16:56
Sakila, Where Are You Going?

At Percona, we monitor our users’ needs and try to accommodate them. One aspect we monitor is the MySQL version distribution/utilization. Observing that, we identified a very interesting trend: the lack of migration from 5.7 to 8.x, or better yet, the need of many to remain on 5.7.  That observation has triggered several actions from […]

Thu Jun 13, 2024 16:28
What’s New in Percona Toolkit 3.6.0

Percona Toolkit 3.6.0 has been released on June 12, 2024. The most important updates in this version are: The possibility to resume pt-online-schema-change if it is interrupted. eu-stack support in pt-pmp that significantly improves this tool’s performance and decreases the load it causes on production servers. New tool pt-eustack-resolver Packages...

Wed Jun 12, 2024 21:00
GCache and Record-Set Cache Encryption in Percona XtraDB Cluster – Part Two

Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. In the first part of this blog post, we learned how to enable GCache and Record-Set cache encryption in Percona XtraDB Cluster. This part will explore the details of the implementation to understand what happens behind the scenes. How does it work […]

Wed Jun 12, 2024 18:01
Important Update: Streamlined Repository Management for Improved Efficiency

We’re announcing an upcoming update to our repository management system to ensure you receive the most timely updates and benefit from improved efficiency. Effective July 1st, 2024, we’ll be streamlining our repository structure on We’ll no longer be updating the original/percona and tools repositories, which include packages for EOL...

Tue Jun 11, 2024 16:07
A Practical Guide to PostgreSQL Indexes

PostgreSQL is known for its reliability and feature-rich environment, but as with any database, when datasets grow larger and query complexity increases, efficient data retrieval becomes crucial for maintaining optimal database performance. This is where indexes play a vital role, enhancing performance by allowing for faster data retrieval. Indexes...

Mon Jun 10, 2024 21:43


14 日間のトライアルをはじめましょう。クレジットカードは不要です。