Tag - Percona Server for MySQL

Percona Server for MySQL® is a free, fully compatible, enhanced, open source drop-in replacement for MySQL that provides superior performance, scalability and instrumentation. With over 3,000,000 downloads, Percona Server’s self-tuning algorithms and support for extremely high-performance hardware delivers excellent performance and reliability.

22 Dec 2020

Redesign of –lock-ddl-per-table in Percona XtraBackup

By Marcelo Altmann Insight for DBAs, MySQL, Percona Software , , , 1 Comment
Redesign of -lock-ddl-per-table in Percona XtraBackup

MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care for backup tools. To block DDL statements on an instance, Percona Server for […]

Read more
16 Oct 2020

Danger of Changing Default of log_error_verbosity on MySQL/Percona Server for MySQL 5.7

By Carlos Tutte Insight for DBAs, MySQL, Percona Software , , , , 0 Comments
Changing Default of log_error_verbosity mysql

Changing the default value (3) of log_error_verbosity in MySQL/Percona Server for MySQL 5.7 can have a hidden unintended effect! What does log_error_verbosity do exactly? As per the documentation:
“The log_error_verbosity system variable specifies the verbosity for handling events intended for the error log.“
Basically a value of 1 logs only [Errors]; 2 is 1)+[Warnings]; and 3 […]

Read more
14 Sep 2020

How to Upgrade to MySQL 8.0 – Free Course at Percona University Online

By Daniil Bazhenov MySQL, Percona Services, Percona Software , , , 2 Comments
upgrade to MySQL 8

MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been successfully upgraded to the new version. But many […]

Read more
18 Aug 2020

Aligning Percona XtraBackup Versions with Percona Server for MySQL

By Kathy Williamson MySQL, Percona Software , , , , 3 Comments
Aligning Percona XtraBackup Versions with Percona Server for MySQL

We are excited to let you know about two upcoming changes to Percona XtraBackup which will align Percona XtraBackup Versions with Percona Server for MySQL.  These changes are to bring Percona XtraBackup release naming line with Percona Server and MySQL and ensure Percona XtraBackup executes complete backups.
The first is a change to the naming […]

Read more
12 Aug 2020

Deadlock Troubleshooting in Percona Server for MySQL 5.7

By Carlos Tutte Insight for DBAs, Insight for Developers, MySQL, Percona Software , , , , , 0 Comments
Deadlock Troubleshooting MySQL

Disclaimer: the following script only works for Percona Server for MySQL 5.7, and relies on enabling performance schema (PS) instrumentation which can add overhead on high concurrent systems, and is not intended for continuous production usage as it’s a POC (proof of concept).
Introduction
In Percona Support, we frequently receive tickets related to deadlocks and even […]

Read more

Upcoming Webinars

All Webinars »


MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners. Proudly running Percona Server for MySQL

Terms of Use | Privacy | Copyright | Legal

Copyright © 2006-2021 Percona LLC.