BrnDmp

Server problems client

Got some problems with a client’s mysql database. Some processes were ‘blocking’ the rest. No heavy server load or anything. So after checking and optimizing a few key Moodle tables performance was back on track:

CHECK TABLE mdl_user / mdl_course_sections / mdl_log

OPTIMIZE TABLE mdl_user / mdl_course_sections / mdl_log

Seems logical as with the start of a new school year, new users are added so indexes should be optimized.

Resource usage was far less and performance got a boost. CPU is now mainly taken by clamscan.