Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 15, 2012
ext4 vs xfs on SSD
As ext4 is a standard de facto filesystem for many modern Linux system, I am getting a lot of question [...]
March 12, 2012
Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB [...]
February 25, 2012
Introducing new type of benchmark
Traditionally the most benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, [...]
February 23, 2012
Percona Server vs MySQL on Intel 320 SSD
If you are terrified by the stability of the results in MySQL in my previous post, I am going to [...]
February 23, 2012
Some fun with R visualization
My previous post I finished with the graph with unstable results. There I won’t analyze causes, but rather I want [...]
February 22, 2012
Benchmarks of Intel 320 SSD 600GB
I have a chance to test a system with Intel 320 SSD drives (NewRelic provided me with an access to [...]
February 18, 2012
MariaDB 5.3.4 benchmarks
MariaDB 5.3 has reached the release candidate milestone, and the 5.3 version promises a lot of new features and optimization [...]
January 17, 2012
Benchmarks of new innodb_flush_neighbor_pages
In our recent release of Percona Server 5.5.19 we introduced new value for innodb_flush_neighbor_pages=cont. This way we are trying to [...]
January 13, 2012
Percona testing: Quick test clusters with kewpie!
The announcement of Percona XtraDB Cluster seems to have generated a fair bit of interest : ) Although the documentation [...]
December 2, 2011
kernel_mutex problem cont. Or triple your throughput
This is to follow up my previous post with kernel_mutex problem. First, I may have an explanation why the performance [...]
December 2, 2011
kernel_mutex problem. Or double throughput with single variable
Problem with kernel_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there are [...]
November 16, 2011
Fishing with dynamite, brought to you by the randgen and dbqp
I tend to speak highly of the random query generator as a testing tool and thought I would share a [...]
November 16, 2011
dbqp and Xtrabackup testing
So I’m back from the Percona dev team’s recent meeting. While there, we spent a fair bit of time discussing [...]
November 13, 2011
Side load may massively impact your MySQL Performance
When we’re looking at benchmarks we typically run some stable workload and we run it in isolation – nothing else [...]
November 10, 2011
Review of Virident FlashMAX MLC cards
I have been following Virident for a long time (e.g. https://www.percona.com/blog/2010/06/15/virident-tachion-new-player-on-flash-pci-e-cards-market/). They have great PCIe Flash cards based on SLC [...]
November 6, 2011
Improved InnoDB fast index creation
One of the serious limitations in the fast index creation feature introduced in the InnoDB plugin is that it only [...]
October 13, 2011
Benchmarking Galera replication overhead
When I mention Galera replication as in my previous post on this topic, the most popular question is how does [...]
October 10, 2011
MySQL versions shootout
As part of work on “High Performance MySQL, 3rd edition”, Baron asked me to compare different MySQL version in some [...]
October 7, 2011
Multiple MySQL instances on Fusion-io ioDrive
It is known that MySQL due internal limitations is not able to utilize all CPU and IO resources available on [...]
October 3, 2011
Percona Welcomes Patrick Crews
I am very happy to welcome Patrick Crews to the Percona development team. Patrick joins Percona at a very exciting [...]