Performance recommendations - Revision history

Mudrd8mz: Port the Cron performance section from the 3.8 wiki

2020-06-02T15:58:11Z

Port the Cron performance section from the 3.8 wiki

← Older revision		Revision as of 15:58, 2 June 2020
Line 156:		Line 156:
	// );		// );
	</code>		</code>

			== Cron performance ==

			Cron is a very important part of the overall performance of moodle as many asynchronous processes are offloaded to cron, so it needs to be running and have enough through put to handle the work being given to it by the front ends.

			See [[Cron_with_Unix_or_Linux#High_performance_cron_tasks]]

	==Database performance==		==Database performance==

Germanvaleroelizondo: Added see also *[https://enovation.ie/moodle-performance-investigation-using-performance-info/ Moodle performance investigation – using performance info ]

2020-04-21T21:18:50Z

Added see also *[https://enovation.ie/moodle-performance-investigation-using-performance-info/ Moodle performance investigation – using performance info ]

← Older revision		Revision as of 21:18, 21 April 2020
Line 270:		Line 270:
	*[http://blog.bitnami.com/2014/06/performance-enhacements-for-apache-and.html Performance enhacements for Apache and PHP (Apache Event MPM and PHP-FPM)]		*[http://blog.bitnami.com/2014/06/performance-enhacements-for-apache-and.html Performance enhacements for Apache and PHP (Apache Event MPM and PHP-FPM)]
	*[https://scholarlms.net/performance-recommendations/ Performance recommendations]		*[https://scholarlms.net/performance-recommendations/ Performance recommendations]
			*[https://enovation.ie/moodle-performance-investigation-using-performance-info/ Moodle performance investigation – using performance info ]

	There have been a lot of discussions on moodle.org about performance, here are some of the more interesting and (potentially) useful ones:		There have been a lot of discussions on moodle.org about performance, here are some of the more interesting and (potentially) useful ones:

Chrisf: /* MySQL performance */

2020-03-14T04:10:46Z

MySQL performance

← Older revision		Revision as of 04:10, 14 March 2020
Line 160:		Line 160:

	===MySQL performance===		===MySQL performance===

			The '''number one thing''' you can do to improve MySQL performance is to read, understand and implement the recommendations in the [https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html Innodb Buffer Pool] article.

			The [https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html buffer pool size] can safely be changed while your server is running, as long as your server has enough memory (RAM) to accommodate the value you set. On a machine that is dedicated to MySQL, you can safely set this value to 80% of available memory.

			Consider setting [https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_buffer_pool_instances innodb_buffer_pool_instances] to the number of cores, vCPUs, or chips you have available. Adjust this value in accordance with the recommendations in the [https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html MySQL documentation].

	The following are MySQL specific settings which can be adjusted for better performance in your my.cnf (my.ini in Windows). The file contains a list of settings and their values. To see the current values use these commands		The following are MySQL specific settings which can be adjusted for better performance in your my.cnf (my.ini in Windows). The file contains a list of settings and their values. To see the current values use these commands

Mina: /* See also */ Update link to french doc

2020-02-23T22:41:22Z

Howardsmiller: /* PHP performance */

2019-09-30T08:10:31Z

PHP performance

← Older revision		Revision as of 08:10, 30 September 2019
Line 61:		Line 61:

	===PHP performance===		===PHP performance===
	* ~~You are strongly recommended to use~~ a ~~'''PHP accelerator''' to ease CPU load, such as [http://pecl.php.net/apc APC], [http://www.php~~-accelerator.co.uk/ PHPA], [http://trac.lighttpd.net/xcache/ Xcache], [http://sourceforge.net/projects/wincache WinCache] or [http://eaccelerator.net/ eAccelerator]. (Take care to choose a PHP accelerator that is known to work well with your version of PHP and note that Turck MMCache is ~~[http://turckmmcache~~.~~exeprod.com/TheManifestoEnglish no longer maintained] and can cause failures with PHP 5). PHP 5.5 (and newer) includes OpCache and is fully supported and recommended by Moodle~~		* PHP contains a built-in accelerator. Make sure it is enabled.
	* Improvements in read/write performance can be improved by putting the cached PHP pages on a [[TMPFS]] filesystem - but remember that you'll lose the cache contents when there is a power failure or the server is rebooted.		* Improvements in read/write performance can be improved by putting the cached PHP pages on a [[TMPFS]] filesystem - but remember that you'll lose the cache contents when there is a power failure or the server is rebooted.
	* Performance of PHP is better when installed as an '''Apache/IIS6 ISAPI module''' (rather than a CGI). IIS 7.0/7.5 (Windows Server 2008/R2) users should choose a FastCGI installation for best performance.		* Performance of PHP is better when installed as an '''Apache/IIS6 ISAPI module''' (rather than a CGI). IIS 7.0/7.5 (Windows Server 2008/R2) users should choose a FastCGI installation for best performance.
	* Also check the '''memory_limit''' in php.ini, reduce it to 16M for Moodle version earlier than 1.7 ([http://moodle.org/mod/forum/discuss.php?d=39656 See this forum discussion]). For Moodle 1.7 or later, it is recommended that the value of memory_limit should be 40M. As of [http://www.php.net/ChangeLog-5.php PHP 5.2.~~1] the~~ default value for the memory_limit directive is 128M.		* Also check the '''memory_limit''' in php.ini. The default value for the memory_limit directive is 128M. On some sites, it may need to be larger - especially for some backup operations.
	* Also see [[PHP_settings_by_Moodle_version]]		* Also see [[PHP_settings_by_Moodle_version]]
	* Use [http://blog.bitnami.com/2014/06/performance-enhacements-for-apache-and.html PHP-FPM] (with apache).		* Use [http://blog.bitnami.com/2014/06/performance-enhacements-for-apache-and.html PHP-FPM] (with apache).

Howardsmiller: /* Hardware configuration */

2019-09-30T08:08:28Z

Hardware configuration

← Older revision		Revision as of 08:08, 30 September 2019
Line 42:		Line 42:
	** the operating system and swap drive on one set of disks configured as RAID-1.		** the operating system and swap drive on one set of disks configured as RAID-1.
	** Moodle, Web server and Database server on another set of disks configured as RAID-5.		** Moodle, Web server and Database server on another set of disks configured as RAID-5.
	* If your 'moodledata' area is going to be on relatively slow storage (e.g. NFS mount on to a NAS device) you will ~~probably~~ have performance issues with the default cache configuration (which writes to this storage). See the page on [[Caching]] and ~~consider~~ an alternative. Using [https://en.wikipedia.org/wiki/GlusterFS GlusterFS] / [https://en.wikipedia.org/wiki/OCFS2 OCFS2] / [https://en.wikipedia.org/wiki/GFS2 GFS2] on a [https://en.wikipedia.org/wiki/Storage_Area_Network SAN] device and [https://en.wikipedia.org/wiki/Fibre_Channel Fiber Channel] could improve performance (See more info on the Moodle [https://moodle.org/mod/forum/discuss.php?d=214680#p1123124 forum thread], [https://moodle.org/mod/forum/discuss.php?d=310501#p1242382 NFS performance tuing] )		* If your 'moodledata' area is going to be on relatively slow storage (e.g. NFS mount on to a NAS device) you will have performance issues with the default cache configuration (which writes to this storage). See the page on [[Caching]] and choose an alternative. Redis is recommended. Using [https://en.wikipedia.org/wiki/GlusterFS GlusterFS] / [https://en.wikipedia.org/wiki/OCFS2 OCFS2] / [https://en.wikipedia.org/wiki/GFS2 GFS2] on a [https://en.wikipedia.org/wiki/Storage_Area_Network SAN] device and [https://en.wikipedia.org/wiki/Fibre_Channel Fiber Channel] could improve performance (See more info on the Moodle [https://moodle.org/mod/forum/discuss.php?d=214680#p1123124 forum thread], [https://moodle.org/mod/forum/discuss.php?d=310501#p1242382 NFS performance tuing] )
	* Use '''gigabit ethernet''' for improved latency and throughput. This is especially important when you have your webserver and database server separated out on different hosts.		* Use '''gigabit ethernet''' for improved latency and throughput. This is especially important when you have your webserver and database server separated out on different hosts.
	* Check the settings on your '''network card'''. You may get an improvement in performance by increasing the use of buffers and transmit/receive descriptors (balance this with processor and memory overheads) and off-loading TCP checksum calculation onto the card instead of the OS.		* Check the settings on your '''network card'''. You may get an improvement in performance by increasing the use of buffers and transmit/receive descriptors (balance this with processor and memory overheads) and off-loading TCP checksum calculation onto the card instead of the OS.

Howardsmiller: /* Scalability */

2019-09-30T08:07:09Z

Scalability

← Older revision		Revision as of 08:07, 30 September 2019
Line 20:		Line 20:

	It is possible to load-balance a Moodle installation, for example by using more than one webserver. 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. Similarly, the database could be a cluster of servers (e.g. a MySQL cluster), but this is not an easy task and you should seek expert support, e.g. from a Moodle Partner.		It is possible to load-balance a Moodle installation, for example by using more than one webserver. 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. Similarly, the database could be a cluster of servers (e.g. a MySQL cluster), but this is not an easy task and you should seek expert support, e.g. from a Moodle Partner.

			On very large, load-balanced, systems the performance of the shared components become critical. It's important that your shared file areas are properly tuned and that you use an effective cache (Redis is highly recommended). A good understanding of these areas of system administration should be considered a minimum requirement.

	===Server cluster===		===Server cluster===

Nadavkav: /* MemCached */

2019-08-10T08:28:42Z

MemCached

← Older revision		Revision as of 08:28, 10 August 2019
Line 77:		Line 77:
	* [https://www.tecmint.com/install-memcached-on-centos-7/ Installing Memcached on CentOS 7.x (linux)] (as of php 7.x, only memcached is available)		* [https://www.tecmint.com/install-memcached-on-centos-7/ Installing Memcached on CentOS 7.x (linux)] (as of php 7.x, only memcached is available)
	* [https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-memcached-on-centos-7 How To Install and Secure Memcached on CentOS 7]		* [https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-memcached-on-centos-7 How To Install and Secure Memcached on CentOS 7]
			* [https://wiki.zimbra.com/wiki/Blocking_Memcached_Attack#Iptables_rules_for_Redhat_based_servers Iptables rules for Redhat based servers]
	Memcached PHP 7.1 extension		Memcached PHP 7.1 extension
	* [https://dl.iuscommunity.org/pub/ius/stable/CentOS/7/x86_64/repoview/php71u-pecl-memcached.html php71u-pecl-memcached] from IUS CentOS 7.x repository.		* [https://dl.iuscommunity.org/pub/ius/stable/CentOS/7/x86_64/repoview/php71u-pecl-memcached.html php71u-pecl-memcached] from IUS CentOS 7.x repository.

Nadavkav: /* Install HowTo */

2019-08-10T08:14:24Z

Install HowTo

← Older revision		Revision as of 08:14, 10 August 2019
Line 67:		Line 67:

	===Install HowTo===		===Install HowTo===
			==== APC ====
	* [http://2bits.com/articles/installing-php-apc-gnulinux-centos-5.html APC on CentOS 5.x (linux)]		* [http://2bits.com/articles/installing-php-apc-gnulinux-centos-5.html APC on CentOS 5.x (linux)]
	* [http://fplanque.com/dev/linux/install-apc-php-cache-debian-lenny APC on Debian (linux)]		* [http://fplanque.com/dev/linux/install-apc-php-cache-debian-lenny APC on Debian (linux)]
	* [http://~~www~~.~~linuxtuts~~.~~net~~/~~211-~~installing-~~memcached-php5~~-~~memcache~~-~~module~~-~~debian-apache2~~.html ~~MemCache module~~ on ~~Debian~~ (~~Apache2 and PHP5~~) ]		==== eAccelerator ====
			* [http://noveckg.blogspot.com/2010/02/installing-eaccelerator-cache-for-php.html Installing eAccelerator on CentOS 5.x (linux)]
			* [https://docs.moodle.org/en/Installing_eAccelerator_In_Ubuntu_Server/ Installing eAccelerator on Ubuntu Server (linux)]
			==== MemCached ====
			Memcached server (daemon)
	* [https://www.tecmint.com/install-memcached-on-centos-7/ Installing Memcached on CentOS 7.x (linux)] (as of php 7.x, only memcached is available)		* [https://www.tecmint.com/install-memcached-on-centos-7/ Installing Memcached on CentOS 7.x (linux)] (as of php 7.x, only memcached is available)
	* [https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-memcached-on-centos-7 How To Install and Secure Memcached on CentOS 7]		* [https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-memcached-on-centos-7 How To Install and Secure Memcached on CentOS 7]
	* [~~http~~://~~noveckg~~.~~blogspot~~.~~com~~/~~2010~~/02/~~installing~~-~~eaccelerator~~-~~cache~~-~~for~~-~~php.html Installing eAccelerator on~~ CentOS 5.x ~~(linux)]~~		Memcached PHP 7.1 extension
	* [https://docs.moodle.~~org/en/Installing_eAccelerator_In_Ubuntu_Server/ Installing eAccelerator on Ubuntu Server (linux)]~~		* [https://dl.iuscommunity.org/pub/ius/stable/CentOS/7/x86_64/repoview/php71u-pecl-memcached.html php71u-pecl-memcached] from IUS CentOS 7.x repository.

	===Apache performance===		===Apache performance===

Nadavkav: /* Install HowTo */

2019-08-10T07:54:54Z

Install HowTo

← Older revision		Revision as of 07:54, 10 August 2019
Line 71:		Line 71:
	* [http://www.linuxtuts.net/211-installing-memcached-php5-memcache-module-debian-apache2.html MemCache module on Debian (Apache2 and PHP5) ]		* [http://www.linuxtuts.net/211-installing-memcached-php5-memcache-module-debian-apache2.html MemCache module on Debian (Apache2 and PHP5) ]
	* [https://www.tecmint.com/install-memcached-on-centos-7/ Installing Memcached on CentOS 7.x (linux)] (as of php 7.x, only memcached is available)		* [https://www.tecmint.com/install-memcached-on-centos-7/ Installing Memcached on CentOS 7.x (linux)] (as of php 7.x, only memcached is available)
			* [https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-memcached-on-centos-7 How To Install and Secure Memcached on CentOS 7]
	* [http://noveckg.blogspot.com/2010/02/installing-eaccelerator-cache-for-php.html Installing eAccelerator on CentOS 5.x (linux)]		* [http://noveckg.blogspot.com/2010/02/installing-eaccelerator-cache-for-php.html Installing eAccelerator on CentOS 5.x (linux)]
	* [https://docs.moodle.org/en/Installing_eAccelerator_In_Ubuntu_Server/ Installing eAccelerator on Ubuntu Server (linux)]		* [https://docs.moodle.org/en/Installing_eAccelerator_In_Ubuntu_Server/ Installing eAccelerator on Ubuntu Server (linux)]

← Older revision		Revision as of 22:41, 23 February 2020
Line 277:		Line 277:

	[[es:Recomendaciones sobre desempeño]]		[[es:Recomendaciones sobre desempeño]]
	[[fr:~~Performance~~]]		[[fr:Recommandations_de_performance]]
	[[ja:パフォーマンス]]		[[ja:パフォーマンス]]
	[[de:Geschwindigkeitsempfehlungen]]		[[de:Geschwindigkeitsempfehlungen]]