Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    14

    Unanswered: how to change isolation level to READ COMMITTED

    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. #2
    Join Date
    Dec 2012
    Posts
    43
    You can perform a
    Code:
     $dbh->do("SET TRANSACTION ISOLATION LEVEL READ COMMITTED");
    Assuming that "$dbh" is your DBI-object name.

    TRANSACTION - commands don't have any effects on tables using storage engine MyISAM!

    See also:
    MySQL :: MySQL 5.5 Reference Manual :: 13.3.6 SET TRANSACTION Syntax

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •