in reply to Re^2: DBI mysql set transaction isolation level
in thread DBI mysql set transaction isolation level

that was it!!!

The difference between

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

AND

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

AND as you pointed out in docs

Without any SESSION or GLOBAL keyword, the statement sets the isolation level for the next (not started) transaction performed within the current session.

Thanks all !!!

  • Comment on Re^3: DBI mysql set transaction isolation level

In Section Seekers of Perl Wisdom