Re: can't set tx_isolation=read-commited in my.cnf - Martin - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRe: can't set tx_isolation=read-commi...

From	Sent On	Attachments
dcha...@actemium.com	18 Apr 2003 07:06
Stefan Hinz	18 Apr 2003 07:56
Martin	18 Apr 2003 09:45

Subject:	Re: can't set tx_isolation=read-commited in my.cnf
From:	Martin (mgai...@hotmail.com)
Date:	04/18/2003 09:45:29 AM
List:	com.mysql.lists.mysql

Didier,

I am trying to set the variable tx_isolation in the file /etc/my.cnf I have tried many syntaxes and none of them works: set-variable = tx_isolation = READ-COMMITTED set-variable = transaction_isolation=READ-COMMITTED ......

All that dash / underscore / space stuff for the InnoDB settings can in fact be quite confusing.

Chapter 8 of the InnoDB Reference Manual (http://www.innodb.com/ibman.html) says that the my.cnf transaction isolation option setting should look like this:

transaction-isolation = READ-COMMITTED

Note the dash (-). For most other options it's the underscore. You could also enter:

set-variable = transaction-isolation = READ-COMMITTED

but that syntax is deprecated.

Regards,

[filter fodder: sql, mysql, query]