From: Dennis Kaarsemaker <dennis.kaarsemaker@booking.com>
To: stan@hardwarefreak.com
Cc: xfs@oss.sgi.com
Subject: Re: XFS IO multiplication problem on centos/rhel 6 using hp p420i raid controllers
Date: Thu, 07 Mar 2013 14:33:08 +0100 [thread overview]
Message-ID: <1362663188.16657.20.camel@seahawk> (raw)
In-Reply-To: <513891D7.4060801@hardwarefreak.com>
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?
Yes.
> 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
Booking.com
Herengracht 597, 1017 CE Amsterdam
Tel external +31 (0) 20 715 3409
Tel internal (7207) 3409
_______________________________________________
xfs mailing list
xfs@oss.sgi.com
http://oss.sgi.com/mailman/listinfo/xfs
next prev parent reply other threads:[~2013-03-07 13:32 UTC|newest]
Thread overview: 13+ messages / expand[flat|nested] mbox.gz Atom feed top
2013-02-28 14:12 XFS IO multiplication problem on centos/rhel 6 using hp p420i raid controllers Dennis Kaarsemaker
2013-02-28 15:34 ` Stan Hoeppner
2013-02-28 19:40 ` Dave Chinner
2013-03-06 13:53 ` Dennis Kaarsemaker
2013-03-07 3:57 ` Dave Chinner
2013-03-07 10:12 ` Dennis Kaarsemaker
2013-03-07 13:10 ` Stan Hoeppner
2013-03-07 13:33 ` Dennis Kaarsemaker [this message]
2013-03-07 13:44 ` Stan Hoeppner
2013-03-07 13:52 ` Dennis Kaarsemaker
2013-03-07 23:00 ` Dave Chinner
2013-03-08 9:09 ` Dennis Kaarsemaker
2013-03-08 11:49 ` Dennis Kaarsemaker
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=1362663188.16657.20.camel@seahawk \
--to=dennis.kaarsemaker@booking.com \
--cc=stan@hardwarefreak.com \
--cc=xfs@oss.sgi.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox