BrnDmp

MySQL tuning and maintenance

Thursday, March 13th, 2008

Analyzing MySQL instances on Moodle servers with tuning scripts: mysqltuner.pl tuning-primer.sh mysqlreport Damn, can't seem to set mysql variables at runtime. Should be able with mysql --variable_name=value or, when in mysql, with set global variable_name = value or, when changing the running session: set @@variable_name=value; Does not work for open_files_limit but it does work for ...

Posted in BrnDmp | No Comments »

Scorm tracking in Moodle

Thursday, March 13th, 2008

Built custom report for viewing number of attempts and succesfull attempts of SCORM modules in Moodle. Read the attempts and success from grade_grades table but comparing number of attempts to other data they seemed a bit low. Checked the SCORM tracker ""scorm_scoes_track" table for SCORM collected data -> SC ORM ...

Posted in BrnDmp | No Comments »