Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
March 31, 2008
MySQL Performance on Memory Appliance
Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be [...]
March 25, 2008
MySQL 6.0 vs 5.1 in TPC-H queries
Last week I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, [...]
March 21, 2008
MySQL File System Fragmentation Benchmarks
Few days ago I wrote about testing writing to many files and seeing how this affects sequential read performance. I [...]
March 5, 2008
Evaluating IO subsystem performance for MySQL Needs
I’m often asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve [...]
February 27, 2008
A piece of Sun/MySQL Marketing
I got first Sun/MySQL Newsletter Today which among other things lead to the site publishing among other things links to [...]
February 1, 2008
Performance gotcha of MySQL memory tables
One performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage [...]