Server load and MYSQL

[Dave Hull]

On Mon, 21 Oct 2002 crash3m at comcast.net wrote:

> with those specs I dont think medusa/webmin etc... are going to be the
> problem.   I suggest running top/ps to see whats chewing up the ram/cpu
> then eliminating the problem.   DB queries can be quite intensive from
> my understanding, but then again I dont do DB's so my opinion use
> pretty much useless I'm sure ;)

/me removes Oracle DBA hat and tries to find MySQL DBA hat...

Do you have adequate indexes on your MySQL tables? You're getting much 
heavier traffic than I have ever had to deal with and the number of 
variables at play here is large, but if it's MySQL that's eating your 
resources, try to find some good information on tuning MySQL. 

You said this box has 1GB of RAM, how much of it is being used at any 
given time, on average, max?

Depending on that information, I'd consider increasing the key_buffer_size 
parameter for MySQL. This will increase the "cache hits" thus preventing 
the box from going to disk as much, which should speed things up a bit.

Also increasing the table_cache parameter will cause more table data to be 
kept resident in RAM, thus decreasing disk IO.

Other things to consider mucking with are record_buffer and sort_buffer, 
but be careful with increasing these too much if you have a large number 
of session connections.

I would try adjusting the key_buffer_size and table_cache first and see 
what happens.

Good luck.

-- 
Dave Hull
http://insipid.com

And now for something completely the same.