From ec22e38039f543c3de600e7dffa352989c9d3ba0 Mon Sep 17 00:00:00 2001 From: skodak Date: Wed, 18 Jun 2008 08:26:41 +0000 Subject: [PATCH] MDL-15273 basic read/write perf counter in moodle_database --- admin/cron.php | 8 ++++---- lib/dml/moodle_database.php | 1 + 2 files changed, 5 insertions(+), 4 deletions(-) diff --git a/admin/cron.php b/admin/cron.php index 47c8153a1a..f5f49bb664 100644 --- a/admin/cron.php +++ b/admin/cron.php @@ -110,7 +110,7 @@ if (function_exists($cron_function)) { mtrace("Processing module function $cron_function ...", ''); $pre_dbqueries = null; - $pre_dbqueries = $DB->perf_get_reads(); + $pre_dbqueries = $DB->perf_get_queries(); $pre_time = microtime(1); if ($cron_function()) { if (!$DB->set_field("modules", "lastcron", $timenow, array("id"=>$mod->id))) { @@ -118,7 +118,7 @@ } } if (isset($pre_dbqueries)) { - mtrace("... used " . ($DB->perf_get_reads() - $pre_dbqueries) . " dbqueries"); + mtrace("... used " . ($DB->perf_get_queries() - $pre_dbqueries) . " dbqueries"); mtrace("... used " . (microtime(1) - $pre_time) . " seconds"); } /// Reset possible changes by modules to time_limit. MDL-11597 @@ -171,11 +171,11 @@ $cronfunction = 'report_'.$report.'_cron'; mtrace('Processing cron function for '.$report.'...', ''); $pre_dbqueries = null; - $pre_dbqueries = $DB->perf_get_reads(); + $pre_dbqueries = $DB->perf_get_queries(); $pre_time = microtime(true); $cronfunction(); if (isset($pre_dbqueries)) { - mtrace("... used " . ($DB->perf_get_reads() - $pre_dbqueries) . " dbqueries"); + mtrace("... used " . ($DB->perf_get_queries() - $pre_dbqueries) . " dbqueries"); mtrace("... used " . round(microtime(true) - $pre_time, 2) . " seconds"); } mtrace('done.'); diff --git a/lib/dml/moodle_database.php b/lib/dml/moodle_database.php index 27f24a74a4..bd195a43be 100644 --- a/lib/dml/moodle_database.php +++ b/lib/dml/moodle_database.php @@ -1403,6 +1403,7 @@ abstract class moodle_database { return true; } +/// performance and logging /** * Returns number of reads done by this database * @return int -- 2.39.5