Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
September 28, 2009
How the number of columns affects performance
It is pretty understood the tables which have long rows tend to be slower than tables with short rows. I [...]
September 15, 2009
Which adaptive should we use?
As you may know, InnoDB has 2 limits for unflushed modified blocks in the buffer pool. The one is from [...]
August 16, 2009
A micro-benchmark of stored routines in MySQL
Ever wondered how fast stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of [...]
August 8, 2009
NILFS – may be not yet
Inspired by NILFS: A File System to Make SSDs Scream and some customers asked if they should try NILFS on [...]
August 7, 2009
Dissection of EC2 / EBS volume
So during preparation of XtraDB template for EC2 I wanted to understand what IO characteristics we can expect from EBS [...]
August 6, 2009
EC2/EBS single and RAID volumes IO benchmark
During preparation of Percona-XtraDB template to run in RightScale environment, I noticed that IO performance on EBS volume in EC2 [...]
July 14, 2009
Performance improvements in Percona 5.0.83 and XtraDB
There was small delay in our releases, part of this time we worked on features I mentioned before: – Moving [...]
June 15, 2009
Testing FusionIO: strict_sync is too strict…
With new updates of FusionIO drivers I was able to test it on our Dell R900 with Ubuntu 8.10 without [...]
June 9, 2009
mysql-proxy, urgh performance and scalability ?
For one our project I needed proxy solution, and mysql-proxy is one of well-known, so it was logical first choice. [...]
May 12, 2009
read_ahead (disabled) as steroid
Last week we were busy to align XtraDB performance with 5.4, now we have some results. Currently it is available [...]
May 1, 2009
RAID vs SSD vs FusionIO
In benchmarks passion (see my two previous posts) I managed to setup all three devices (RAID was on board; Intel [...]
May 1, 2009
5.4 in-memory tpcc-like load
As continue to my benchmarks https://www.percona.com/blog/2009/04/30/looking-on-54-io-bound-benchmarks/ on 5.4 I tried in-memory load (basically changed buffer pool from 3GB to 15GB, [...]
April 30, 2009
Looking on 5.4 – IO bound benchmarks
With a lot of talks around 5.4 I decided to check how it works in our benchmarks. For first shoot [...]
March 20, 2009
Another ingenious piece of Sun Marketing
So a while ago I wrote about fun post about MySQL Scalability to 256 way…. Besides discussion on the thread [...]
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 [...]