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

Webinar: Best Practices for MySQL Scalability on May 1

 | April 30, 2013 |  Posted In: Events and Announcements, MySQL, Technical Webinars

If you have not already done so, I encourage you to register for my “Best Practices for MySQL Scalability” Webinar which will take place on May 1st at 10 a.m. PST. This will be an overview presentation, led by me and providing a high-level look at the components of MySQL scalability: application architecture, MySQL version […]

Read More

SystemTap – DTrace for Linux ?

 | September 14, 2009 |  Posted In: Insight for DBAs

Since DTrace was released for Solaris I am missing it on Linux systems… It can’t be included in Linux by the same reason why ZFS can’t be – it’s licensing issue. Both ZFS and DTrace are under CDDL, which is incompatible with GPL. So you can see DTrace and ZFS on Solaris, FreeBSD, MacOS, but […]

Read More

Linux schedulers in tpcc like benchmark

 | January 30, 2009 |  Posted In: Benchmarks

I mentioned earlier that IO scheduler CFQ coming by default in RedHat / CentOS 5.x may be not so good for MySQL. And yesterday one customer reported that just changing cfq to noop solved their InnoDB IO problems. I ran tpcc scripts against XtraDB on our Dell PowerEdge R900 server (16 cores, 8 disks in […]

Read More

Beware: ext3 and sync-binlog do not play well together

 | January 21, 2009 |  Posted In: Hardware and Storage

One of our customers reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system with RAID and BBU were expected to have much better performance. The problem could be repeated with SysBench as follows:

Read More

MySQL, AIX5L and malloc()

 | November 3, 2008 |  Posted In: Insight for DBAs

Some time ago I get brand new IBM POWER6 server as the replacement for “old” P5 used to host Oracle database. Because we planed to use advanced virtualization with VIOS + LPAR/DLPAR I conceived the idea to use one spare partition for MySQL tests. Because I had no past experience with it and there is […]

Read More

Linux IO Schedulers and MySQL

 | January 30, 2007 |  Posted In: Hardware and Storage

Found a great article about Linux IO Schedulers today which is quite interesting. It goes in details about schedulers and explains in which of workloads which of schedulers is best. The interesting thing this article points out is – there are multiple versions of each of the schedulers, while name remains the same. This means […]

Read More