Re: Performance Problems with InnoDB Row Level Locking...

2002-09-06 Thread Heikki Tuuri
Alex, - Original Message - From: "Varshavchick Alexander" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 11:49 AM Subject: Re: Performance Problems with InnoDB Row Level Locking..

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-06 Thread Varshavchick Alexander
o: Varshavchick Alexander <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Performance Problems with InnoDB Row Level Locking... > > Alexander, > > - Original Message - > From: "Varshavchick Alexander" <[EMAIL PROTECTED]> > To: "

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-06 Thread Heikki Tuuri
Joe, - Original Message - From: "Joe Shear" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 2:13 AM Subject: Re: Performance Problems with InnoDB Row Level Locking... > Hi, > On a side note, are there any

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-06 Thread Heikki Tuuri
Alexander, - Original Message - From: "Varshavchick Alexander" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 10:08 AM Subject: RE: Performance Problems with InnoDB

RE: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Varshavchick Alexander
Hi Heikki, one more question please about innodb_flush_log_at_trx_commit: if there was some way of increasing the delay between log flushes more than 1 sec, can you estimate will it bring any real effect in performance? I know it'll raise the risk of losing some last transactions if something cra

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Heikki Tuuri
Steve, - Original Message - From: "Orr, Steve" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 1:23 AM Subject: RE: Performance Problems with InnoDB Row Level Locking

RE: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Orr, Steve
teve -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 2:54 PM To: Orr, Steve Cc: [EMAIL PROTECTED] Subject: Re: Performance Problems with InnoDB Row Level Locking... Steve, - Original Message - From: "Orr, Steve" <[EM

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Heikki Tuuri
Steve, - Original Message - From: "Orr, Steve" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 11:04 PM Subject: RE: Performance Problems with InnoDB Row Level Locking... > Heikki, > >

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Heikki Tuuri
i - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: "Orr, Steve" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 10:30 PM Subject: Re: Performance Problems with InnoDB Row Level Locking... > Steve, >

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Heikki Tuuri
Steve, - Original Message - From: "Orr, Steve" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 9:49 PM Subject: RE: Performance Problems with InnoDB Row Level Locki

RE: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Orr, Steve
t atomic then does that mean that MySQL still does not pass the ACID test even with InnoDB? Thanks again and I'm eagerly awaiting your reply. Respectfully, Steve Orr -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:05 AM To:

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Heikki Tuuri
Alexander, - Original Message - From: "Varshavchick Alexander" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 6:51 PM Subject: Re: Performance Problems with InnoDB Row Level Lock

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Varshavchick Alexander
Heikki, one little question - is it a mistype, or can a flush log interval duration be controlled by this option? The value should only be 0 or 1 as the documentation says... On Thu, 5 Sep 2002, Heikki Tuuri wrote: > You can try setting > > innodb_flush_log_at_trx_commit=2 > > if you can afford

Re: Performance Problems with InnoDB Row Level Locking...

2002-09-05 Thread Heikki Tuuri
Steve, - Original Message - From: ""Orr, Steve"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, September 05, 2002 5:52 PM Subject: Performance Problems with InnoDB Row Level Locking... > Background: > I've developed a simplistic Perl program to test database per