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.

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
06 Aug 2020

How Can ScaleFlux Handle MySQL Workload?

By Tibor Korocz Benchmarks, MySQL, Percona Software , , , , , 10 Comments
ScaleFlux Handle MySQL

Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I will share the results of using it to run MySQL in comparison with an Intel device that had a similar capacity.
First of all, why do we need another storage device? Why is ScaleFlux any […]

Read more
27 Jul 2020

Generating Numeric Sequences in MySQL

By Yura Sorokin Insight for DBAs, Insight for Developers, MySQL, Percona Software , , , , 5 Comments
Generating Numeric Sequences in MySQL

What is the easiest way to generate a sequence of integers in MySQL? In other words, which “SELECT <something>” statement should I write to get 0, 1, 2, … N – 1?
This is the question I have been struggling with for years and it looks like I have finally got the answer (although I […]

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.