Server Tuning

Some notes on tuning a server for MKDoc.

mod_perl

See the Performance Tuning document from the mod_perl 1.0 User Guide.

MySQL

Each apache process will use on MySQL process so the MySQL max_connections should not be set to be less than the Apache MaxClients.

See the Solving Memory Bottlenecks section of the High Performance MySQL book is worth looking at.

The MySQL you have probably came with sample config files for different situations, for example in /usr/share/mysql/*.cnf — it's probably best to pick the one best suited and use this as a basis for the MySQL main config file, /etc/my.cnf.

You can view the variables like this:

mysqladmin -uroot -pXXX variables

And you can see the number of processes like this:

mysqladmin -uroot -pXXX processlist

The mytop perl module is good for displaying mysql processes dynamically.