Nathan Ollerenshaw wrote:
> If you see a lot of SELECT all taking a long time to complete, you will
> probably find that any INSERT or UPDATEs going on are locking the whole
> table and stopping the SELECTs from completing (I'm sure there is a
> better explanation but I'm not a real DBA).
Not true:
<http://www.mysql.com/doc/en/Table_locking.html>
"In MySQL Version 3.23.7 and above, you can insert rows into MyISAM
tables at the same time other threads are reading from the table. Note
that currently this only works if there are no holes after deleted rows
in the table at the time the insert is made. When all holes has been
filled with new data, concurrent inserts will automatically be enabled
again."
Brian
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
|