Re: Force a COMMIT on InnoDB tables? (set autocommit=0)

2006-03-30 Thread patrick
Is there any way to make this the default behaviour? I did a Google search, and it was suggested I put the following line in /etc/my.cnf: [mysqld] init_connect='set autocommit=0' This works fine, but I worry that this will affect all incoming connections regardless of whether or not they are

Re: Force a COMMIT on InnoDB tables? (set autocommit=0)

2006-03-30 Thread patrick
I've confirmed that this does affect ALL incoming connections. On 3/30/06, patrick [EMAIL PROTECTED] wrote: Is there any way to make this the default behaviour? I did a Google search, and it was suggested I put the following line in /etc/my.cnf: [mysqld] init_connect='set autocommit=0'