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.

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 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.