|
|
Línia 16: |
Línia 16: |
|
| |
|
| {| class="nicetable" | | {| class="nicetable" |
| ! !! colspan="3" | Old Server !! colspan="3" | New Servers | | ! !! Old Server !! colspan="3" | New Servers |
| |- | | |- |
| ! Test !! myisam !! innodb !! postgres !! myisam !! innodb !! postgres | | ! Test !! myisam !! myisam !! innodb !! postgres |
| |- | | |- |
| | slowqueries 1 || || || || [[Image:server10-slowtest1.png]] || || | | | slowqueries 1 || || [[Image:server10-slowtest1.png]] || || |
| |- | | |- |
| | slowqueries 100 || || || || || || | | | slowqueries 100 || || || || |
| |- | | |- |
| | perspective (all caching off) || | | | perspective (all caching off) || |
Línia 41: |
Línia 41: |
| * 250 update_record calls on the course table | | * 250 update_record calls on the course table |
|
| |
|
| || || ||
| | || |
| * 2057000 function calls | | * 2057000 function calls |
| * 14800 16KB files read from disk (cache) | | * 14800 16KB files read from disk (cache) |
Línia 76: |
Línia 76: |
| * 250 update_record calls on the course table | | * 250 update_record calls on the course table |
|
| |
|
| || || ||
| | || |
| * 1997000 function calls | | * 1997000 function calls |
| * 14700 16KB files read from disk (cache) | | * 14700 16KB files read from disk (cache) |
Línia 94: |
Línia 94: |
| || || | | || || |
| |- | | |- |
| | loginpost 1 || || || || || || | | | loginpost 1 || || || || |
| |- | | |- |
| | loginpost 100 || || || || || || | | | loginpost 100 || || || || |
| |} | | |} |
Revisió del 05:11, 19 feb 2009
Moodle.org hardware
The new servers for moodle.org consist of two machines directly linked by a 1Gb VLAN:
Web server
- 2 x Quad Core Intel Xeon E5405 - 8 cores @ 2Ghz each
- 2 x 146GB 15k RPM SAS drives in RAID 1 via PERC 6/i controller
- 8Gb Registered ECC RAM
Database server
- 1 x Quad Core Intel Xeon E5405 - 4 cores @ 2Ghz each
- 3 x 146GB 15K RPM SAS drives in RAID 5 via PERC 6/i controller
- 8Gb Registered ECC RAM
Server tests
|
Old Server |
New Servers
|
Test |
myisam |
myisam |
innodb |
postgres
|
slowqueries 1 |
|
|
|
|
slowqueries 100 |
|
|
|
|
perspective (all caching off) |
* 1402000 function calls
* 11500 16KB files read from disk (cache)
* 7900 regular expression replaces over 1KB of text
* 6000 16KB files written to disk (cache)
* 4880 get_record calls on the course table
* 1030 insert_record calls on the course table
* 240 update_record calls on the course table
* 1293000 function calls
* 11400 16KB files read from disk (cache)
* 8200 regular expression replaces over 1KB of text
* 6000 16KB files written to disk (cache)
* 5530 get_record calls on the course table
* 1590 insert_record calls on the course table
* 250 update_record calls on the course table
|
* 2057000 function calls
* 14800 16KB files read from disk (cache)
* 16100 regular expression replaces over 1KB of text
* 8500 16KB files written to disk (cache)
* 2730 get_record calls on the course table
* 2290 insert_record calls on the course table
* 340 update_record calls on the course table
* 2045000 function calls
* 14800 16KB files read from disk (cache)
* 16200 regular expression replaces over 1KB of text
* 8700 16KB files written to disk (cache)
* 2730 get_record calls on the course table
* 1960 insert_record calls on the course table
* 340 update_record calls on the course table
|
|
|
perspective (all caching on) |
* 1403000 function calls
* 10000 16KB files read from disk (cache)
* 8300 regular expression replaces over 1KB of text
* 5200 16KB files written to disk (cache)
* 5270 get_record calls on the course table
* 1390 insert_record calls on the course table
* 220 update_record calls on the course table
* 1382000 function calls
* 11000 16KB files read from disk (cache)
* 8200 regular expression replaces over 1KB of text
* 5800 16KB files written to disk (cache)
* 5640 get_record calls on the course table
* 2140 insert_record calls on the course table
* 250 update_record calls on the course table
|
* 1997000 function calls
* 14700 16KB files read from disk (cache)
* 16100 regular expression replaces over 1KB of text
* 8800 16KB files written to disk (cache)
* 19620 get_record calls on the course table
* 2290 insert_record calls on the course table
* 340 update_record calls on the course table
* 2003000 function calls
* 14700 16KB files read from disk (cache)
* 16000 regular expression replaces over 1KB of text
* 8800 16KB files written to disk (cache)
* 19560 get_record calls on the course table
* 1830 insert_record calls on the course table
* 340 update_record calls on the course table
|
|
|
loginpost 1 |
|
|
|
|
loginpost 100 |
|
|
|
|