by Fernando Ipar | Feb 1, 2016 | Benchmarks
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,...
by Peter Zaitsev | Jan 26, 2016 | MySQL
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...
by Dave Avery | Jan 22, 2016 | MySQL, Percona Events
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...
by Kortney Runyan | Jan 22, 2016 | MariaDB, MongoDB, MySQL, Percona Events
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...
by Miguel Angel Nieto | Jan 19, 2016 | 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 is expected. Either way, corrupted InnoDB data can and does occur. What do you do then?...
by Vadim Tkachenko | Sep 17, 2015 | MariaDB, MySQL, Percona Software
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...
by Tom Diederich | Aug 26, 2015 | MongoDB, Percona Live
Say hello to David Murphy, lead DBA and MongoDB Master at ObjectRocket (a Rackspace company). David works on sharding, tool building, very large-scale issues and high-performance MongoDB architecture. Prior to ObjectRocket he was a MySQL/NoSQL architect at Electronic...
by Alexander Rubin | Aug 24, 2015 | MySQL, Webinars
Thank you for attending my July 22 webinar titled “Advanced Query Tuning in MySQL 5.6 and 5.7” (my slides and a replay available here). As promised here is the list of questions and my answers (thank you for your great questions). Q: Here is the explain...
by Vadim Tkachenko | Jul 24, 2015 | Benchmarks, MySQL, Percona Software
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...
by Miguel Angel Nieto | Jun 18, 2015 | Insight for DBAs, MySQL
When a new version of MySQL is about to be released we read a lot of blog posts about the performance and scalability improvements. That’s good but sometimes we miss some small features that can help us a lot in our day-to-day tasks. One good example is the blog...
by Yves Trudeau | Jun 17, 2015 | Benchmarks, Hardware and Storage, 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...
by Yves Trudeau | Jun 8, 2015 | Insight for DBAs, MySQL, Percona Software
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...
by Stephane Combaudon | Jun 3, 2015 | Insight for DBAs, MySQL, Percona Software
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...
by Muhammad Irfan | May 27, 2015 | MySQL, Percona Services
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...
by Stephane Combaudon | May 8, 2015 | Insight for DBAs, MySQL
We discussed in an earlier post how to design indexes for many types of queries using a single table. Here is a real-world example of the challenges you will face when trying to optimize queries: two similar queries, but one is performing a full table scan while the...
by Vadim Tkachenko | May 1, 2015 | Benchmarks, MySQL
An idea for a benchmark based on the “arrival request” rate that I wrote about in a post headlined “Introducing new type of benchmark” back in 2012 was implemented in Sysbench. However, Sysbench provides only a simple workload, so to be able to...
by Michael Coburn | Apr 3, 2015 | MySQL
On a recent engagement I worked with a customer who makes extensive use of UUID() values for their Primary Key and stores it as char(36), and their row count on this example table has grown to over 1 billion rows. The table is INSERT-only (no UPDATEs or DELETEs), and...
by Hrvoje Matijakovic | Mar 31, 2015 | MySQL, Percona Events, Percona Software
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...
by Muhammad Irfan | Mar 16, 2015 | MySQL, Percona Services
One of our Percona Support customers recently reported that Percona XtraBackup failed with a page corruption error on an InnoDB table. The customer thought it was a problem or bug in the Percona XtraBackup tool. After investigation we found that an InnoDB page was...
by Stephane Combaudon | Mar 13, 2015 | Insight for DBAs, MySQL, Percona Software, Webinars
My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available an online migration to GTIDs and that’s why here.
