On Wed, Dec 26, 2001 at 04:23:46PM -0600, Philip Molter wrote:
> Are there guides out there for configuring these things? What is
> a "big enough" log file? Honestly, on a lot of stuff, I'm just
> guessing, but it takes a lot of time to fiddle with values, clean
> out the database, and then shov
Weaver
Bozeman, Montana
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 26, 2001 3:19 PM
To: [EMAIL PROTECTED]
Subject: Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking
question
Walt,
thank you for the test!
>This post
Philip,
>On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote:
>: The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts
>: per second would not be possible. Did the table fit in the buffer pool of
>: InnoDB or the SGA of Oracle? Did you commit each insert individuall
On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote:
: The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts
: per second would not be possible. Did the table fit in the buffer pool of
: InnoDB or the SGA of Oracle? Did you commit each insert individually in
: InnoDB
Walt,
thank you for the test!
>This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle
>comparison testing with you guys. In addition, I have a question about
>locking mechanisms in InnoDB which I'll ask at the end of the post.
>
>I've been comparison testing MyISAM, InnoDB,
