EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server 5.7.11-4 is now available

 | March 15, 2016 |  Posted In: Events and Announcements, InnoDB, MySQL, MySQL 5.7, Percona Server, Percona Software, TokuDB

Percona Server

Percona is glad to announce the GA release of Percona Server 5.7.11-4 on March 15, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.7.11, including all the bug fixes in it, Percona Server 5.7.11-4 is the current GA release in the Percona Server 5.7 series. All of […]

Read More

Percona Server 5.5.48-37.8 is now available

 | March 4, 2016 |  Posted In: Events and Announcements, InnoDB, MySQL, Percona Server, Percona Software

Percona Server

Percona is glad to announce the release of Percona Server 5.5.48-37.8 on March 4, 2016. Based on MySQL 5.5.48, including all the bug fixes in it, Percona Server 5.5.48-37.8 is now the current stable release in the 5.5 series. Percona Server is open-source and free. Details of the release can be found in the 5.5.48-37.8 […]

Read More

InnoDB and TokuDB on AWS

 | February 1, 2016 |  Posted In: Benchmarks, InnoDB, TokuDB

In a recent post, Vadim compared the performance of Amazon Aurora and Percona Server on AWS. This time, I am comparing write throughput for InnoDB and TokuDB, using the same workload (sysbench oltp/update/update_non_index) and a similar set-up (r3.xlarge instance, with general purpose ssd, io2000 and io3000 volumes) to his experiments. All the runs used 16 threads for sysbench, and the following […]

Read More

Using dbsake to recover table structure from .frm files and process mysqldump output

 | December 16, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL

We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there was no backup available. There is already a great blog post by my colleague Miguel Ángel Nieto about how we can recover structures from .frm files using MySQL utilities. This works pretty well and we prefer […]

Read More

Percona Server 5.7.10-1 first RC available

 | December 14, 2015 |  Posted In: Events and Announcements, InnoDB, MySQL, MySQL 5.7, Percona Server, Percona Software, TokuDB

Percona is glad to announce the first release candidate of Percona Server 5.7.10-1 on December 14, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. This release contains all the bug fixes from latest Percona Server 5.6 release (currently Percona Server 5.6.27-76.0). New Features: Percona Server 5.7.10-1 is not available on […]

Read More

Clarification on “Call me Maybe: MariaDB Galera Cluster”

 | September 17, 2015 |  Posted In: InnoDB, MariaDB, MySQL, Percona XtraDB Cluster

Recently Aphyr (Kyle Kingsbury) published https://aphyr.com/posts/327-call-me-maybe-mariadb-galera-cluster The article is technically valid, I am not going to dispute a conclusion Aphyr made, but it is also quite technically involved, so users who just jump to conclusion may get the wrong impression and we’re left with more questions than ever. So, let me state what is the […]

Read More

Using Cgroups to Limit MySQL and MongoDB memory usage

 | July 1, 2015 |  Posted In: InnoDB, MongoDB, MySQL

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical servers with the usually high amount of memory (128GB or more), but I am […]

Read More

Update on the InnoDB double-write buffer and EXT4 transactions

 | June 17, 2015 |  Posted In: Benchmarks, Hardware and Storage, InnoDB, MySQL

IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data. In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance significantly, by 55%, without putting data at risk. Many people commented on the post mentioning […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.