pinba engine cached

[ihanick]

Hi, I have a problem with mysql query cache.
Could you reflect this in you documentation or disable query cache for
pinba engine
mysql> select * from info;
+-----------+------------+----------------+----------------
+---------------+--------------+
| req_count | time_total | ru_utime_total | ru_stime_total |
time_interval | kbytes_total |
+-----------+------------+----------------+----------------
+---------------+--------------+
| 2045 | 165.282 | 65.582 | 4.019
| 9 | 70552.5 |
+-----------+------------+----------------+----------------
+---------------+--------------+
1 row in set (0.00 sec)

mysql> select * from info;
+-----------+------------+----------------+----------------
+---------------+--------------+
| req_count | time_total | ru_utime_total | ru_stime_total |
time_interval | kbytes_total |
+-----------+------------+----------------+----------------
+---------------+--------------+
| 2045 | 165.282 | 65.582 | 4.019
| 9 | 70552.5 |
+-----------+------------+----------------+----------------
+---------------+--------------+
1 row in set (0.00 sec)

mysql> select /* SQL_NOCACHE */ * from info;
+-----------+------------+----------------+----------------
+---------------+--------------+
| req_count | time_total | ru_utime_total | ru_stime_total |
time_interval | kbytes_total |
+-----------+------------+----------------+----------------
+---------------+--------------+
| 7929 | 643.636 | 246.96 | 15.174
| 37 | 270292 |
+-----------+------------+----------------+----------------
+---------------+--------------+
1 row in set (0.00 sec)

[Antony Dovgal]

On 16.10.2009 13:24, ihanick wrote:
> Hi, I have a problem with mysql query cache.
> Could you reflect this in you documentation or disable query cache for
> pinba engine

Nice catch, thanks!
Fixed in Git, see http://github.com/tony2001/pinba_engine/commit/3c653d76fbd923ad214656080160f33e51c920b5

--
Wbr,
Antony Dovgal
---
http://pinba.org - realtime statistics for PHP