Moodle - Slow when more than a few users are logged in

[wesleyw]

Someone has suggested this is down to MySQL and it needs tweaking.

Any ideas?

We're running the following:

PHP Version 5.2.3

NetBSD netmanager 3.1_STABLE NetBSD 3.1_STABLE

MySQL 4.1.22

Moodle 1.7.1+





Wes

[Geoff]

How have you come to the conclusion it's MySQL?

[wesleyw]

The rest of the websites we have running on the server seem completely unaffected.


Wes

[Geoff]

Download mysqlreport and post the results of

mysqlreport --all

[wesleyw]

13# mysqlreport -all
mysqlreport: Command not found.


All I get is the message above when trying to run it. I know I'm doing something wrong. I run this at the command line? or the MySQL command line or somewhere else?


Wes

[Geoff]

You need to use two dashes. Additionally, the current directory is not in your path. Also, you may need to modify the files permissions to make it executable.

[danIT]

Did you upgrade from a previous version of Moodle or is this a fresh install?

Also what authentication method are you using for students?

EDIT:

Ive also found this,

Try this php script (Attached) by copying into the root of your moodle directory where your moodle config.php is located. Run by browsing to http://my.moodle.com/moodle/mdl-db-opt.php. Move it out of that directory when you're done with it.

There's no guarantee it will make any difference but it will run the mysql CHECK, OPTIMIZE and ANALYZE (REPAIR also if needed) statements on all your tables.

As usual, switch moodle to maintenance mode, wait for all the users to be logged off and backup your database (mysqldump) before attempting to run the script.

You may need to allocate quite some time to this operation.

There seems to be some issues with indexes, multiple.

[wesleyw]

@Geoff: Moved it into my apache root directory and tried to run it still no joy how would I check which directories are in the path?


Wes

[Geoff]

set | grep PATH

[wesleyw]

@Geoff put it in a directory that was in the path but still no luck:

36 -rwxr-xr-x 1 root wheel 34145 Sep 20 22:24 mysqlreport


/usr/bin



netmanager 8# ./mysqlreport
./mysqlreport: Command not found.
netmanager 9# mysqlreport
mysqlreport: Command not found.





It's an upgrade from version 1.5, 1.6 et cetera.

It's using IMAP authentication. The Logins aren't too slow it's just using the VLE itself thats very slow.



Wes

[Geoff]

very odd, that should work.

[robknowles]

We are also having the same problems with Moodle (1.8) slowing down with more than a few users. However, we are running it on MS-SQL Server and I don't think that's causing the issues since other databases on that server seem fine.

I've tried both using the file system for Session States and moved using the database for storing it instead - this made next to no difference.

I'm running it on IIS using PHP 5.2.3. I'm going to move over the Apache to see if that makes any difference. We also use AD Authentication so I'm going to look at that possibly as well.

[wesleyw]

We're using IMAP authentication so if the problem is related its the code with Moodle I should think?


Wes

[Geoff]

Or your IMAP server is slow?

[wesleyw]

That's a possibility too!


Wes