Issue Details (XML | Word | Printable)

Key: MDL-12408
Type: Sub-task Sub-task
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Jerome Mouneyrac
Reporter: Gary Anderson
Votes: 1
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle
MDL-14825

download.moodle.org should give out an XAMPP with better settings for SQL

Created: 03/Dec/07 12:27 AM   Updated: 18/Jun/08 04:55 PM
Return to search
Component/s: Performance
Affects Version/s: 1.6, 1.7, 1.8, 1.9
Fix Version/s: None

File Attachments: 1. File my.cnf (5 kB)
2. Text File README.txt (2 kB)

Issue Links:
Relates
 

Participants: Gary Anderson, Jerome Mouneyrac, Martin Dougiamas and Matt Gibson
Security Level: None
Resolved date: 18/Jun/08
Affected Branches: MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE


 Description  « Hide
It seems like much of the reason the people complain about how slow a Windows server runs Moodle is because people are running the XAMPP distribution with Moddle that they download from download.moodle.org

The issue is that the sql settings are so low that they would only work OK for a single user. Even a development machine with 512MB of memory would be better off with more production type settings, and then people would be able to test their system with several classes of students (or use it in production until they get enough expertise to get something more sophosticated going.

I would recommend the following. Some might have better values, but these work for us in a 550 student laptop school.

skip-locking
key_buffer = 150M
max_allowed_packet = 1M
table_cache = 200
sort_buffer_size = 2M
read_buffer_size = 1M
read_rnd_buffer_size = 512K
net_buffer_length = 2K
thread_stack = 64K
query_cache_size = 150M

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Gary Anderson added a comment - 28/Jan/08 05:02 AM
Eloy:

Since I see you are updating the XAMPP for windows, may I assign this to you?

Feel free to just close it if you really want to keep the settings just for test development. But I think that even on Linux, many use XAMPP in production because of the ease of install.

With these settings that they will work with almost all development and first phase deployments, and would eliminate many of the speed complaints that people associate with Windows.

(Note that we have moved to Linux and like it better, but the XAMPP windows package got us going and through our first couple years with Moodle, and it probably would not have happened without the package).


Matt Gibson added a comment - 07/May/08 05:06 PM
Just remembered this issue - I think it would be great to have 2 sets of mysql settings, one for development and one for production, with one or the other commented initiall. Also some simple instructions to go with them, including a link to the performance page in the docs?

Martin Dougiamas added a comment - 12/May/08 01:52 PM
Jerome, something else for the new package probably.

Jerome Mouneyrac added a comment - 22/May/08 10:07 AM
Attached my.cnf on this issue. It needs to be added to MoodleWindowsInstaller/server/mysql/bin/

Jerome Mouneyrac added a comment - 22/May/08 10:15 AM
Attached the README.txt updated with a link to the performance docs.

Martin Dougiamas added a comment - 18/Jun/08 04:41 PM
README.txt updated and new my.cnf is now being added to the new downloads. You can update it in CVS as necessary.

http://cvs.moodle.org/contrib/tools/m4w_builder/config/