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

    Unanswered: command to check value of autocommit and isolation level

    Hi,

    Pls let me know command to get following:

    1. how to check current value of autocommit
    2. how to check current value of isolation level
    I am using mysql-5.0.26 on unix

    -Thanks

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    1. SELECT @@autocommit;
    2. SELECT @@tx_isolation;
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Jul 2011
    Posts
    14
    thanks it-iss.com

Posting Permissions

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