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,
09, 2002 5:18 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL on Linux 2.4 question
>
>
> Anyone else out there been playing with the new Linux 2.4 kernel?
>
> I just upgraded a test server from 2.2 to 2.4 and reran some
> of my InnoDB
> tests. The results were dramatic; up
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 playi
Anyone else out there been playing with the new Linux 2.4 kernel?
I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB
tests. The results were dramatic; updating a 600,000 row table went from 21
minutes and change to 6 minutes and change.
Haven't tried 2.4 and MyISAM tables
