myisam knowledge.

[gommes]

Hello all,
I wana 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 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 to accomplish this? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

Concurrent updates of MyISAM tables are serialized by table locks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --