command to check value of autocommit and isolation level

Thread Tools Search this Thread
Special Forums UNIX and Linux Applications command to check value of autocommit and isolation level
# 1  
Old 08-23-2011
command to check value of autocommit and isolation level


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

# 2  
Old 08-23-2011
print "AutoCommit: $dbh->{AutoCommit}\n";

With AutoCommit enabled, that would print:
AutoCommit: 1
as you might expect. Actually, since AutoCommit is a boolean attribute, it would print 1 after any value that Perl considers true had been assigned to it.
After a false value was assigned, you may reasonably expect a 0 to be printed, but you might be surprised to see:
That's because Perl uses an internal representation of false that is both a numeric zero and an empty string at the same time. When used in a string context, the empty string is printed. In a numeric context, the zero is used.

Advanced DBI (Programming the Perl DBI)
This User Gave Thanks to itkamaraj For This Post:
# 3  
Old 08-23-2011
go it commands are :

select @@session.autocommit,@@session.tx_isolation;
| @@session.autocommit | @@session.tx_isolation |
|                    1 | REPEATABLE-READ        |
1 row in set (0.00 sec)

---------- Post updated at 08:57 AM ---------- Previous update was at 08:55 AM ----------

thanks @itkamaraj
print with $dbh that you posted helps.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Command to check only Autosys running jobs with autorep like command

Hi, Is there any specific command to use to check only say Running jobs via autorep or similar command for Autosys? (0 Replies)
Discussion started by: sidnow
0 Replies

2. Red Hat

SSL certificate generation on OS level or application level

We have a RHEL 5.8 server at the production level and we have a Java application on this server. I know of the SSL certificate generation at the OS (RHEL) level but it is implemented on the Java application by our development team using the Java keytool. My doubt is that is the SSL generation can... (3 Replies)
Discussion started by: RHCE
3 Replies

3. UNIX and Linux Applications

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 Replies)
Discussion started by: newbielgn
2 Replies

4. Web Development

[Solved] Disable mySQL autocommit

Hi. Does anyone know how I can disable auto-commit in mySQL? I've been Googling it for ages, and one suggestion that always comes up is adding this to /etc/my.cnf: ... init_connect='SET autocommit=0' But that didn't work. I then read that this wouldn't work anyway for a... (4 Replies)
Discussion started by: Scott
4 Replies

5. Solaris

Difference between run level & init level

what are the major Difference Between run level & init level (2 Replies)
Discussion started by: rajaramrnb
2 Replies

6. Linux

OS Patch level command

Hi Do let me know how to find OS Patch 's installed on Linux server ? Thanks ~ SPai (3 Replies)
Discussion started by: sbanala
3 Replies

7. AIX

how to set AUTOCOMMIT option in AIX

Hi, Can anybody tell,how to set the auto commit option in AIX,i have tried with environmental variables option like 'export db2option=-c +a'. But its not working in my environment. is there any other option? (1 Reply)
Discussion started by: DB2AIX
1 Replies

8. Infrastructure Monitoring

Firewall / Network isolation inquiry

Good morning folks, A good friend of mine has a network where every host has two paths to the file servers (two NICs & two networks for all hosts). Normally speaking, one network will be used for regular application traffic - license servers, itunes library, collaboration tools - while the... (4 Replies)
Discussion started by: avronius
4 Replies

9. UNIX for Advanced & Expert Users

process nice level command line vs cron

Under, Solaris 10 I have the following problem: A script executed at command line runs with nice level 0, as expected. Same script started under (user) crontab runs with nice level 2. I would prefer it run at 0. Is this possible? If so, how? Thanks. (0 Replies)
Discussion started by: henrydark
0 Replies
Login or Register to Ask a Question