We were working with moodle 1.4.4 on a Sun Enterprise 250 with 2 proc (400 MHz), 512M RAM and Solaris 9 OS. Everything was working fine....
Recently (3 weeks ago) we moved to a SunFire 6800 server with 2 proc (900 MHZ), 4G RAM and Solaris10 OS. Also we updated from moodle 1.4.4 to moodle 1.5.2
Seems like more hardware would have better performance, but two weeks ago users start to report very slow sessions, and for some time impossible to log in into the system or even going from one page to another o an active session.
"top" command report "mysqld" using 50% of CPU and 90% peaks over 30 minutes, wich makes imposible to use a shell session.
Last weekend we changeg mysql version to 4.0.25 (package from mysql.com), moved from apache 2.0.54 to apache 1.3.33 with php 5.0.4 and updated moodle to 1.5.2 daily built (from august 26th), but mysql still reports heavy CPU usage with very few sessions (20, 10 even less)
Sun SF6800 2proc 900 MHz, 4G RAM, Solaris 10
Apache 1.3.33, PHP 5.0.4, MySQL 4.0.25
Moodle 1.5.2 daily built (from Aug 26th)
extra modules: questionnaire, hotpotatoes, books
Any ideas guys?