Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 19, 2013
Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
Facebook is a major user of MySQL and has pushed the performance limits of the technology. Their MySQL experts have [...]
March 12, 2013
Oracle Technical Experts at the Percona Live MySQL Conference and Expo
I’m pleased to announce that Oracle is sending some of their top technical people to speak at the Oracle, will [...]
March 8, 2013
MySQL performance: Impact of memory allocators (Part 2)
Last time I wrote about memory allocators and how they can affect MySQL performance in general. This time I would [...]
February 20, 2013
Mystery Performance Variance with MySQL Restarts
Based on a lot of surprising comments about my MySQL 5.5 vs 5.6 performance post I decided to perform deeper [...]
October 25, 2012
L2 cache for MySQL
The idea to use SSD/Flash as a cache is not new, and there are different solutions for this, both OpenSource [...]
October 23, 2012
Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!
Continuous integration of new features and bug fixes is great – but what if a small change in seemingly insignificant [...]
October 8, 2012
MySQL 5.6.7-RC in tpcc-mysql benchmark
MySQL 5.6.7 RC is there, so I decided to test how it performs in tpcc-mysql workload from both performance and [...]
September 20, 2012
A (prototype) lower impact slow query log
Yesterday, over at my personal blog, I blogged about the impact of the MySQL slow query log. Since we’re working [...]
September 11, 2012
Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
I continue my benchmarks of Intel SSD 910, previous time I compared it with Fusion-io ioDrive https://www.percona.com/blog/2012/09/07/intel-ssd-910-in-tpcc-mysql-benchmark/. Now I want [...]
September 10, 2012
Adaptive flushing in MySQL 5.6 – cont
This is to continue my previous experiments on adaptive flushing in MySQL 5.6.6. Now I am running Ubuntu 12.04, which [...]
September 7, 2012
Intel SSD 910 in tpcc-mysql benchmark
I continue my benchmarks of Intel SSD 910, the raw IO results are available in my previous experiment. Now I [...]
September 4, 2012
Testing Intel® SSD 910
Intel came on PCI-e SSD market with their Intel SSD 910 card. With a slogan “The ultimate data center SSD” [...]
September 4, 2012
Adaptive flushing in MySQL 5.6
As you may know, flushing in MySQL is an area of my interest, I wrote about it several times, i.e. [...]
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 [...]