Performance perspectives - a little script

Re: Performance perspectives - a little script

by Phaessuh Kromah -
အကြောင်းပြန်မှု အရေအတွက်: 5

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

Phaessuh Kromah ထံသို့ အကြောင်းပြန်ရာတွင်

Re: Performance perspectives - a little script

by Frederic Nevers -

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

Frederic Nevers ထံသို့ အကြောင်းပြန်ရာတွင်

Re: Performance perspectives - a little script

by julian maya -

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

julian maya ထံသို့ အကြောင်းပြန်ရာတွင်

Re: Performance perspectives - a little script

by Eric Malone -

I may be wrong, but I don't think that this script is usable anymore and hasn't been updated in quite some time.

Eric Malone ထံသို့ အကြောင်းပြန်ရာတွင်

Re: Performance perspectives - a little script

by Visvanath Ratnaweera -
Particularly helpful Moodlers ၏ ရုပ်ပုံ Translators ၏ ရုပ်ပုံ
Why is it not usable? Could you describe what you've tried and what happened?
Eric Malone ထံသို့ အကြောင်းပြန်ရာတွင်

Re: Performance perspectives - a little script

by Matthew Di Giuseppe -

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.