[Top] [All Lists]

Re: XFS IO multiplication problem on centos/rhel 6 using hp p420i raid c

To: stan@xxxxxxxxxxxxxxxxx
Subject: Re: XFS IO multiplication problem on centos/rhel 6 using hp p420i raid controllers
From: Dennis Kaarsemaker <dennis.kaarsemaker@xxxxxxxxxxx>
Date: Thu, 07 Mar 2013 14:33:08 +0100
Cc: Dave Chinner <david@xxxxxxxxxxxxx>, xfs@xxxxxxxxxxx
Delivered-to: xfs@xxxxxxxxxxx
Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=booking.com; s=bk; h=Mime-Version:Content-Transfer-Encoding:Content-Type:References:In-Reply-To:Date:Cc:To:From:Subject:Message-ID; bh=nTqLCk4hVI9OOsUvV3ZhT6qW/ZPyWW5FbEFi5tiXCH8=; b=GXFdxG9Xxp9oyDUW1zLuUG77ErkRHeuAlxO8jg2HRgwh30R/n1TrlyJsZewtbzxkMFZmWi85C+0fl+CpRHAsreAjmP8f/0Aa66OOoxjJtVyYUE1lgHPyIJ6VGf+AXVVrLGMGcXvxE7+hlH0/47D3+p8HhkKFI2f78y7Vog2z8ro=;
In-reply-to: <513891D7.4060801@xxxxxxxxxxxxxxxxx>
Organization: Booking.com
References: <1362060736.1247.30.camel@seahawk> <20130228194023.GQ5551@dastard> <1362577992.1247.84.camel@seahawk> <20130307035737.GC6369@dastard> <1362651128.16657.13.camel@seahawk> <513891D7.4060801@xxxxxxxxxxxxxxxxx>
On Thu, 2013-03-07 at 07:10 -0600, Stan Hoeppner wrote:
> On 3/7/2013 4:12 AM, Dennis Kaarsemaker wrote:
> > I see, so now I need to find out what's causing the larger average
> > request size. Would you happen to know a list of common causes?
> Given that mysql is doing the writes, that's the first place to look.

That is indeed where we started, but MySQL is configured exactly the
same on both thanks to puppet.

> Is the mysql version the same on all machines?  


> How about the config?

All that's different is server_id and prompt.

> How about the sql code driving the IO, is it the same?

They're replicating the same set of data.

> Is this host using a different mysql log or db file format?  Is the logging 
> method the same?  

All the same

> Is it writing the same
> total amount of data to the filesystem, but just in larger chunks?  Etc,

The "ten times as many bytes" is constant, so it is constantly writing
ten times as much data.
Dennis Kaarsemaker, Systems Architect
Herengracht 597, 1017 CE Amsterdam
Tel external +31 (0) 20 715 3409
Tel internal (7207) 3409

<Prev in Thread] Current Thread [Next in Thread>