Freezer is a tool to help developers discover which database records are created by some application’s action and which tables received these new records because that action.
It makes much easier to spot these tables and its new records, understand how the third-party application interacts with the database and also how relationships are made.
Source: llagerlof/freezer: Freezer is a tool to help developers to discover which database’s records are inserted by other programs.
Simple SQL statements debugging with MySQL global general_log variable turned ON
and a standalone php script that display the relevant SQL statements that are sent by a specific Moodle instance, filtered by the instance admin db username.
PHP Script: github/nadavkav/gist/nadavkav/mysql_statements_monitoring.php
Moodle’s profiling tool
When your software is too slow, you need measurements to tell you which are the slow bits. Tools that do that are called profilers. One of the better profiling tools for PHP is called XHProf. The good news is that it has already been integrated into Moodle, and there is documenation about getting it working. Basically, you just need to install a PHP extension and turn on some options under Admin -> Development -> Profiling.
ב: Tim’s blog: Performance-testing Moodle.