MySQL Forums
Forum List  »  Newbie

Does START TRANSACTION cause locks
Posted by: Joey JS
Date: February 14, 2015 02:34PM

Is there any reason NOT to use the below; e.g. not using any C/U/D statements?

START TRANSACTION;
SET autocommit=0;

SELECT * FROM my_table;

COMMIT;

i.e. Does this lock/slow the query - I couldn't find anything conclusive.

I appreciate this question might even seem pointless but it'll likely lead me on to more research/questions.

Thanks

Joey

Options: ReplyQuote


Subject
Written By
Posted
Does START TRANSACTION cause locks
February 14, 2015 02:34PM


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.