Moodle 2.5.3+ (Build: 20131224)
I have been reading here and it seems (please correct me if wrong) that slowness in backups and especially restoring backups started to occur in Moodle 2 especially in Moodle versions of/and after 2.5 (i found many with this issue on Moodle 2.6, and again in 2.7) due to intense use of the database. I see these issues don't seem to have been fixed in Moodle's code.
Error-wise, i've seen the time out error, and i also have seen no errors and only massive slow response which seems to affect the entire moodle site.
I'm currently looking if there's something to be done on the db server to help this and looking at mysql logs , will report here if i find anything note worthy.
Is there a permanent fix , or temporary things I could do in the meantime? besides increasing the database server RAM and the app servers Max timeout time?
many thanks!