dear moodlers
i have moodle installed on windows server 2012 machine using apache as web server and mysql as db server, the hardware configuration is hp proliante with cpu 6 core, 40Go Ram, 1100Go, about users i have 29151 user, 6106 cours. the problem is the mysql consum around 9 GO of memory and apache consume aroud 3 GO of memory even there only the administratir is connected, really i do not know what is the problem? are there any suggestion to resolve this stuation
thank you
Qualifications for this response ... none ... I don't run Windows!
However, a guess ... from what you have described, could be related to cron job and adhoc_task. Cron running the recommended once every minute? Are there qued up cron jobs (adhoc_task) that didn't complete or are there cron jobs struggling to finish?
Login as an admin level and use admin search for 'adhoc' or 'cron'. Think one of those would pull up areas in admin related.
Good luck!
'SoS', Ken
Guess you missed my 'disclaimer' ...
Qualifications for this response ... none ... I don't run Windows!
so can't speak to cron nor adhoc task on that platform.
'SoS', Ken
Follow up ...
https://docs.moodle.org/400/en/Cron_with_Windows_OS
In your Moodle there are admin areas that relate ...
/admin/search.php?query=cron
also
/admin/search.php?query=adhoc
Normally, I'd recommend the installation of a perl script called MySQLtuner if OS was linux. Not sure you'd want to go that length as you'd have to install perl on Windows to be able to run tuner.
However, there is the following:
https://github.com/pmachapman/mysqltuner
Says it's for Windows. Obviously, cannot comment on how accurate/good it is.
'SoS', Ken
