MYSQL OPTIMIZER SETTINGS INSTALL
MYSQL OPTIMIZER SETTINGS WINDOWS

The general advice is to set it to 4 x physical RAM. This will improve the overall speed of your system, especially when accessing Moodle's reports. Purchase hard disks with a low seek time.If you must have SATA drives, check that your motherboard and the drives themselves support NCQ (Native Command Queuing). SATA drives will increase your system's CPU utilization, whereas SCSI drives have their own integrated processors and come into their own when you have multiple drives. If you can afford them, use SCSI hard disks instead of SATA drives.A modern BIOS should allow you to enable hyperthreading, but check if this makes a difference to the overall performance of the processors by using a CPU benchmarking tool. Better performance is gained by obtaining the best processor capability you can, i.e.Increasing primary memory will reduce the need for processes to swap to disk and will enable your server to handle more users. Note: The fastest and most effective change that you can make to improve performance is to increase the amount of RAM on your web server - get as much as possible (e.g. Installation for 3000 simultaneous users.A good understanding of these areas of system administration should be considered a minimum requirement. It's important that your shared file areas are properly tuned and that you use an effective cache (Redis is highly recommended). On very large, load-balanced, systems the performance of the shared components become critical. a MySQL cluster), but this is not an easy task and you should seek expert support, e.g. Similarly, the database could be a cluster of servers (e.g. The separate webservers should query the same database and refer to the same filestore and cache areas (see Caching), but otherwise the separation of the application layers is complete enough to make this kind of clustering feasible.

It is possible to load-balance a Moodle installation, for example by using more than one webserver. Large sites usually separate the web server and database onto separate servers, although for smaller installations this is typically not necessary. (Please check the list of large Moodle installations.)

Moodle's design (with clear separation of application layers) allows for strongly scalable setups. See moodledev JMeter documentation Scalability

MYSQL OPTIMIZER SETTINGS INSTALL

It can be interesting to install and use the Benchmark plugin in order to find the bottlenecks of your system that specifically affect Moodle or do a load test / stress test with tool like JMeter. The optimization order preference is usually: primary storage (more RAM), secondary storage (faster hard disks/improved hard disk configuration), processor (more and faster). If your system starts swapping, this is a sign that you need more RAM. It is especially important to try to eliminate swap file usage as much as you can. The overall aim of adjustments to improve performance is to use RAM (cacheing) and to reduce disk-based activity. Once you have quantitative data about how your system is performing currently, you'll be able to determine if the change you have made has had any real impact.

MYSQL OPTIMIZER SETTINGS WINDOWS

For Linux try LBS (Note: Last updated May 2002) and for Windows use the Performance Monitor.

8 Performance of different Moodle modulesīefore attempting any optimization, you should obtain a baseline benchmark of the component of the system you are trying to improve.

5.5 Lighttpd, NginX and Cherokee performance.

Mysql optimizer settings