Re: about innodb_flush_log_at_trx_commit

2002-01-30 Thread Jeremy Zawodny
On Wed, Jan 30, 2002 at 03:06:36PM -0800, Joseph Drozdik wrote: > Hi all, > > I've been looking at the performance of mysql using innodb tables > and I've noticed that I can get a huge benifit by setting > innodb_flush_log_at_trx_commit = 0. The documentation warns me that > I can loose a couple

about innodb_flush_log_at_trx_commit

2002-01-30 Thread Joseph Drozdik
Hi all, I've been looking at the performance of mysql using innodb tables and I've noticed that I can get a huge benifit by setting innodb_flush_log_at_trx_commit = 0. The documentation warns me that I can loose a couple of seconds of transactions in system crash if I do this. It seems like a gr