Jump to content

Archived

This topic is now archived and is closed to further replies.

JakeHarlan

transaction alternative

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.