MySQL Forums
Forum List  »  MyISAM

Concurrency explanation for myisam tables?
Posted by: jsjensen
Date: March 16, 2005 10:10PM

I am quite used to a transactional RDBMS but wanting to learn MySQL for mass volumes of data processing.

What are the limitations on concurrent updates to a MyISAM table? If I have a number of connections to the DB each issuing updates to /independent/ columns of a single table from a read from another table, how is MySQL going to handle this? Is each UPDATE queued and synchronized with a lock on the table itself? Can true concurrent updates occur? and if so does MySQL use temp files (in a log fashion) to accomplish this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Concurrency explanation for myisam tables?
3637
March 16, 2005 10:10PM


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.