Hosting Provided By

Re: Rollback on a Transaction with No Updates

From: Baron Schwartz <baron(at)xaprb.com>
Date: Wed Sep 19 2007 - 13:09:37 EDT

> Robert DiFalco wrote:

>> Is there any difference between calling rollback or commit on a
>> transaction that did not alter data? For example, not a read-only
>> transaction but a transaction that only performed read-only selects. Any
>> difference in performance between calling rollback or commit? I know
>> they are functionally the same at the high level.

I just thought of a difference. If you are using LOCK TABLES and UNLOCK TABLES, these interact differently with COMMIT and ROLLBACK. More info:

http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

Baron

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com

Received on Wed Sep 19 13:11:01 2007

This message: [ Message body ]
Next message: dpgirago(at)mdanderson.org: "Re: Slave Misbehavin'"
Previous message: Baron Schwartz: "Re: Slave Misbehavin'"
In reply to: Baron Schwartz: "Re: Rollback on a Transaction with No Updates"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:11:09 EDT