EmergencyEMERGENCY? Get 24/7 Help Now!

InnoDB vs TokuDB in LinkBench benchmark

 | July 24, 2015 |  Posted In: Benchmarks, MySQL, Percona Server, TokuDB

Previously I tested Tokutek’s Fractal Trees (TokuMX & TokuMXse) as MongoDB storage engines – today let’s look into the MySQL area. I am going to use modified LinkBench in a heavy IO-load. I compared InnoDB without compression, InnoDB with 8k compression, TokuDB with quicklz compression. Uncompressed datasize is 115GiB, and cachesize is 12GiB for InnoDB […]

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

MaxScale: A new tool to solve your MySQL scalability problems

 | June 8, 2015 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, XtraDB Cluster

Ever since MySQL replication has existed, people have dreamed of a good solution to automatically split read from write operations, sending the writes to the MySQL master and load balancing the reads over a set of MySQL slaves. While if at first it seems easy to solve, the reality is far more complex. First, the […]

Read More

Optimizing Percona XtraDB Cluster for write hotspots

 | June 3, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona XtraDB Cluster

Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this is called a write hotspot. Because you cannot update the same row simultaneously from multiple threads, this can lead to performance degradation. When using Percona XtraDB Cluster (PXC), some users try to solve this specific […]

Read More

MySQL 5.7 key features

 | May 27, 2015 |  Posted In: InnoDB, MySQL, Percona MySQL Support

The other day I was discussing new features of MySQL 5.7 with a Percona Support customer. After that conversation, I thought it would be a good idea to compile list of important features of MySQL 5.7. The latest MySQL 5.7.6 release candidate (RC) is out and is packed with nice features. Here’s a list of […]

Read More

Percona XtraBackup 2.2.10 for MySQL hot backups is now available (free!)

 | March 31, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.2.10 on March 31, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

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.