On Fri, 26 Apr 2013, James Harper <james.harper@bendigoit.com.au> wrote:
Which does indicate that the io is struggling when the mysql query is running...
I'm converting to xfs from ext3 to see if there is something gone bad with the filesystem.
XFS performs very well. But unless you happen to be triggering some obscure corner case (which seems unlikely with a program as common as mysqld) I don't think that XFS will give you a huge benefit over Ext3. Eventually they all come down to seek times on disk. If you convert filesystem then before you do it please restart mysqld, umount and mount the filesystem, and do any other changes that might happen as part of the XFS conversion while still using Ext3. Then if you get a performance benefit you'll know that it's related to XFS not something else. -- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/