I ran the trace please see below</p? 

    DBI 1.631-ithread default trace level set to 0x300/7 (pid 4275 pi 
+100800000) at sel_ftp_files.pl line 82 via sel_ftp_files.pl line 55
    -> do for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f39188 'S
+ET TRANSACTION ISOLATION LEVEL READ COMMITTED') thr#100800000
mysql.xs do() use_server_side_prepare 0, async 0
mysql_st_internal_execute MYSQL_VERSION_ID 50528
>parse_params statement SET TRANSACTION ISOLATION LEVEL READ COMMITTED
    <- do= '0E0' at ./sel_ftp_files.pl line 86 via  at ./sel_ftp_files
+.pl line 55
    -> commit for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f3918
+8) thr#100800000
    <- commit= 1 at ./sel_ftp_files.pl line 88 via  at ./sel_ftp_files
+.pl line 55
$VAR1 = '0E0';
    -> selectrow_array for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0
+x100f39188 'SELECT * FROM information_schema.global_variables WHERE v
+ariable_name = 'tx_isolation'') thr#100800000
1   -> prepare for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNER 'SE
+LECT * FROM information_schema.global_variables WHERE variable_name =
+ 'tx_isolation'' undef) thr#100800000
2   -> _async_check for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNE
+R) thr#100800000
2   <- _async_check= 1 at /Library/Perl/5.10.0/darwin-thread-multi-2le
+vel/DBD/mysql.pm line 227 via  at ./sel_ftp_files.pl line 92
    New 'DBI::st' (for DBD::mysql::st, parent=DBI::db=HASH(0x100f39188
+), id=undef)
    dbih_setup_handle(DBI::st=HASH(0x100f3a698)=>DBI::st=HASH(0x100f3a
+4d0), DBD::mysql::st, 100f3c128, Null!)
    dbih_make_com(DBI::db=HASH(0x100f39188), 10221b9a0, DBD::mysql::st
+, 448, 0) thr#100800000
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Err, DBI::db=HASH(0x1
+00f39188)) SCALAR(0x10088dba8) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), State, DBI::db=HASH(0
+x100f39188)) SCALAR(0x10088dc68) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Errstr, DBI::db=HASH(
+0x100f39188)) SCALAR(0x10088dc08) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), TraceLevel, DBI::db=H
+ASH(0x100f39188)) 0 (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), FetchHashKeyName, DBI
+::db=HASH(0x100f39188)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), HandleSetErr, DBI::db
+=HASH(0x100f39188)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), HandleError, DBI::db=
+HASH(0x100f39188)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), ReadOnly, DBI::db=HAS
+H(0x100f39188)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Profile, DBI::db=HASH
+(0x100f39188)) undef (not defined)
    -> dbd_st_prepare MYSQL_VERSION_ID 50528, SQL statement: SELECT * 
+FROM information_schema.global_variables WHERE variable_name = 'tx_is
+olation'
    >- dbd_st_free_result_sets
    <- dbd_st_free_result_sets RC -1
    <- dbd_st_free_result_sets
>count_params statement SELECT * FROM information_schema.global_variab
+les WHERE variable_name = 'tx_isolation'
    <- dbd_st_prepare
1   <- prepare= DBI::st=HASH(0x100f3a698) at ./sel_ftp_files.pl line 9
+2 via  at ./sel_ftp_files.pl line 55
 -> dbd_st_execute for 100f6c5c0
    >- dbd_st_free_result_sets
    <- dbd_st_free_result_sets RC -1
    <- dbd_st_free_result_sets
mysql_st_internal_execute MYSQL_VERSION_ID 50528
>parse_params statement SELECT * FROM information_schema.global_variab
+les WHERE variable_name = 'tx_isolation'
 <- dbd_st_execute returning imp_sth->row_num 1
    -> dbd_st_fetch
        dbd_st_fetch for 100f6c5c0, chopblanks 0
    dbd_st_fetch result set details
    imp_sth->result=1004d6030
    mysql_num_fields=2
    mysql_num_rows=1
    mysql_affected_rows=1
    dbd_st_fetch for 100f6c5c0, currow= 1
    dbih_setup_fbav alloc for 2 fields
    dbih_setup_fbav now 2 fields
    <- dbd_st_fetch, 2 cols

