Re: what should be the value of innodb_flush_log_at_trx_commit

2006-08-28 Thread Visolve DB Team
9, 2006 10:16 AM Subject: what should be the value of innodb_flush_log_at_trx_commit hello all, We do not run transactions at all on our db. All our queries are autocommit. So what should be the value set to this variable : innodb_flush_log_at_trx_commit We currently have it set to 1 and al

what should be the value of innodb_flush_log_at_trx_commit

2006-08-28 Thread Ratheesh K J
hello all, We do not run transactions at all on our db. All our queries are autocommit. So what should be the value set to this variable : innodb_flush_log_at_trx_commit We currently have it set to 1 and all our tables are Innodb. Since we are not running any transactions at all, is it better t