Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 15, 2015
MongoDB 3.2 WiredTiger in iiBench
MongoDB 3.2 was recently released with WiredTiger as the default storage engine. In just over five years, MongoDB has evolved [...]
October 26, 2015
State of Percona Server 5.6, MySQL 5.6 and MySQL 5.7 RC
This week Oracle will release MySQL 5.7 GA, so it’s a perfect time to do a quick review of the [...]
September 9, 2015
Testing MySQL partitioning with pt-online-schema-change
There are cases where we need to implement MySQL partitioning, or at least test if it is an option to solve an [...]
August 7, 2015
The MySQL query cache: Worst enemy or best friend?
During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce [...]
July 29, 2015
Multi-source replication in MySQL 5.7 vs Tungsten Replicator
MySQL 5.7 comes with a new set of features and multi-source replication is one of them. In few words this [...]
July 24, 2015
InnoDB vs TokuDB in LinkBench benchmark
Previously I tested Tokutek’s Fractal Trees (TokuMX & TokuMXse) as MongoDB storage engines – today let’s look into the MySQL [...]
July 14, 2015
MongoDB benchmark: sysbench-mongodb IO-bound workload comparison
In this post I’ll share the results of a sysbench-mongodb benchmark I performed on my server. I compared MMAP, WiredTiger, [...]
June 17, 2015
Update on the InnoDB double-write buffer and EXT4 transactions
IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data. In a post, [...]
May 22, 2015
MongoDB / TokuMX plugin for LinkBench (Part 1)
“There’s no benchmark for how life’s “supposed” to happen. There is no ideal world for you to wait around for. [...]
May 1, 2015
LinkBenchX: benchmark based on arrival request rate
An idea for a benchmark based on the “arrival request” rate that I wrote about in a post headlined “Introducing [...]
April 10, 2015
Measuring the impact of tcpdump on Very Busy Hosts
A few years back Deva wrote about how to use tcpdump on very busy hosts. That post sparked my interest [...]
February 24, 2015
Is MySQL’s innodb_file_per_table slowing you down?
MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows [...]
January 26, 2015
MySQL benchmarks on eXFlash DIMMs
In this blog post, we will discuss MySQL performance on eXFlash DIMMs. Earlier we measured the IO performance of these [...]
January 21, 2015
Importing big tables with large indexes with Myloader MySQL tool
Mydumper is known as the faster (much faster) mysqldump alternative. So, if you take a logical backup you will choose [...]
January 19, 2015
Looking deeper into InnoDB’s problem with many row versions
A few days ago I wrote about MySQL performance implications of InnoDB isolation modes and I touched briefly upon the bizarre [...]
January 15, 2015
Hyper-threading -How does it double CPU throughput?
The other day a customer asked me to do capacity planning for their web server farm. I was looking at [...]
January 14, 2015
MySQL performance implications of InnoDB isolation modes
Over the past few months I’ve written a couple of posts about dangerous debt of InnoDB Transactional History and about [...]
December 31, 2014
How small changes impact complex systems – MySQL example
If you’ve been studying complex systems you know what minor changes might cause consequences of much greater proportions, sometimes causing [...]
December 5, 2014
Streamlined Percona XtraDB Cluster (or anything) testing with Consul and Vagrant
Introducing Consul I’m always interested in what Mitchell Hashimoto and Hashicorp are up to, I typically find their projects valuable. [...]
November 26, 2014
MySQL benchmarking: Know your baseline variance!
Often enough I find MySQL benchmark results where the difference between results is 1% or even less and some conclusions [...]