Moodle Very slow for users who are not administrators

Moodle Very slow for users who are not administrators

by Cristian Matos -
Number of replies: 7

Hi,

I have a problem with my environment, for me as admin the site low very fast(3-5 seconds) but for student or teachers is very slow, (20-30 seconds).

What might be happening here?


Thanks in advance

Average of ratings: -
In reply to Cristian Matos

Re: Moodle Very slow for users who are not administrators

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

You can't expect us to help with no background information at all - can you?

Moodle version? Server configuration? What have you done to try to diagnose this? Is this will all pages or certain pages? etc etc

This is odd because it's normally the other way around and I wouldn't call 3-5 seconds 'very fast'. 

Average of ratings: -
In reply to Howard Miller

Re: Moodle Very slow for users who are not administrators

by Cristian Matos -

Thanks,

This is our background:

Moodle 2.8.2

PHP 5.4

MySQL 5.5

24GB of RAM

8 Core

Average of ratings: -
In reply to Howard Miller

Re: Moodle Very slow for users who are not administrators

by Cristian Matos -

This is another thing that might help.

I'm viewing this query running in the background of our database a lot of time and when I run it by myself it takes a lot to load 4 minutes: 

SELECT NAME,VALUE FROM mdl_cache_flags WHERE flagtype = 'accesslib/dirtycontexts' AND expiry >= '1430831665' AND timemodified > '1430831449'

Thanks

Average of ratings: -
In reply to Cristian Matos

Re: Moodle Very slow for users who are not administrators

by Usman Asar -
Picture of Plugin developers Picture of Testers

Cristian,

some part of website rendering is to be done at client side, so I am assuming you are accessing your Moodle from the server, whilst teachers and students are using workstations which wont be as powerful as your server, but then 3-5 seconds is a lot considering accessing it from server itself.

Average of ratings: -
In reply to Usman Asar

Re: Moodle Very slow for users who are not administrators

by Cristian Matos -

I found the solution, I just recreated the table "mdl_cache_flags" and it fixed the problem. I realized that it had old registries.


Thanks.

Average of ratings: -
In reply to Cristian Matos

Re: Moodle Very slow for users who are not administrators

by Rajakumar Jillella -

Hi Cristian,

I have also same issue, and followed your solution step.

Truncated "mdl_cache_flags" table in database and tried to run the site.

There is no change on site loading. Taking time to load.

Please give me the right solution.


Thanks in Advance.

Average of ratings: -