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. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]