We have moodle on Solaris machine V880 with the following configuration:
OS : Solaris 10, 2x900 Mhz, 4Gb RAM
We encountered a problem when the users trying to complete their online quizez concurrently for 150 users. The error was "Database Overloaded" and the CPU performance reached 100% and it became slow for other user to access the site. Is it something to do with database configuration or others? Pls help urgently.
If you have a testing server with same hardware/software configuration, you might want to try this script, it would tell you whether your DB server is under-powered or not. In general adding more RAM to the DB server would be a good idea. Hope this helps...