Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 16, 2009
Compression for InnoDB backup
Playing with last version of xtrabackup and compress it I noticed that gzip is unacceptable slow for both compression and [...]
February 10, 2009
Impact of logging on MySQL’s performance
Introduction When people think about Percona’s microslow patch immediately a question arises how much logging impacts on performance. When we [...]
February 5, 2009
Disaster: LVM Performance in Snapshot Mode
In many cases I speculate how things should work based on what they do and in number of cases this [...]
January 30, 2009
Linux schedulers in tpcc like benchmark
I mentioned earlier that IO scheduler CFQ coming by default in RedHat / CentOS 5.x may be not so good [...]
January 23, 2009
Another scalability fix in XtraDB
Recent scalability fixes in InnoDB and also Google’s and your SMP fixes almost made InnoDB results acceptable in primary key [...]
January 18, 2009
Fix of InnoDB/XtraDB scalability of rollback segment
Recently I wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload [...]
December 29, 2008
XtraDB/InnoDB CPU bound benchmarks on 24cores server
One of our customers gave me a chance to run some benchmarks on 24-core (intel cpu based) server, and I [...]
December 18, 2008
XtraDB in CPU-bound benchmark
Peter said me that previous results https://www.percona.com/blog/2008/12/18/xtradb-benchmarks-15x-gain/ are too marketing, and we should show other results also. Here is the [...]
December 18, 2008
XtraDB benchmarks – 1.5X gain in IO-bound load
I guess it is first reaction on new storage engine – show me benefits. So there is benchmark I made [...]
December 13, 2008
MySQL QA Team Benchmarks for MySQL 5.1.30
As you might have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30. It is interesting [...]
December 3, 2008
MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
We’ve recently done benchmarks comparing different MySQL versions in terms of their CPU efficiently in TPC-C like Workload. We did [...]
November 13, 2008
Adaptive checkpointing
Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer [...]
November 12, 2008
New SpecJAppServer results at MySQL and Sun.
As you likely have seen Sun has posted the new SpecJAppServer Results More information from Tom Daly can be found [...]
October 31, 2008
How expensive is a WHERE clause in MySQL?
This is a fun question I’ve been wanting to test for some time. How much overhead does a trivial WHERE [...]
September 9, 2008
The performance effects of new patches
We are going to show the effects of the new patches applied to Percona HighPerf release. As you see from [...]
August 22, 2008
Multiple column index vs multiple indexes
(There is an updated version of the content in this post by Percona’s Stephane Combaudon available here.) After my previous [...]
July 3, 2008
How to load large files safely into InnoDB with LOAD DATA INFILE
Recently I had a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal [...]
April 23, 2008
Real-Life Use Case for “Barracuda” InnoDB File Format
In one of his recent posts Vadim already gave some information about possible benefits from using new InnoDB file format [...]
April 10, 2008
TPC-H Run on MySQL 5.1 and 6.0
We were doing MySQL Performance evaluation on TPC-H queries for the client and they kindly allowed us to publish results [...]
April 9, 2008
How fast can MySQL Process Data
Reading Barons post about Kickfire Appliance and of course talking to them directly I learned a lot in their product [...]