Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 5, 2012
Impact of memory allocators on MySQL performance
MySQL server intensively uses dynamic memory allocation so a good choice of memory allocator is quite important for the proper [...]
June 22, 2012
DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
Suppose you have turned on innodb_file_per_table (which means that each table has its own tablespace), and you have to drop [...]
June 19, 2012
Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them [...]
June 14, 2012
Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment. They wanted me [...]
June 2, 2012
How expensive is USER_STATISTICS?
One of our customers asked me whether it’s safe to enable the so-called USER_STATISTICS features of Percona Server in a [...]
May 31, 2012
A case for MariaDB’s Hash Joins
MariaDB 5.3/5.5 has introduced a new join type “Hash Joins” which is an implementation of a Classic Block-based Hash Join [...]
May 22, 2012
btrfs – probably not ready yet
Every time I have a conversation on SSD, someone mentions btrfs filesystem. And usually it is colored as a solution [...]
May 21, 2012
Intel 520 SSD in MySQL sysbench oltp benchmark
In my raw IO benchmark of Intel 520 SSD we saw that the drive does not provide uniform throughput and [...]
May 16, 2012
Benchmarking single-row insert performance on Amazon EC2
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that [...]
May 10, 2012
Testing Fusion-io ioDrive2 Duo
I was lucky enough to get my hands on new Fusion-io ioDrive2 Duo card. So I decided to run the [...]
May 9, 2012
New distribution of random generator for sysbench – Zipf
Sysbench has three distribution for random numbers: uniform, special and gaussian. I mostly use uniform and special, and I feel [...]
May 7, 2012
Testing Fusion-io ioDrive – now with driver 3.1
In my previous post with results for Fusion-io ioDrive we saw some instability in results, I was pointed that it [...]
May 4, 2012
Testing Virident FlashMAX 1400
I still continue to run benchmarks of different SSD cards. This time I show numbers for Virident FlashMAX 1400. This [...]
May 3, 2012
Testing Fusion-io ioDrive
Following my series of posts on testing different SSD, in my last post I mentioned that SATA SSD performance is [...]
May 1, 2012
Testing Intel SSD 520
Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB into my hands. In this post [...]
April 25, 2012
Testing STEC SSD MACH16 200GB SLC
Following my previous benchmark of Samsung 830, today I want to show results for STEC MACH16 SATA card, 200GB size, [...]
April 25, 2012
Testing Samsung SSD SATA 256GB 830 – not all SSD created equal
I personally like PCIe based Flash, but from a pricing point our customers are looking for cheaper alternatives. SATA SSD [...]
April 20, 2012
Benchmarks challenges of XtraDB Cluster
We are running internally a lot of benchmarks on our recently announced Percona XtraDB Cluster, and I am going to [...]
April 4, 2012
Join Optimizations in MySQL 5.6 and MariaDB 5.5
This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer [...]
March 21, 2012
Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
This is the second blog post in the series of blog posts leading up to the talk comparing the optimizer [...]