diff options
| author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-06-27 11:58:12 +0000 |
|---|---|---|
| committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-06-27 11:58:12 +0000 |
| commit | 177098910fa2ab6cb502f359c3c0ed33140f57d9 (patch) | |
| tree | 47c96808f432a890f571075671a0b379fe0eb3a1 /engine/lib | |
| parent | acd9393531c4a74af9927cb4a875bdb652d5c422 (diff) | |
| download | elgg-177098910fa2ab6cb502f359c3c0ed33140f57d9.tar.gz elgg-177098910fa2ab6cb502f359c3c0ed33140f57d9.tar.bz2 | |
Refs #101 - DB Profiling in debug mode (recommended usage means putting $CONFIG->debug = true in settings.php)
git-svn-id: https://code.elgg.org/elgg/trunk@1173 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/lib')
| -rw-r--r-- | engine/lib/database.php | 48 |
1 files changed, 41 insertions, 7 deletions
diff --git a/engine/lib/database.php b/engine/lib/database.php index d908bf725..3e6677f75 100644 --- a/engine/lib/database.php +++ b/engine/lib/database.php @@ -11,6 +11,8 @@ * @copyright Curverider Ltd 2008
* @link http://elgg.org/
*/ + + $DB_PROFILE = array(); /**
* Connect to the database server and use the Elgg database for a particular database link
@@ -74,7 +76,28 @@ establish_db_link('readwrite');
}
- }
+ } + + /** + * Shutdown hook to display profiling information about db (debug mode) + */ + function db_profiling_shutdown_hook() + { + global $CONFIG, $DB_PROFILE, $dbcalls; + + if ($CONFIG->debug) + { + error_log("***************** DB PROFILING ********************"); + + $DB_PROFILE = array_count_values($DB_PROFILE); + + foreach ($DB_PROFILE as $k => $v) + error_log("$v times: '$k' "); + + error_log("DB Queries for this page: $dbcalls"); + error_log("***************************************************"); + } + }
/**
* Alias to setup_db_connections, for use in the event handler
@@ -83,7 +106,8 @@ * @param string $object_type The object type
* @param mixed $object Used for nothing in this context
*/
- function init_db($event, $object_type, $object = null) {
+ function init_db($event, $object_type, $object = null) { + register_shutdown_function('db_profiling_shutdown_hook');
setup_db_connections();
return true;
}
@@ -127,7 +151,7 @@ function get_data($query, $callback = "") {
- global $CONFIG, $dbcalls;
+ global $CONFIG, $dbcalls, $DB_PROFILE;
$dblink = get_db_link('read');
@@ -136,6 +160,8 @@ if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) { + $DB_PROFILE[] = $query; + error_log("--- DB QUERY --- $query"); error_log("--- EXPLANATION --- " . print_r(explain_query($query,$dblink), true)); } @@ -169,7 +195,7 @@ function get_data_row($query) {
- global $CONFIG, $dbcalls;
+ global $CONFIG, $dbcalls, $DB_PROFILE;
$dblink = get_db_link('read');
@@ -177,6 +203,8 @@ if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) { + $DB_PROFILE[] = $query; + error_log("--- DB QUERY --- $query"); error_log("--- EXPLANATION --- " . print_r(explain_query($query,$dblink), true)); }
@@ -205,7 +233,7 @@ function insert_data($query) {
- global $CONFIG, $dbcalls;
+ global $CONFIG, $dbcalls, $DB_PROFILE;
$dblink = get_db_link('write');
@@ -213,6 +241,8 @@ if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) { + $DB_PROFILE[] = $query; + error_log("--- DB QUERY --- $query"); }
@@ -234,7 +264,7 @@ function update_data($query) {
- global $dbcalls, $CONFIG;
+ global $dbcalls, $CONFIG, $DB_PROFILE;
$dblink = get_db_link('write');
@@ -242,6 +272,8 @@ if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) { + $DB_PROFILE[] = $query; + error_log("--- DB QUERY --- $query"); }
@@ -264,7 +296,7 @@ function delete_data($query) {
- global $dbcalls, $CONFIG;
+ global $dbcalls, $CONFIG, $DB_PROFILE;
$dblink = get_db_link('write');
@@ -272,6 +304,8 @@ if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) { + $DB_PROFILE[] = $query; + error_log("--- DB QUERY --- $query"); }
|