server surcharge

[y2ksw]

Originally Posted by Nassou

open_files_limit=8192
max_allowed_packet=16M
max_connections=800
connect_timeout=10

I would not set any open file limit, or at most very high, and the packet size to 1M unless you have huge queries.

Also a number of 800 connections seem to me pretty high. A connection timeout of 10 seconds on the other hand may be too low, depending on your server load.

You may also try (carefully) permanent connections, which may help to reduce memory usage and speed certain things sensibly up, in particular when you have a lot of users and high hit rates.