Server load and MYSQL

[Aaron]

> Are your doing much updating to MySql or just reading the database?  MySql
> does not handle massive updates very well. I believe the standard install
> of MySql locks the table whenever you do an update.  If you only do a few
> updates its not a big deal.  If you do thousands of updates it can cause
> alot of deadlocks and maybe some of your cgi processes to hang.  If you
> are doing alot of updates you might want to use MySql-Max (from
> mysql.com).  MySql-Max supports the InnoDb table type which allows row
> level locking.

Updating.  It's an active message board.  I wouldn't sat thousands of
writes, but hundreds definitely.  I'll look into MySQL-Max.

Aaron