Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

2002-01-02 Thread Michael T. Babcock
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 shove in

RE: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

2001-12-27 Thread Weaver, Walt
:[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 is partially a reply to a request to share my MyISAM/InnoDB/Oracle comparison testing

MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

2001-12-26 Thread Weaver, Walt
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, and Oracle for the past two weeks

Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

2001-12-26 Thread Heikki Tuuri
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, and

Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

2001-12-26 Thread Philip Molter
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 :

Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

2001-12-26 Thread Heikki Tuuri
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 individually