MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Is it best practice to lock table for every Mysql query?
Posted by: Peter Brawley
Date: December 21, 2018 06:46PM

MyISAM is not designed for robust multi-user concurrency. Best practice is to use an ACID-compliant engine.

If you insist on disregarding that, for each query you have a choice: a consistent read that blocks all changes, or an inconsistent read that allows continuing inserts, updates and deletions.

Period.

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




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.