how to change isolation level to READ COMMITTED

Linux and Unix-Like UNIX and Linux Applications
1

Hi,

I am using perl DBI and mysql-5.0.26 on unix.
Could you please let me know or point to source on how to set isolation level to READ COMMITTED .

~Thanks

2

try using this statement. MySQL :: MySQL 5.1 Reference Manual :: 12.3.6 SET TRANSACTION Syntax

3

Thanks , below is the code snippet to set it using perl DBI

$dbh->do("SET TRANSACTION ISOLATION LEVEL READ-COMMITTED");