Message-ID: <00dd01c27982$63a014a0$c901a8c0@aaronmhzggcto3> From: "Aaron" <aaron@aarons.net> Subject: Re: Server load and MYSQL Date: Mon, 21 Oct 2002 18:15:30 -0500
> 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