Re: Locking in MyISAM

2004-08-02 Thread Jeremy Zawodny
On Fri, Jul 23, 2004 at 01:44:16PM -0400, Michael Sleman wrote: > Does MyISAM lock the whole table when doing SELECTs? Yes, each client obtains a read lock on the table for a SELECT query. > How about if there are several processors? Is there locking? It's no different with multiple CPUs. Jerem

Locking in MyISAM

2004-07-23 Thread Michael Sleman
Does MyISAM lock the whole table when doing SELECTs? How about if there are several processors? Is there locking?