Saturday, October 11, 2008

More background IO threads for InnoDB in MySQL 5.1

I have ported code from the Google patch to support more background IO threads and make the InnoDB background IO limit configurable. More details on this are here. The code in in launchpad. More details on launchpad are here.

These changes can improve performance if your servers are IO bound and have many disks. They are more likely to be an issue if you use O_DIRECT for InnoDB or a remote file system such as NFS.

The 5.1 branch in launchpad has these patches:
show_patches.patch    SHOW PATCHES    1.0    Jeremy Cole    N/A    
innodb_io_threads.patch    INNODB IO THREADS    1.0    mcallaghan@google.com    GPL    More background IO threads
innodb_fast_mutex.patch    INNODB FAST MUTEX    1.0    benhandy@google.com    GPL    Faster Innodb mutex
innodb_io_capacity.patch    INNODB IO CAPACITY    1.0    mcallaghan@google.com    GPL    Background IO rate limits
show_global_mutex_stats.patch    SHOW GLOBAL MUTEX STATUS    1.0    mcallaghan@google.com    GPL    Displays mutex contention statistics

No comments:

Post a Comment

 
Creative Commons License
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.