Jump to content


Photo

transaction alternative


  • Please log in to reply
2 replies to this topic

#1 JakeHarlan

JakeHarlan
  • New Members
  • Pip
  • Newbie
  • 3 posts
  • LocationFlorida

Posted 29 December 2003 - 03:58 AM

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?

#2 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,667 posts
  • LocationLos Angeles, CA USA

Posted 29 December 2003 - 07:44 AM

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.

#3 JakeHarlan

JakeHarlan
  • New Members
  • Pip
  • Newbie
  • 3 posts
  • LocationFlorida

Posted 29 December 2003 - 01:03 PM

great.
thanks for the info.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users