The release notes for 1.8.3 indicate that there are performance improvements in 1.8.3, but the only thing I could see in the tracker list was..
http://tracker.moodle.org/browse/MDL-1883
"course/scales.php reallllllllly slow"
Was this the only performance improvement?
Sorry to bump.... but bump!!! Anyone?
Somebody wrote "Some crucial performance fixes" in the release notes
Somebody wrote "Some crucial performance fixes" in the release notes
I know some pretty heavy performance work went into HEAD in the last month before 1.9 stable was branched, and 1.8.3 was released after that, but I'm not sure if the performance work was rolled into 1.8.3. Hopefully one of the lead devs will chime in.
-eric
-eric
The wiki history says that Martin (D) wrote that. He is currently travelling round the world - I think he is in Spain right now - so don't expect an instant response.
I think it was just some change to some particular things, like forum digests cron. The major performance improvements to accesslib were 1.9 only.
I think it was just some change to some particular things, like forum digests cron. The major performance improvements to accesslib were 1.9 only.
For very large sites the scales perf issue was a big one, and a fix for that specific issue was crucial. I don't have a full CVS log at hand, maybe there are other performance fix commits too...
We had a problem with 1.8.2+ a few months ago when we tried to upgrade. On login there is a massive SQL query that loaded context/roles data that was taking 2+ seconds to run for each login, and MySQL more or less locked up during it, which brought the site to a halt, so we had to move back to our old site.
We haven't done much testing yet (because we are getting new hardware too), but I'm hoping the optimizations in 1.9 will help.
We had ~24,000 users and ~12000 course on the system and were getting ~150-250 page views/minute (well, that was when we rolled back and the system could actually serve pages again).
We haven't done much testing yet (because we are getting new hardware too), but I'm hoping the optimizations in 1.9 will help.
We had ~24,000 users and ~12000 course on the system and were getting ~150-250 page views/minute (well, that was when we rolled back and the system could actually serve pages again).
It's probably MDL-11347 and the related issues. Looks like that this has been fixed in 1.9.
Yeah, I think so too, but we are we have been waiting to do new load testing until the new servers get installed, which should be done by the time I get back from the UK *fingers crossed*
Eric,
What programs are you planning on using for doing your load testing? We are investigating JMeter/Badboy and Tsung/Sing-Tsung.
What programs are you planning on using for doing your load testing? We are investigating JMeter/Badboy and Tsung/Sing-Tsung.
http://tracker.moodle.org/browse/MDL-10635
This is one I know of. It did significantly cut down on queries for me when a student viewed a course.
This is one I know of. It did significantly cut down on queries for me when a student viewed a course.
By the way there is a post by Martin L about performance patches that went into 1.9 and HEAD.
http://moodle.org/mod/forum/discuss.php?d=79455
Is anyone looking to backport these changes to MOODLE_18_STABLE branch soon? Just curious...
I don't think most of these changes are in MOODLE_18_STABLE yet.
http://moodle.org/mod/forum/discuss.php?d=79455
Is anyone looking to backport these changes to MOODLE_18_STABLE branch soon? Just curious...
I don't think most of these changes are in MOODLE_18_STABLE yet.
Hi,
there are some performance improvements in 1.8.3 - most notably in the login process and course page. Please make sure that the record cache is turned on.
The changes in HEAD are very big, in fact it was a major rewrite of roles internals. I do not think it is possible to backport it into 1.8.x - there might be still some minor hidden problems in the new code and there are other more important bugs to fix in 1.9dev.
skodak
there are some performance improvements in 1.8.3 - most notably in the login process and course page. Please make sure that the record cache is turned on.
The changes in HEAD are very big, in fact it was a major rewrite of roles internals. I do not think it is possible to backport it into 1.8.x - there might be still some minor hidden problems in the new code and there are other more important bugs to fix in 1.9dev.
skodak