Over the last few days we have had a real problem with slow loading pages within moodle and more often than not it fails to load a full page.
I have attached our ini files for both mysql and php and would be most grateful if somebody could give some insight into any changes I should make.
We have Moodle version 1.8.3
with 5284 registered users
Cron runs every 5mins
4 x 3.2ghz processors
12gb ram (available)
As this is quite high spec I'm assuming its the ini files that require tweaking?
All help much appreciated.
Which win2003-version exactly? Why the detour vmware? Is each application (Web/PHP/Mysql) real-64bit?
32bit-windows-versions is problematic (a bug?); see http://support.microsoft.com/kb/888732 ( http://support.microsoft.com/?scid=kb%3Ben-us%3B888732&x=18&y=17 ).
Windows uses the remaining space (over 2G - partially) only as HD-Cache (with 32bit); 32bit-processes (on x64) anyways use max.2G RAM ;)
A alternative is linux
When you say you have 12GB available, do you mean 'installed in total', or 'shown as available in system monitor'?
How do I skip-innodb(how do i know that I'm not using it) As in the my.ini file it says "the default storage engine that will be used when create new tables when default-storage-engine=INNODB"
The server has 12gb of ram installed, as we thought this may solve the slow loading problem.
i believe INNODB is more efficient than MYISAM in situations with many silmultaneous accesses (see ) (it seems to be the case here)
as the mysql MYISAM locking scheme is based on table, the whole table is locked when a registry is updated... (so a queue is formed .. making MOODLE work slowly)
with INNODB, just the updated record is locked.. it has a greater memory cost (used to control the locking that is more fine grained and has more control structures) but has better performance at all (in this situation)
dont u agree?
I have checked and our tables are INNODB.
I have some new DB questions.
What consiquences do I face if I use any of the following
'OPTIMIZE TABLE table_name;'
'FLUSH QUERY CACHE'
on all my moodle tables.
I am trying to tune/cleanup our db but can't find much info on these commands other than how to run them.