Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

how to change isolation level to READ COMMITTED

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications how to change isolation level to READ COMMITTED
# 1  
Old 08-23-2011
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  
Old 08-23-2011
try using this statement. MySQL :: MySQL 5.1 Reference Manual :: 12.3.6 SET TRANSACTION Syntax
# 3  
Old 08-24-2011
Thanks , below is the code snippet to set it using perl DBI
Code:
$dbh->do("SET TRANSACTION ISOLATION LEVEL READ-COMMITTED");

Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Solaris

Change run level at boot

for solaris 11, how does one change the run level at boot from 3 to 2? i checked "/etc/inittab" file where i usually change it in other *nix but it seems solaris is not using it. (1 Reply)
Discussion started by: badbanana
1 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. Shell Programming and Scripting

gets all files details committed to svn by a particular user [or all users] since a particular date

Here is a shell for printing committed person's: 1. Revision number 2. Name 3. Date of commit 4. Files committed. 5. committing comment 6. Date I just made for my usage. May be helpful for you too. Do as follows. create a file $ vi svn_get_user_committed_files_details.sh press i... (3 Replies)
Discussion started by: linuxadmin
3 Replies

4. UNIX and Linux Applications

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

5. UNIX for Dummies Questions & Answers

How to change the log level for cron?

Hello, I'm wondering how to change the log level to level 2 for cron without manually have to restart it with every boot. I didn't thing this would be hard to find, but searching has cause me to come up empty. System is Ubuntu Karmic/9.10 With thanks, Narnie (6 Replies)
Discussion started by: Narnie
6 Replies

6. 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

7. UNIX for Dummies Questions & Answers

Copying files to a different server without Permission level change..

Hi, I was trying to copy/transfer some new and old files from one server to another server. I found the permission of the files are different in both servers. I tried to tar all the files and then send to the other server, and then also the permission level is different after copying the files.... (4 Replies)
Discussion started by: ronix007
4 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
Login or Register to Ask a Question