Hi. I have 2 moodle instances, a live on and a test one.
Live instance
Running Moodle 1.9.13+ on Debian Lenny
VMware ESX virtualised machine
MySQL 5.0.51a
PHP 5.2.6-1+lenny13
4GB RAM
4x 2Ghz CPU
Test instance
Running Moodle 1.9.13+ on Debian Lenny
MySQL 5.0.51a
PHP 5.2.6-1+lenny13
1GB RAM
1x 2Ghz CPU
Performance is acceptable for most usage, but creation and modification of courses is slow. This takes about 1min with the users browser hanging until it completes.
mysqld pegs a processor at 100% utilisation whilst this is happening.
The problem is not related to usage of the host, as both live and test ( which has practically zero utilisation ) show this behaviour.
Our mysql database is around 1.3Gbytes in size
Any hints on improving this appreciated.