Locking in MyISAM

Does MyISAM lock the whole table when doing SELECTs? How about if there are several processors? Is there locking?

Tuning MySQL for Large Database

Hello, We're running 1 web server (apache 2 & php) / 1 dedicated DB server (MySQL 4.0.20-standard) and are experiencing serious performance issues on the DB during some load testing. Hardware on both Dual Xeon 2.8GHz, 2GB RAM The database size is a little under 1 GB. Naturally, we started takin