EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server 5.7.14-7 is now available

 | August 23, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

percona server 5.6.30-76.3

Percona announces the GA release of Percona Server 5.7.14-7 on August 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.14, including all the bug fixes in it, Percona Server 5.7.14-7 is the current GA release in the Percona Server 5.7 series. Percona’s provides completely open-source and free […]

Read More

Percona Server 5.5.51-38.1 is now available

 | August 19, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software

percona server 5.6.30-76.3

Percona announces the release of Percona Server 5.5.51-38.1 on August 19, 2016. Based on MySQL 5.5.51, including all the bug fixes in it, Percona Server 5.5.51-38.1 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can find release details of the release in the 5.5.51-38.1 milestone on Launchpad. […]

Read More

Small innodb_page_size as a performance boost for SSD

 | August 10, 2016 |  Posted In: Benchmarks, InnoDB, MySQL

performance boost for SSD

In this blog post, we’ll discuss how a small innodb_page_size can create a performance boost for SSD. In my previous post Testing Samsung storage in tpcc-mysql benchmark of Percona Server I compared different Samsung devices. Most solid state drives (SSDs) use 4KiB as an internal page size, and the InnoDB default page size is 16KiB. I wondered […]

Read More

Percona Server 5.6.31-77.0 is now available

 | July 7, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

percona server 5.6.30-76.3

Percona announces the release of Percona Server 5.6.31-77.0 on July 7th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.31, including all the bug fixes in it, Percona Server 5.6.31-77.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – this […]

Read More

InnoDB locks and transaction isolation level

 | June 17, 2016 |  Posted In: InnoDB, MySQL

Overlooked MySQL performance optimization

What is the difference between InnoDB locks and transaction isolation level? We’ll discuss it in this post. Recently I received a question from a user about one of my earlier blog posts. Since it wasn’t sent as a comment, I will answer it here. The question: > I am reading your article: > https://www.percona.com/resources/technical-presentations/troubleshooting-locking-issues-percona-mysql-webinar > Full table […]

Read More

What is a big innodb_log_file_size?

 | May 31, 2016 |  Posted In: InnoDB, MySQL

big innodb_log_file_size

In this post, we’ll discuss what constitutes a big innodb_log_file_size, and how it can affect performance. In the comments for our post on Percona Server 5.7 performance improvements, someone asked why we use innodb_log_file_size=10G with an indication that it might be too big? In my previous post (https://www.percona.com/blog/2016/05/17/mysql-5-7-read-write-benchmarks/), the example used innodb_log_file_size=15G. Is that too big? Let’s […]

Read More

TokuDB impacts InnoDB Performance?

 | March 22, 2016 |  Posted In: MySQL

TokuDB impacts InnoDB performance

This blog discusses how TokuDB impacts InnoDB performance when the two run in the same environment. You would think MySQL storage engines are fairly independent of each other, even in the same environment. Enabling one, or changing its configuration, logically should have no impact on the performance of other engines (such as InnoDB) when they […]

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

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.