Here is my 2.0 update of perpective.php... I added the global declaration of $DB object and updated the DML_functions as described in http://docs.moodle.org/en/Development:DML_functions
Thanks for the update. I tested it for fun (I'm aware of the limitations of this script).
Here are the results. VPS Ubuntu 10.04 with 2GB RAM (burst to 4.5GB) - 6 cores 2.4GHZ. Moodle 2.2.3
| Moodle System Benchmarks Note for Moodle 1.7 and above: Disable the record cache (Site Admin -> Server -> Performance) for realistic results! | |||
|---|---|---|---|
| Processor performance | |||
| Function calls | 3535000 | 3522000 | |
| Regular expression replaces over 1KB of text | 20200 | 20200 | |
| Disk performance | |||
| 16KB files read from disk (cache) | 77200 | 79100 | |
| 16KB files written to disk (cache) | 6300 | 6500 | |
| Database performance | |||
| Get_record calls on the course table | 6080 | 5930 | |
| Insert_record calls on the course table | 1890 | 2490 | |
| Update_record calls on the course table | 2330 | 6270 | |
| Maximum concurrent users (approx): | 251 | ||
I have also done some JMeter testing - I am very happy with this little box
Cheers,
Fred
Hi, I am trying to benchmark two installataions of moodle 2.3 running in amazon aws with rds. One its over apache and the other its over lighty.
But I cant make work the script, I tried just to copy to /mod/ but I cant make it work.
¿How does I install the script?
Thank you in advance
I may be wrong, but I don't think that this script is usable anymore and hasn't been updated in quite some time.
Why is it not usable? Could you describe what you've tried and what happened?
The script only works with moodle 1.9 and below. The database calls need to be updated for Moodle 2.0 and above:
get_record('course','id',1) : $DB->get_record('course',array('id' => 1))
insert_record('course',$newrecord) becomes $DB->insert_record('course',$newrecord)
update_record('course',$newrecord) : $DB->update_record('course',$newrecord)
delete_records('course','id',$ids[$count]) : $DB->delete_records('course',array('id' => $ids[$count]))
$db->ErrorMsg() : $DB->ErrorMsg() - there's 4 of these
I think that's everything.