+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
Virtual Learning Platforms Thread, Moodle - Slow when more than a few users are logged in in Technical; Someone has suggested this is down to MySQL and it needs tweaking. Any ideas? We're running the following: PHP Version ...
  1. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

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

    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

  2. #2

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

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

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

  3. #3
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

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

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


    Wes

  4. #4

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

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

    Download mysqlreport and post the results of
    Code:
    mysqlreport --all

  5. #5
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

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

    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

  6. #6

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

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

    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.

  7. #7

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    29

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

    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.
    Attached Files Attached Files

  8. #8
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

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

    @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

  9. #9

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

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

    Code:
    set | grep PATH

  10. #10
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

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

    @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

  11. #11

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

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

    very odd, that should work.

  12. #12

    Join Date
    Apr 2007
    Location
    Sutton Coldfield
    Posts
    207
    Thank Post
    29
    Thanked 34 Times in 28 Posts
    Rep Power
    20

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

    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.

  13. #13
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

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

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


    Wes

  14. #14

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

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

    Or your IMAP server is slow?

  15. #15
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

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

    That's a possibility too!


    Wes

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. FAO: ELGG users and Moodle Users
    By thegrassisgreener in forum Virtual Learning Platforms
    Replies: 18
    Last Post: 3rd July 2009, 07:12 PM
  2. List of users logged on a workstation
    By sLiDeR in forum Windows
    Replies: 6
    Last Post: 4th December 2007, 12:40 PM
  3. Replies: 3
    Last Post: 23rd March 2007, 09:36 AM
  4. Managing Moodle Users
    By lindylou in forum Virtual Learning Platforms
    Replies: 9
    Last Post: 20th March 2007, 08:16 PM
  5. Change start page for logged on users
    By ajbritton in forum Comments and Suggestions
    Replies: 7
    Last Post: 12th April 2006, 08:48 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •