MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: Should I need to commit a read transaction ?
Posted by: Mark Matthews
Date: August 31, 2015 11:14AM

Short answer, yes.

Long answer, even read-only transactions can take locks, and they can cause versions of rows to be maintained until the transaction is committed to provide the MVCC functionality, thus if you're not committing even read-only transactions you're (over)using resources.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Should I need to commit a read transaction ?
murali tharan
August 27, 2015 07:53AM
Re: Should I need to commit a read transaction ?
Mark Matthews
August 31, 2015 11:14AM
Re: Should I need to commit a read transaction ?
MURALI MARIAPPAN
September 01, 2015 09:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.