EmergencyEMERGENCY? Get 24/7 Help Now!

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

Finding MySQL Table Size on Disk

 | January 26, 2016 |  Posted In: MySQL

MySQL table size

So you want to know how much space a given MySQL table takes on disk. Looks trivial, right? Shouldn’t this information be readily available in the INFORMATION_SCHEMA.TABLES? Not so fast! This simple question actually is quite complicated in MySQL. MySQL supports many storage engines (some of which don’t store data on disk at all) and […]

Read More

Peter Zaitsev webinar January 27th: Compression In Open Source Databases

 | January 22, 2016 |  Posted In: Events and Announcements, MySQL

Database Compression

Percona invites you to attend a webinar Wednesday, January 27th, with CEO Peter Zaitsev: Compression In Open Source Databases. Register now! Data growth has been tremendous in the last decade and shows no signs of stopping. To deal with this trend database technologies have implemented a number of approaches, and data compression is by far the […]

Read More

Percona Live Data Performance Conference 2016: news you need to know!

 | January 22, 2016 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL

Percona Live

The Percona Live Data Performance Conference 2016 is rapidly approaching, and we’re looking forward to providing an outstanding experience April 18-21 for all whom attend. Percona Live is the premier event for the rich and diverse open source community and businesses that thrive in the MySQL and NoSQL marketplaces. Attendees include DBAs, sysadmins, developers, architects, […]

Read More

Dealing with corrupted InnoDB data

 | January 19, 2016 |  Posted In: MySQL


Data corruption! It can happen. Maybe because of a bug or storage problem that you didn’t expect, or MySQL crashes when a page checksum’s result is different from what it expected. Either way, corrupted data can and does occur. What do you do then? Let’s look at the following example and see what can be […]

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

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.