--> dbd_st_finish
    >- dbd_st_free_result_sets
    <- dbd_st_free_result_sets RC -1
    <- dbd_st_free_result_sets

<-- dbd_st_finish
    <- selectrow_array= ( 'TX_ISOLATION' 'REPEATABLE-READ' ) [2 items]
+ at ./sel_ftp_files.pl line 92 via  at ./sel_ftp_files.pl line 55
    <> DESTROY(DBI::st=HASH(0x100f3a698)) ignored for outer handle (in
+ner DBI::st=HASH(0x100f3a4d0) has ref cnt 1)
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x100f3a4d0)~INNER) th
+r#100800000
    <- DESTROY= undef at ./sel_ftp_files.pl line 93 via  at ./sel_ftp_
+files.pl line 93
    DESTROY (dbih_clearcom) (sth 0x100f3a4d0, com 0x10221ce00, imp DBD
+::mysql::st):
       FLAGS 0x100191: COMSET Warn RaiseError PrintError PrintWarn 
       PARENT DBI::db=HASH(0x100f39188)
       KIDS 0 (0 Active)
       NUM_OF_FIELDS 2
       NUM_OF_PARAMS 0
    dbih_clearcom 0x100f3a4d0 (com 0x10221ce00, type 3) done.

    -> commit for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f3918
+8) thr#100800000
    <- commit= 1 at ./sel_ftp_files.pl line 93 via  at ./sel_ftp_files
+.pl line 55
$VAR1 = 'TX_ISOLATION';
$VAR2 = 'REPEATABLE-READ';

### TESTING REMOVE FOR PRODUCTION
    -- DBI::END ($@: , $!: )
    -> disconnect_all for DBD::mysql::dr (DBI::dr=HASH(0x100f3e128)~0x
+100f38848) thr#100800000
    <- disconnect_all= (not implemented) at /Library/Perl/5.10.0/darwi
+n-thread-multi-2level/DBI.pm line 750 via  at ./sel_ftp_files.pl line
+ 100
!   <> DESTROY(DBI::db=HASH(0x100f392d8)) ignored for outer handle (in
+ner DBI::db=HASH(0x100f39188) has ref cnt 1)
!   -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNER) th
+r#100800000
imp_dbh->pmysql: 102811600
!   <- DESTROY= undef during global destruction
    DESTROY (dbih_clearcom) (dbh 0x100f39188, com 0x10221b9a0, imp glo
+bal destruction):
       FLAGS 0x100191: COMSET Warn RaiseError PrintError PrintWarn 
       PARENT DBI::dr=HASH(0x100f38848)
       KIDS 0 (0 Active)
       IMP_DATA HASH(0x100f39200)
    dbih_clearcom 0x100f39188 (com 0x10221b9a0, type 2) done.

!   <> DESTROY(DBI::dr=HASH(0x100f3e128)) ignored for outer handle (in
+ner DBI::dr=HASH(0x100f38848) has ref cnt 1)
!   -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0x10
+0f38848)~INNER) thr#100800000
!   <- DESTROY= undef during global destruction
    DESTROY (dbih_clearcom) (drh 0x100f38848, com 0x1020c4dc0, imp glo
+bal destruction):
       FLAGS 0x180215: COMSET Active Warn PrintWarn AutoCommit 
       PARENT undef
       KIDS 1 (1 Active)
    dbih_clearcom 0x100f38848 (com 0x1020c4dc0, type 1) done.

[download]

In reply to Re^3: DBI mysql set transaction isolation level (trace) by Anonymous Monk
in thread DBI mysql set transaction isolation level by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.