Really you need to look at what your server is doing, the traffic patterns, then you can tune. There is a lot you can determine by
just looking at the output of SHOW STATUS and SHOW VARIABLES.
Threads_created number high and growing? Increase the thread_cache_size
variable.
Opened_tables number
I highly recommend Jeremy Zawodny's "High Performance MySQL"
from O'Reilly.
Dan
On 9/12/06, Gregory T Pelle <[EMAIL PROTECTED]> wrote:
Hello,
I am looking for some advice regarding the tuning of a dedicated MySQL
database server.
The machine in questions is a Dell 2850 with dual Xeon procs a
