ozeman, Montana
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 3:59 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL on Linux 2.4 question
Walt,
a possible reason is that fsync is much faster in Linux-2.4 than in 2.2.
Check that the combine
On Thu, Jan 10, 2002 at 12:59:01AM +0200, Heikki Tuuri wrote:
> Walt,
>
> The kernel 2.4.4-SMP-64GB has been very stable on our 2-way
> computer. Somewhere in about version 2.4.10 Linus changed the
> virtual memory. I am not sure how stable kernels 2.4.10 - .17 are,
> but at least some people ar
Walt,
a possible reason is that fsync is much faster in Linux-2.4 than in 2.2.
Check that the combined size of your log files is 50 % - 100% of the buffer
pool size. Small log files cause more disk i/o and more fsyncs.
The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer.
Somewh
Walt,
Yup, we use Innodb with 3.23.46 on Linux 2.4.2. I can't tell you whether
things are better than they were on 2.2 kernels but we're updating
tables just about that quickly I'd say. Largest table we have is a log
table which has 50 million rows in it so far. Thanks to Innodb row
locking,
Amazing! I've not had a chance to upgrade a server to
2.4 yet, though I've long imagined that the results would
be similar.
I imagine the biggest performance boost you received is
due to the built-in multi-threading that the 2.4 kernel
enjoys which is currently lacking in the 2.2 kernel.
L
600,000 row table?
what are you storing on that bad boy?
- Original Message -
From: "Weaver, Walt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 2:17 PM
Subject: MySQL on Linux 2.4 question
> Anyone else out there been playing with the new Linux 2.4 ker
