https://docs.moodle.org/22/en/api.php?action=feedcontributions&user=Jtomkinson&feedformat=atomMoodleDocs - User contributions [en]2024-03-29T14:38:07ZUser contributionsMediaWiki 1.39.6https://docs.moodle.org/22/en/index.php?title=Main_page&diff=93507Main page2011-11-08T08:19:36Z<p>Jtomkinson: </p>
<hr />
<div><div class="frontpagetotal"><p class="note">Welcome to the Moodle 2.1 documentation!</p><br />
<div class="frontpageblock"><br />
<h2>[[About Moodle]]</h2><br />
*[[Philosophy]]<br />
*[[Pedagogy]]<br />
*[[Moodle site - basic structure]]<br />
*[[Moodle key terms]]<br />
*[[About Moodle FAQ]]<br />
<br />
<br />
<br />
<h2>[[Installing Moodle]]</h2><br />
*[[Upgrading]]<br />
*[[Installing plugins]]<br />
*[[Installation FAQ]]<br />
</div><br />
<div class="frontpageblock"><br />
<h2>[[Managing a Moodle site]]</h2><br />
*[[Authentication]]<br />
*[[Managing accounts]]<br />
*[[Enrolments]]<br />
*[[Roles and permissions]]<br />
*[[Security]]<br />
*[[Performance]]<br />
*[[Backup]]<br />
*[[Site appearance]]<br />
*[[Language]]<br />
*[[Server settings]]<br />
*[[Site-wide reports]]<br />
*[[Developer tools]]<br />
*[[Web services]]<br />
*[[Community hubs]]<br />
*[[More features]]<br />
</div><br />
<div class="frontpageblock"><br />
<h2>[[Managing a Moodle course]]</h2><br />
* [[Courses]]<br />
* [[Editing text]]<br />
* [[Activities]]<br />
* [[Resources]]<br />
* [[Blocks]]<br />
* [[Questions]]<br />
* [[Course enrolment]]<br />
* [[Grouping users]]<br />
* [[Tracking progress]]<br />
* [[Reusing activities]]<br />
</div><br />
<div class="frontpageblock"><br />
<h2>[[Managing content]]</h2><br />
* [[Working with files]]<br />
* [[Repositories]]<br />
* [[Portfolios]]<br />
* [[Working with media]]<br />
* [[Filters]]<br />
* [[Licences]]<br />
* [[Plagiarism prevention]]<br />
</div><br />
</div><br />
__NOTOC__<br />
<br />
See the full [[Table of Contents]] for more detail.<br />
<br />
For help with Moodle documentation features see [[Help:Contents]].</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Coding&diff=88057Coding2011-08-19T05:30:52Z<p>Jtomkinson: Redirected page to dev:Coding</p>
<hr />
<div>#redirect [[:dev:Coding]]</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Adminer&diff=81288Adminer2011-02-14T02:38:32Z<p>Jtomkinson: /* Install phpMyAdmin in Moodle 2.0 or later */</p>
<hr />
<div>'''phpMyAdmin''' is a useful MySQL database administration tool (if you are using MySQL as the database for your Moodle). When installed as part of Moodle, it becomes part of the Moodle interface. It can be found in the site administration block>Server>database link. <br />
<br />
This is a powerful program that should be used with care and be available only to trusted administrators. <br />
<br />
==Install phpMyAdmin in Moodle 1.9.x or earlier==<br />
To install phpMyAdmin so it is directly available via Moodle, unzip the archive from [http://moodle.org/mod/data/view.php?d=13&rid=448 Modules and plugins database] inside the ''moodle/admin/'' folder. You should end up with a folder there called 'mysql' which contains all the necessary files. Now go to your site admin block and you will see a new link: ''Server > Database''. Use this link to initially install and/or open phpMyAdmin.<br />
<br />
For those that need phpMyAdmin to perform a Moodle install, unpack it in the documents directory (the same directory as your moodle folder, sometimes found in the folder htdocs) of your web server. Note: many web hosting sites have phpMyAdmin already available via their control panel, you can use that to assist with the Moodle install. <br />
<br />
For more advanced users: To obtain the most recent version from CVS, go to the ''moodle/admin/'' folder and run<br />
<br />
cvs -z3 -d:ext:myusername@cvs.moodle.org:/cvsroot/moodle co mysql<br />
<br />
==Install phpMyAdmin in Moodle 2.0 or later==<br />
<br />
<br />
To install phpMyAdmin so it is directly available via Moodle, unzip the archive from [http://moodle.org/mod/data/view.php?d=13&rid=448 Modules and plugins database] inside the ''moodle/local/'' folder. You should end up with a folder there called 'phpmyadmin' which contains all the necessary files. Now go to your site admin block and you will see a new link: ''Server > Database''. Use this link to initially install and/or open phpMyAdmin.<br />
<br />
For those that need phpMyAdmin to perform a Moodle install, unpack it in the documents directory (the same directory as your moodle folder, sometimes found in the folder htdocs) of your web server. Note: many web hosting sites have phpMyAdmin already available via their control panel, you can use that to assist with the Moodle install. <br />
<br />
For more advanced users: To obtain the most recent version from git, go to the ''moodle/local/'' folder and run<br />
<br />
git clone git://github.com/moodlehq/moodle-local_phpmyadmin.git phpmyadmin<br />
<br />
==See also==<br />
<br />
*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=56636 Remove database access] forum discussion<br />
<br />
[[Category:Administrator]][[Category:SQL databases]]</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Moodle.org_configuration&diff=65027Moodle.org configuration2009-11-09T03:11:40Z<p>Jtomkinson: </p>
<hr />
<div>This page describes the hardware and software configurations for the moodle.org family of sites.<br />
<br />
==moodle.org==<br />
<br />
This site runs the main Moodle site. As of 8th March 2009 moodle.org is running on two machines '''directly linked by a 1Gb VLAN'''. You can see some [[Performance_testing_moodle.org|test results]] of this configuration, which we feel can comfortably support at least 500 normally active concurrent users.<br />
<br />
===moodle.org web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
This machine runs Apache and PHP with an eaccelerator cache of 256M. Moodle is also configured to use eaccelerator shared memory as well as 15-second record caching. MySQL is accessed using the mysqli module.<br />
<br />
===moodle.org database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
This machine runs MySQL 5.1.38 with InnoDB tables only. The disks have battery-backed RAID so we enabled direct writes for additional speed.<br />
<br />
Some key innodb settings (subject to change of course):<br />
innodb_buffer_pool_size = 4G<br />
innodb_file_io_threads = 4<br />
innodb_thread_concurrency = 16<br />
innodb_flush_log_at_trx_commit = 2<br />
innodb_log_buffer_size = 4M<br />
innodb_log_file_size = 256M<br />
innodb_flush_method=O_DIRECT<br />
<br />
==docs.moodle.org==<br />
<br />
This site runs twenty or so MediaWiki sites that make up Moodle Docs in all different languages.<br />
<br />
* 2 x Dual core Intel Xeon - 4 cores at 2.4 Ghz each <br />
* 2 x 80Gb SATA drives in RAID 1<br />
* 2Gb RAM<br />
<br />
<br />
<br />
==tracker.moodle.org==<br />
<br />
This site runs the tracker software Jira, which is a Java application.<br />
<br />
* Intel Xeon Quare Core - 4 cores at 2.8 Ghz each<br />
* 2 x 250Gb SATA drives in RAID 1<br />
* 6Gb RAM<br />
<br />
==See also==<br />
* [[Performance]] - describes things to think about for maximum performance<br />
<br />
[[Category:Moodle.org]]</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=File:server10-slowtest-innodb.png&diff=51973File:server10-slowtest-innodb.png2009-03-04T05:49:15Z<p>Jtomkinson: uploaded a new version of "Image:server10-slowtest-innodb.png"</p>
<hr />
<div></div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51972Performance testing moodle.org2009-03-04T05:29:51Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || [[Image:server10-slowtest-innodb.png]] ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| <br />
* 2083000 function calls<br />
* 14500 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 2790 get_record calls on the course table<br />
* 2010 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
* 2063000 function calls<br />
* 14500 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 2790 get_record calls on the course table<br />
* 2090 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
||<br />
* 2071000 function calls<br />
* 13700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 9200 16KB files written to disk (cache)<br />
* 1610 get_record calls on the course table<br />
* 940 insert_record calls on the course table<br />
* 190 update_record calls on the course table<br />
<br />
* 2092000 function calls<br />
* 13700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9200 16KB files written to disk (cache)<br />
* 1610 get_record calls on the course table<br />
* 940 insert_record calls on the course table<br />
* 190 update_record calls on the course table<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| <br />
* 2098000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8900 16KB files written to disk (cache)<br />
* 23170 get_record calls on the course table<br />
* 2030 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
* 2132000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 23270 get_record calls on the course table<br />
* 2040 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
||<br />
* 2112000 function calls<br />
* 14500 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 22760 get_record calls on the course table<br />
* 910 insert_record calls on the course table<br />
* 190 update_record calls on the course table<br />
<br />
* 2115000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 23360 get_record calls on the course table<br />
* 930 insert_record calls on the course table<br />
* 190 update_record calls on the course table<br />
|-<br />
| LoginView 300 (Jmeter with 300 users, 30 seconds ramp, 90% Line|| <br />
NA<br />
|| <br />
NA<br />
||<br />
* 28.1 s / 29.5 s<br />
* 0% error<br />
||<br />
* 27 s / 31.9 s<br />
* 0% error<br />
<br />
|-<br />
| LoginPost 300 (Jmeter with 300 users, 30 seconds ramp, 90% Line) || <br />
NA<br />
|| <br />
* 21.5 s <br />
* 0.11% error<br />
||<br />
* 20.4 s / 27.1 s<br />
* 0% error<br />
||<br />
* 30.6 s / 27.7 s (decreasing with each run)<br />
* 0% error<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51971Performance testing moodle.org2009-03-04T05:26:58Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || [[Image:server10-slowtest-innodb.png]] ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| <br />
* 2083000 function calls<br />
* 14500 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 2790 get_record calls on the course table<br />
* 2010 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
* 2063000 function calls<br />
* 14500 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 2790 get_record calls on the course table<br />
* 2090 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| <br />
* 2098000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8900 16KB files written to disk (cache)<br />
* 23170 get_record calls on the course table<br />
* 2030 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
* 2132000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 23270 get_record calls on the course table<br />
* 2040 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
||<br />
* 2112000 function calls<br />
* 14500 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 22760 get_record calls on the course table<br />
* 910 insert_record calls on the course table<br />
* 190 update_record calls on the course table<br />
<br />
* 2115000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 23360 get_record calls on the course table<br />
* 930 insert_record calls on the course table<br />
* 190 update_record calls on the course table<br />
|-<br />
| LoginView 300 (Jmeter with 300 users, 30 seconds ramp, 90% Line|| <br />
NA<br />
|| <br />
NA<br />
||<br />
* 28.1 s / 29.5 s<br />
* 0% error<br />
||<br />
* 27 s / 31.9 s<br />
* 0% error<br />
<br />
|-<br />
| LoginPost 300 (Jmeter with 300 users, 30 seconds ramp, 90% Line) || <br />
NA<br />
|| <br />
* 21.5 s <br />
* 0.11% error<br />
||<br />
* 20.4 s / 27.1 s<br />
* 0% error<br />
||<br />
* 30.6 s / 27.7 s (decreasing with each run)<br />
* 0% error<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=File:server10-slowtest-innodb.png&diff=51970File:server10-slowtest-innodb.png2009-03-04T05:22:28Z<p>Jtomkinson: </p>
<hr />
<div></div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51969Performance testing moodle.org2009-03-04T05:21:59Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || [[Image:server10-slowtest-innodb.png]] ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| <br />
* 2083000 function calls<br />
* 14500 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 2790 get_record calls on the course table<br />
* 2010 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
* 2063000 function calls<br />
* 14500 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 9100 16KB files written to disk (cache)<br />
* 2790 get_record calls on the course table<br />
* 2090 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| <br />
* 2098000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8900 16KB files written to disk (cache)<br />
* 23170 get_record calls on the course table<br />
* 2030 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
* 2132000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 23270 get_record calls on the course table<br />
* 2040 insert_record calls on the course table<br />
* 330 update_record calls on the course table<br />
<br />
||<br />
|-<br />
| LoginView 300 (Jmeter with 300 users, 30 seconds ramp, 90% Line|| <br />
NA<br />
|| <br />
NA<br />
||<br />
* 28.1 s / 29.5 s<br />
* 0% error<br />
||<br />
* 27 s / 31.9 s<br />
* 0% error<br />
<br />
|-<br />
| LoginPost 300 (Jmeter with 300 users, 30 seconds ramp, 90% Line) || <br />
NA<br />
|| <br />
* 21.5 s <br />
* 0.11% error<br />
||<br />
* 20.4 s / 27.1 s<br />
* 0% error<br />
||<br />
* 30.6 s / 27.7 s (decreasing with each run)<br />
* 0% error<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51964Performance testing moodle.org2009-03-04T04:26:34Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginView 300 || colspan="4" align="center" |[[Image:Loginview300.png]]<br />
|-<br />
| LoginPost 300 || colspan="4" align="center" |[[Image:Loginpost300.png]]<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51957Performance testing moodle.org2009-03-04T02:47:02Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginView 300 || colspan="4" |[[Image:Loginview300.png]]<br />
|-<br />
| LoginPost 300 || colspan="4" |[[Image:Loginpost300.png]]<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51956Performance testing moodle.org2009-03-04T02:46:37Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || colspan="4" |[[Image:Loginview300.png]]<br />
|-<br />
| LoginPost 300 || colspan="4" |[[Image:Loginpost300.png]]<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51955Performance testing moodle.org2009-03-04T02:46:23Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || colspan="4" |[[Image:Loginview300.png]]<br />
|-<br />
| LoginPost 300 || colspan="4" |[[Image::Loginpost300.png]]<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=File:Loginview300.png&diff=51954File:Loginview300.png2009-03-04T02:45:13Z<p>Jtomkinson: </p>
<hr />
<div></div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=File:Loginpost300.png&diff=51953File:Loginpost300.png2009-03-04T02:44:54Z<p>Jtomkinson: </p>
<hr />
<div></div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51952Performance testing moodle.org2009-03-04T02:44:40Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || colspan="4" |<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51948Performance testing moodle.org2009-03-04T02:35:23Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || colspan="6" | test<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51947Performance testing moodle.org2009-03-04T02:34:55Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || colspan="6" | test ||<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51946Performance testing moodle.org2009-03-04T02:34:26Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || colspan="4" | test || || ||<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51945Performance testing moodle.org2009-03-04T02:33:49Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 ||colspan="4" || test || ||<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51944Performance testing moodle.org2009-03-04T02:30:23Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 ||colspan="4" || test<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51943Performance testing moodle.org2009-03-04T02:20:47Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || colspan="4" || test<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51942Performance testing moodle.org2009-03-04T02:20:33Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 | colspan="4" | test<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51941Performance testing moodle.org2009-03-04T02:20:05Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || colspan="4" test<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51939Performance testing moodle.org2009-03-04T02:19:04Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || ||<br />
|-<br />
| perspective (all caching off) || <br />
* 1402000 function calls<br />
* 11500 16KB files read from disk (cache)<br />
* 7900 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 4880 get_record calls on the course table<br />
* 1030 insert_record calls on the course table<br />
* 240 update_record calls on the course table<br />
<br />
* 1293000 function calls<br />
* 11400 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 6000 16KB files written to disk (cache)<br />
* 5530 get_record calls on the course table<br />
* 1590 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 2057000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8500 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2045000 function calls<br />
* 14800 16KB files read from disk (cache)<br />
* 16200 regular expression replaces over 1KB of text<br />
* 8700 16KB files written to disk (cache)<br />
* 2730 get_record calls on the course table<br />
* 1960 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| perspective (all caching on) || <br />
* 1403000 function calls<br />
* 10000 16KB files read from disk (cache)<br />
* 8300 regular expression replaces over 1KB of text<br />
* 5200 16KB files written to disk (cache)<br />
* 5270 get_record calls on the course table<br />
* 1390 insert_record calls on the course table<br />
* 220 update_record calls on the course table<br />
<br />
* 1382000 function calls<br />
* 11000 16KB files read from disk (cache)<br />
* 8200 regular expression replaces over 1KB of text<br />
* 5800 16KB files written to disk (cache)<br />
* 5640 get_record calls on the course table<br />
* 2140 insert_record calls on the course table<br />
* 250 update_record calls on the course table<br />
<br />
||<br />
* 1997000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16100 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19620 get_record calls on the course table<br />
* 2290 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
<br />
* 2003000 function calls<br />
* 14700 16KB files read from disk (cache)<br />
* 16000 regular expression replaces over 1KB of text<br />
* 8800 16KB files written to disk (cache)<br />
* 19560 get_record calls on the course table<br />
* 1830 insert_record calls on the course table<br />
* 340 update_record calls on the course table<br />
|| ||<br />
|-<br />
| LoginRead 300 || test<br />
|-<br />
| LoginPost 300 || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51130Performance testing moodle.org2009-02-18T01:41:10Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! colspan="3" | Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! innodb !! postgres !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || || || [[Image:server10-slowtest1.png]] || ||<br />
|-<br />
| slowqueries 100 || || || || || ||<br />
|-<br />
| perspective || [[Image:server7-perspective.png]] || || || || ||<br />
|-<br />
| loginpost 1 || || || || || ||<br />
|-<br />
| loginpost 100 || || || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=File:server10-slowtest1.png&diff=51129File:server10-slowtest1.png2009-02-18T01:40:27Z<p>Jtomkinson: </p>
<hr />
<div></div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51128Performance testing moodle.org2009-02-18T01:40:08Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! colspan="3" | Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! innodb !! postgres !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || || [[Image:server10-slowtest1.png]] || || ||<br />
|-<br />
| slowqueries 100 || || || || || ||<br />
|-<br />
| perspective || [[Image:server7-perspective.png]] || || || || ||<br />
|-<br />
| loginpost 1 || || || || || ||<br />
|-<br />
| loginpost 100 || || || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51046Performance testing moodle.org2009-02-17T07:05:05Z<p>Jtomkinson: /* Database server */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! colspan="3" | Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! innodb !! postgres !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || || || || ||<br />
|-<br />
| slowqueries 100 || || || || || ||<br />
|-<br />
| perspective || [[Image:server7-perspective.png]] || || || || ||<br />
|-<br />
| loginpost 1 || || || || || ||<br />
|-<br />
| loginpost 100 || || || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51045Performance testing moodle.org2009-02-17T06:58:27Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon 5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! colspan="3" | Old Server !! colspan="3" | New Servers <br />
|-<br />
! Test !! myisam !! innodb !! postgres !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || || || || ||<br />
|-<br />
| slowqueries 100 || || || || || ||<br />
|-<br />
| perspective || [[Image:server7-perspective.png]] || || || || ||<br />
|-<br />
| loginpost 1 || || || || || ||<br />
|-<br />
| loginpost 100 || || || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=File:server7-perspective.png&diff=51044File:server7-perspective.png2009-02-17T06:56:10Z<p>Jtomkinson: uploaded a new version of "Image:server7-perspective.png"</p>
<hr />
<div></div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=File:server7-perspective.png&diff=51043File:server7-perspective.png2009-02-17T06:52:09Z<p>Jtomkinson: </p>
<hr />
<div></div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51042Performance testing moodle.org2009-02-17T06:51:54Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon 5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! colspan="3" | Old Server !! colspan="3" | New Server <br />
|-<br />
! Test !! myisam !! innodb !! postgres !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || || || || ||<br />
|-<br />
| slowqueries 100 || || || || || ||<br />
|-<br />
| perspective || [[Image:server7-perspective.png]] || || || || ||<br />
|-<br />
| loginpost 1 || || || || || ||<br />
|-<br />
| loginpost 100 || || || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51041Performance testing moodle.org2009-02-17T06:51:30Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon 5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! colspan="3" | Old Server !! colspan="3" | New Server <br />
|-<br />
! Test !! myisam !! innodb !! postgres !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || || || || ||<br />
|-<br />
| slowqueries 100 || || || || || ||<br />
|-<br />
| perspective || [[Image:http://moodle.org/server7-perspective.png]] || || || || ||<br />
|-<br />
| loginpost 1 || || || || || ||<br />
|-<br />
| loginpost 100 || || || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51040Performance testing moodle.org2009-02-17T06:26:19Z<p>Jtomkinson: /* Server tests */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon 5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
! !! colspan="3" | Old Server !! colspan="3" | New Server <br />
|-<br />
! Test !! myisam !! innodb !! postgres !! myisam !! innodb !! postgres<br />
|-<br />
| slowqueries 1 || || || || || ||<br />
|-<br />
| slowqueries 100 || || || || || ||<br />
|-<br />
| perspective || || || || || ||<br />
|-<br />
| loginpost 1 || || || || || ||<br />
|-<br />
| loginpost 100 || || || || || ||<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51039Performance testing moodle.org2009-02-17T06:16:13Z<p>Jtomkinson: /* Web server */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon 5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
!Test<br />
!myisam<br />
!innodb<br />
!postgres<br />
|-<br />
|slowqueries 1<br />
|<br />
|<br />
|-<br />
|slowqueries 100<br />
|<br />
|<br />
|<br />
|-<br />
|perspective<br />
|<br />
|<br />
|<br />
|-<br />
|loginpost 1<br />
|<br />
|<br />
|<br />
|-<br />
|loginpost 100<br />
|<br />
|<br />
|<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51038Performance testing moodle.org2009-02-17T06:15:58Z<p>Jtomkinson: /* Database server */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* 1 x Quad Core Intel Xeon 5405 - 4 cores @ 2Ghz each<br />
* 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller<br />
* 8Gb Registered ECC RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
!Test<br />
!myisam<br />
!innodb<br />
!postgres<br />
|-<br />
|slowqueries 1<br />
|<br />
|<br />
|-<br />
|slowqueries 100<br />
|<br />
|<br />
|<br />
|-<br />
|perspective<br />
|<br />
|<br />
|<br />
|-<br />
|loginpost 1<br />
|<br />
|<br />
|<br />
|-<br />
|loginpost 100<br />
|<br />
|<br />
|<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Performance_testing_moodle.org&diff=51037Performance testing moodle.org2009-02-17T06:13:12Z<p>Jtomkinson: /* Web server */</p>
<hr />
<div>==Moodle.org hardware==<br />
<br />
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:<br />
<br />
===Web server===<br />
* 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each<br />
* 2 x 146GB 15k RPM SAS drives in RAID 1<br />
* 8Gb Registered ECC RAM<br />
<br />
===Database server===<br />
* Intel Xeon 5405 - 8 cores<br />
* RAID 5 disks<br />
* 8Gb RAM<br />
<br />
==Server tests==<br />
<br />
{| class="nicetable"<br />
!Test<br />
!myisam<br />
!innodb<br />
!postgres<br />
|-<br />
|slowqueries 1<br />
|<br />
|<br />
|-<br />
|slowqueries 100<br />
|<br />
|<br />
|<br />
|-<br />
|perspective<br />
|<br />
|<br />
|<br />
|-<br />
|loginpost 1<br />
|<br />
|<br />
|<br />
|-<br />
|loginpost 100<br />
|<br />
|<br />
|<br />
|}</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Hacking_the_Moodle_2.0_database_transfer_script_to_convert_a_Moodle_1.9_site&diff=51035Hacking the Moodle 2.0 database transfer script to convert a Moodle 1.9 site2009-02-17T04:59:10Z<p>Jtomkinson: /* Step 4: Replace all the database definition files in 2.0 with their 1.9 equivalents */</p>
<hr />
<div>Moodle 2.0 has a database transfer script that will copy the whole of your Moodle database to another server, even doing conversions like MySQL to PostgreSQL.<br />
<br />
Very nice, but what if you want to convert a Moodle 1.9 database without upgrading?<br />
<br />
The following instructions tell you how. Warning, this is a very quick and dirty hack, no guarantees. Make sure you have a backup of everything first. Even better, take a copy of your real system, and do the transfer on the copy. However, it worked for us.<br />
<br />
==Starting point==<br />
<br />
Let us suppose you have a working Moodle 1.9 install as follows (vary the instructions as necessary for your particular setup):<br />
* Code in /var/www/moodle19, accessible as http://example.com/moodle19/<br />
* moodledata in /var/moodledata.<br />
* some database, as set up in /var/www/moodle19/config.php.<br />
<br />
==Step 1: Get the Moodle 2.0 code==<br />
<br />
* Download a copy of the Moodle 2.0 code to somewhere, say /var/www/moodle20.<br />
* Make a new moodledata for this, say: /var/moodledata20.<br />
* copy /var/www/moodle19/config.php to /var/www/moodle20/config.php<br />
* edit /var/www/moodle20/config.php to make wwwroot, dirroot and dataroot point at the new locations.<br />
<br />
At this point it is essential that you '''do not''' go to http://example.com/moodle20/ and let your Moodle upgrade itself.<br />
<br />
==Step 2: Hack the code to skip the login step==<br />
<br />
* Open /var/www/moodle20/admin/dbtransfer/index.php in your editor.<br />
* Comment out the lines<br />
require_login();<br />
admin_externalpage_setup('dbtransfer');<br />
* There are 4 lines that call functions called<br />
admin_externalpage_print_header();<br />
admin_externalpage_print_footer();<br />
: Change these to call plain print_header/footer() instead.<br />
* Save index.php.<br />
* Open /var/www/moodle20/lib/sessionlib.php in your editor.<br />
* Find the function confirm_sesskey();<br />
* Add a line at the start of this function:<br />
return true;<br />
* Save sessionlib.php.<br />
<br />
==Step 3: Create the new database you want to copy to==<br />
<br />
As if you were about to install Moodle. You need an empty database, and a 'moodle' user that can connect to it with full control.<br />
<br />
==Step 4: Replace all the database definition files in 2.0 with their 1.9 equivalents==<br />
<br />
What we need to do is delete all of the install.xml files that belong to Moodle 2.0, wherever they are inside the moodle20 directory, and instead copy in all the ones belonging to Moodle 1.9. This is best done with the following command-line magic:<br />
<br />
cd /var/www/moodle20<br />
find . -iname 'install.xml' -exec rm -f {} \;<br />
mkdir -p mod/workshop/db mod/lams/db mod/journal/db mod/excercise/db<br />
cd /var/www/moodle19<br />
find . -iname 'install.xml' -exec cp {} ../moodle20/{} \;<br />
<br />
Now there is a tricky issue to sort out. Moodle 1.9 had a blocks/db/install.xml and backup/db/install.xml file, which does not exist in Moodle 2.0, and will not be found, even if you copy the file the the corresponding place in Moodle 2.0. Therefore, we cheat, and copy that install.xml file somewhere where it will be found.<br />
<br />
cd /var/www/moodle20/mod<br />
mkdir -p blocks/db backup/db<br />
cp /var/www/moodle19/blocks/db/install.xml blocks/db/<br />
cp /var/www/moodle19/backup/db/install.xml backup/db/<br />
<br />
==Step 5: Do the copy==<br />
<br />
* Go directly to the URL http://example.com/moodle20/admin/dbtransfer/index.php in your web browser.<br />
* Fill in the details of the database you want to copy to.<br />
* Click 'Transfer data' button.<br />
* Wait patiently, and keep your fingers crossed.<br />
<br />
Hopefully, that works. Good luck!</div>Jtomkinsonhttps://docs.moodle.org/22/en/index.php?title=Hacking_the_Moodle_2.0_database_transfer_script_to_convert_a_Moodle_1.9_site&diff=50755Hacking the Moodle 2.0 database transfer script to convert a Moodle 1.9 site2009-02-13T01:38:32Z<p>Jtomkinson: /* Step 2: Hack the code to skip the login step */</p>
<hr />
<div>Moodle 2.0 has a database transfer script that will copy the whole of your Moodle database to another server, even doing conversions like MySQL to PostgreSQL.<br />
<br />
Very nice, but what if you want to convert a Moodle 1.9 database without upgrading?<br />
<br />
The following instructions tell you how. Warning, this is a very quick and dirty hack, no guarantees. Make sure you have a backup of everything first. Even better, take a copy of your real system, and do the transfer on the copy. However, it worked for us.<br />
<br />
==Starting point==<br />
<br />
Let us suppose you have a working Moodle 1.9 install as follows (vary the instructions as necessary for your particular setup):<br />
* Code in /var/www/moodle19, accessible as http://example.com/moodle19/<br />
* moodledata in /var/moodledata.<br />
* some database, as set up in /var/www/moodle19/config.php.<br />
<br />
==Step 1: Get the Moodle 2.0 code==<br />
<br />
* Download a copy of the Moodle 2.0 code to somewhere, say /var/www/moodle20.<br />
* Make a new moodledata for this, say: /var/moodledata20.<br />
* copy /var/www/moodle19/config.php to /var/www/moodle20/config.php<br />
* edit /var/www/moodle20/config.php to make wwwroot, dirroot and dataroot point at the new locations.<br />
<br />
At this point it is essential that you '''do not''' go to http://example.com/moodle20/ and let your Moodle upgrade itself.<br />
<br />
==Step 2: Hack the code to skip the login step==<br />
<br />
* Open /var/www/moodle20/admin/dbtransfer/index.php in your editor.<br />
* Comment out the lines<br />
require_login();<br />
admin_externalpage_setup('dbtransfer');<br />
* There are 4 lines that call functions called admin_externalpage_print_header/footer(); Change these to call plain print_header/footer() instead.<br />
* Save index.php.<br />
* Open /var/www/moodle20/lib/sessionlib.php in your editor.<br />
* Find the function confirm_sesskey();<br />
* Add a line at the start of this function:<br />
return true;<br />
* Save sessionlib.php.<br />
<br />
==Step 3: Create the new database you want to copy to==<br />
<br />
As if you were about to install Moodle. You need an empty database, and a 'moodle' user that can connect to it with full control.<br />
<br />
==Step 4: Replace all the database definition files in 2.0 with their 1.9 equivalents==<br />
<br />
What we need to do is delete all of the install.xml files that belong to Moodle 2.0, wherever they are inside the moodle20 directory, and instead copy in all the ones belonging to Moodle 1.9. This is best done with the following command-line magic:<br />
<br />
cd /var/www/moodle20<br />
find . -iname 'install.xml' -exec rm -f {} \;<br />
cd /var/www/moodle19<br />
find . -iname 'install.xml' -exec cp {} ../moodle20/{} \;<br />
<br />
==Step 5: Do the copy==<br />
<br />
* Go directly to the URL http://example.com/moodle20/admin/dbtransfer/index.php in your web browser.<br />
* Fill in the details of the database you want to copy to.<br />
* Click 'Transfer data' button.<br />
* Wait patiently. Do not panic that there is no feedback at all about what is going on. (Actually, I may soon edit the code to add some feedback display!)<br />
<br />
Hopefully, that works. Good luck!</div>Jtomkinson