Server load and MYSQL

[Dave Hull]

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

	"What time is it?"
	"I don't know, it keeps changing."