Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 26, 2011
Modeling InnoDB Scalability on Multi-Core Servers
Mat Keep’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB’s [...]
December 21, 2010
MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
This is to follow up on my previous post and show the results for MySQL 5.5.8 and Percona Server on [...]
December 13, 2010
Write performance on Virident tachIOn card
This is crosspost from https://www.percona.com/blog/. Disclaimer: The benchmarks were done as part of our consulting practice, but this post is [...]
November 29, 2010
Data Corruption, DRBD and story of bug
Working with customer, I faced pretty nasty bug, which is actually not rare situation , but in this particular there [...]
November 16, 2010
The perils of uniform hardware and RAID auto-learn cycles
Last night a customer had an emergency in selected machines on a large cluster of quite uniform database servers. Some [...]
July 14, 2010
On Benchmarks on SSD
(cross post from SSD Performance Blog ) To get meaningful performance results on SSD storage is not easy task, let’s [...]
July 14, 2010
SLC vs MLC
(cross posting from SSDPeformanceBlog.com ) All modern solid state drives use NAND memory based on SLC (single level cell) or [...]
May 18, 2010
FlashCache: more benchmarks
Previously I covered simple case with FlashCache, when data fits into cache partitions, now I am trying to test when [...]
May 10, 2010
FlashCache: first experiments
I wrote about FlashCache there, and since that I run couple benchmarks, to see what performance benefits we can expect. [...]
April 27, 2010
Level 2 Flash cache is there
As I mentioned in my talk An Overview of Flash Storage for Databases I see in the near and middle [...]
April 8, 2010
Should I buy a Fast SSD or more memory?
While a scale-out solution has traditionally been popular for MySQL, it’s interesting to see what room we now have to [...]
April 2, 2010
fadvise – may be not what you expect
I often hear suggestion to use [crayon-68c6de4948962661458989/] system call to avoid caching in OS cache. We recently made patch for [...]
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 [...]
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 [...]
March 9, 2009
When would you use SAN with MySQL ?
One question which comes up very often is when one should use SAN with MySQL, which is especially popular among [...]
March 2, 2009
SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
We finally managed to get Intel X25-E SSD drive into our lab. I attached it to our Dell PowerEdge R900. [...]
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 21, 2009
Beware: ext3 and sync-binlog do not play well together
One of our customers reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the [...]
December 5, 2008
When to use Hardware upgrade instead of Software Optimization
One typical question which frequently pops up is whenever it is better to use hardware upgrade or optimize software more. [...]