On Percona Live New York I’ll be giving two talks “Percona XtraDB Cluster: HA solution for MySQL”. I will give introduction in MySQL clustering and show how Percona XtraDB Cluster solves HA and scalability problems. MySQL and SSD: usage and tuning. If you follow this blog, you know that I do quite a bit experiments [...]
Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 21 Comments
I was lucky enough to get my hands on new Fusion-io ioDrive2 Duo card. So I decided to run the same series of tests I did for other Flash devices. This is ioDrive2 Duo 2.4TB card and it is visible to OS as two devices (1.2TB each), which can be connected together via software RAID. [...]
Testing Virident FlashMAX 1400
May 4, 2012 By 4 Comments
I still continue to run benchmarks of different SSD cards. This time I show numbers for Virident FlashMAX 1400. This is a MLC PCIe SSD device. There are couple notes on these results. First, this time I use a different server. For this benchmark it is Cisco UCS C250, while for previous results I used [...]
Testing Samsung SSD SATA 256GB 830 – not all SSD created equal
April 25, 2012 By 12 Comments
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, [...]
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).
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 [...]
Announcing Percona Toolkit Release 2.0.3
February 6, 2012 By 2 Comments
We’ve released Percona Toolkit 2.0.3, with a couple of major improvements and many minor ones. You can download it, read the documentation, and get support for it. What’s new? You can read the changelog for the details, but here are the highlights: Brand new pt-diskstats, thanks to Brian Fraser. This tool is completely rewritten, and [...]
Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
Preparing Choosing Storage Systems for MySQL talk for Percona Live in Washington,DC I ran into great paper called Sane SAN 2010 by James Morle from Scale Abilities – and Oracle consulting company. It is worth to read for variety of reason yet for this post I wanted to mention what James calls “Busy” Oracle database [...]
Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
A lot have been written about Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2). It is good to see though there are some controllers coming out which solve this problem, namely Adaptec 5Z series controllers (Z stands for Zero Maintenance). This is not quite new technology they [...]
Virident FlashMAX MLC in tpcc-mysql workload
November 29, 2011 By 8 Comments
As I mentioned in previous post on Virident FlashMAX MLC, beside sysbench benchmark, I also run tpcc-mysql (to compare performance Virident FlashMAX vs Fusion-io ioDrive Duo) The report with results is there: http://www.percona.com/files/white-papers/virident-mlc-tpcc.pdf
