DB slowing down whan many users online

Re: DB slowing down whan many users online

by Ken Task -
Number of replies: 0
Picture of Particularly helpful Moodlers

Your screen shots are not debugging info.

Site Admin Menu -> Development -> Debugging - all the way to developer level to see what errors Moodle might be throwing.

Also check things like web service (error log) and DB logs.  Plus info on overall set up ... is DB server on a dedicated machine or is it on the same server as web server?  That sort of info.

Suggest installing a tool to help with DB config ... assuming linux, there is a handy tool called 'MySQLTuner' ... a perl script - command line only - which will help check if settings for the DB are optimal or in dire need of tweaking.

'SoS', Ken