From: olafvdspek at gmail dot com
Operating system: *
PHP version: 6CVS-2008-10-21 (CVS)
PHP Bug Type: Feature/Change Request
Bug description: Query logger
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 bug report at http://bugs.php.net/?id=46355&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=46355&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=46355&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=46355&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=46355&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=46355&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=46355&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=46355&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=46355&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=46355&r=support
Expected behavior: http://bugs.php.net/fix.php?id=46355&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=46355&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=46355&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=46355&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=46355&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=46355&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=46355&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=46355&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=46355&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=46355&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=46355&r=mysqlcfg
