ID: 46355
Updated by: [EMAIL PROTECTED]
Reported By: olafvdspek at gmail dot com
-Status: Open
+Status: Bogus
Bug Type: Feature/Change Request
Operating System: *
PHP Version: 6CVS-2008-10-21 (CVS)
New Comment:
You can use the MySQL Proxy or build an abstraction layer on top of the
mysql functions for doing that.
Previous Comments:
------------------------------------------------------------------------
[2008-10-21 11:07:46] olafvdspek at gmail dot com
Description:
------------
Hi,
Could you add a (MySQL) query logger? It'd log each query, including
the duration and number of rows affected. This is very useful to
diagnose slow pages.
See below for an idea of what interface could be provided.
Reproduce code:
---------------
mysql_log_queries(true);
mysql_query("select * from T");
$a = mysql_get_log();
foreach ($a as $row)
{
printf("%.1f ms - %d rows - %s", $row['duration'],
$row['affected_rows'], htmlspecialchars($row['query']));
}
Expected result:
----------------
-
Actual result:
--------------
-
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=46355&edit=1
