[imp] IMP performance under load

Jon Parise jon@csh.rit.edu
Tue, 24 Apr 2001 12:51:23 -0400


On Tue, Apr 24, 2001 at 11:41:04AM -0500, Chris Crowley wrote:

> I ran IMP on a IBM Netfinity single 500Mhz processor with 128MB memory. This
> was too small for even the test group of users it was running for. I would
> regularly see very high load (up to 100) on this machine.  I had a script
> which would sense this condition, stop the apache server, restart MySql,
> then restart apache. This was sufficient to bring the load back into line
> until the next time it went out of control
 
Just note that, in general, restarting MySQL (or any database,
for that matter) will generally degrade its overall performance
due to lost cached contents.

-- 
Jon Parise (jon@csh.rit.edu)  .  Rochester Inst. of Technology
http://www.csh.rit.edu/~jon/  :  Computer Science House Member