EmergencyEMERGENCY? Get 24/7 Help Now!

How to improve InnoDB performance by 55% for write-bound loads

 | May 23, 2014 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Live

Update: do not do this, this has been proven to corrupt data!   During April’s Percona Live MySQL Conference and Expo 2014, I attended a talk on MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. He mentioned at some point that the InnoDB double write buffer was a real […]

Read More

Percona Live London 2013: an insider’s view of the schedule

 | September 18, 2013 |  Posted In: Benchmarks, Events and Announcements, Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Live, Percona XtraBackup

With the close of call for papers earlier this month, the Percona Live London conference committee was in full swing this past week reviewing all of the many submissions for November’s Percona Live London MySQL Conference. The submissions are far ranging and cover some really interesting topics, making the lineup for Percona Live London really strong! […]

Read More

Let’s talk about Percona Server 5.6: Enterprise Grade MySQL (webinar)

 | July 30, 2013 |  Posted In: Events and Announcements, Hardware and Storage, Insight for DBAs, MySQL, Percona Server, Percona XtraBackup, Technical Webinars

The new Percona Server 5.6 is the most manageable, highest performance, and most scalable version of MySQL available. Percona Server 5.6 is the best open source MySQL choice for enterprise-grade applications because it combines new features with the best features of Percona Server 5.5 and MySQL 5.6 to provide unparalleled performance. Join me tomorrow as […]

Read More

ZFS on Linux and MySQL

 | May 24, 2013 |  Posted In: Hardware and Storage, Insight for DBAs, MySQL

I am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low virtualization overhead. I learned quite a lot about these […]

Read More

Virident vCache vs. FlashCache: Part 2

 | May 17, 2013 |  Posted In: Benchmarks, Hardware and Storage, MySQL

This is the second part in a two-part series comparing Virident’s vCache to FlashCache. The first part was focused on usability and feature comparison; in this post, we’ll look at some sysbench test results. Disclosure: The research and testing conducted for this post were sponsored by Virident. First, some background information. All tests were conducted […]

Read More

Testing the Micron P320h

 | April 16, 2013 |  Posted In: Benchmarks, Hardware and Storage, MySQL

The Micron P320h SSD is an SLC-based PCIe solid-state storage device which claims to provide the highest read throughput of any server-grade SSD, and at Micron’s request, I recently took some time to put the card through its paces, and the numbers are indeed quite impressive. For reference, the benchmarks for this device were performed […]

Read More