JakeHarlan Posted December 29, 2003 Share Posted December 29, 2003 My web host does not allow INNODB tables so I am forced to look for an alternative to transactions. If I lock a table in a myISAM table will reads/writes queue or are they returned to the instigating program in error? Quote Link to comment Share on other sites More sharing options...
gizmola Posted December 29, 2003 Share Posted December 29, 2003 Mysql is a table locking database. Selects/inserts and updates all lock the table... so queuing is an intrinsic function of the database. Mysql uses priorities... the default is that writes are processed in the order received, and have a higher priority than reads. Nevertheless, Reads also lock the database from writes. By default LOCK TABLES will block/wait until it gets all the table locks you are asking for. Quote Link to comment Share on other sites More sharing options...
JakeHarlan Posted December 29, 2003 Author Share Posted December 29, 2003 great. thanks for the info. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.