I personally like PCIe based Flash, but from a pricing point our customers are looking for cheaper alternatives. SATA SSD is an options. There is many products based on MLC technology, and Intel 320 I would say is the most popular. I do not particularly like its write performance – I wrote about it before, [...]
ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
As ext4 is a standard de facto filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or something else (i.e. xfs) should be used. Traditionally our recommendation is xfs, and it comes to known problem in ext3, where IO gets serialized per i_node in O_DIRECT [...]
Webinar “How to Turbocharge Your MySQL Performance Using Flash Storage”
March 13, 2012 By 5 Comments
Next Wednesday, March-21, 11:00am Pacific Time, Baron and me will be co-presenting with Virident webinar: “How to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe).
Introducing new type of benchmark
February 25, 2012 By 16 Comments
Traditionally the most benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, sysbench and tpcc-mysql, the final result is also represents the throughput (transactions per second in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response time is way more important [...]
Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
If you are terrified by the stability of the results in MySQL in my previous post, I am going to show what we can get with Percona Server. This is also to address the results presented there Benchmarking MariaDB-5.3.4
Some fun with R visualization
February 23, 2012 By 5 Comments
My previous post I finished with the graph with unstable results. There I won’t analyze causes, but rather I want to show some different ways to present results.
Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
I have a chance to test a system with Intel 320 SSD drives (NewRelic provided me with an access to the server), and compare performance with SAS hard drives.
The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship. Some basic facts Most of us know that writing into Innodb updates buffer [...]
My talks on PL MySQL Conference (+free book inside)
February 14, 2012 By Leave a Comment
On coming PL MySQL conference 2012 I will give one tutorial: Percona XtraBackup: install, usage, tricks. This tutorial I will do in joint with Alexey Kopytov, the lead developer of Percona XtraBackup. Our intent is to provide the comprehensive overview of the XtraBackup architecture and features, and we will touch future roadmap. This is all [...]
Benchmarks of new innodb_flush_neighbor_pages
January 17, 2012 By 8 Comments
In our recent release of Percona Server 5.5.19 we introduced new value for innodb_flush_neighbor_pages=cont. This way we are trying to deal with the problem of InnoDB flushing.
