Bug #18801 mysqldumpslow does not summarize negative numbers correctly
Submitted: 5 Apr 2006 13:13 Modified: 7 Apr 2006 10:39
Reporter: Oli Sennhauser Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.19 OS:Linux (linux)
Assigned to: CPU Architecture:Any

[5 Apr 2006 13:13] Oli Sennhauser
Description:
When profiling the slow-query-log mysqldumpslow does not aggregate negative and positive numbers. It makes 2 separate entries in the profile.

Count: 1  Time=54.00s (54s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@localhost
  select count(*) from sales_fact where product_id = -N

Count: 1  Time=52.00s (52s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@localhost
  select count(*) from sales_fact where product_id = N

How to repeat:
mysqldumpslow -s t linux-slow.log.bug > linux-slow.log.bug.profile

Suggested fix:
pattern interpreation of numbers is not correct?
[5 Apr 2006 14:01] Valeriy Kravchuk
Thank you for a problem report. Sorry, but I was not able to repeat the problem you described with the following simple test (on 5.0.21-BK):

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.21-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> desc t;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| x     | int(11) | YES  |     |         |       |
+-------+---------+------+-----+---------+-------+
1 row in set (0.01 sec)

mysql> select sleep(20) from t where x = 1;
+-----------+
| sleep(20) |
+-----------+
| 0         |
+-----------+
1 row in set (20.07 sec)

mysql> select sleep(20) from t where x = -1;
Empty set (0.03 sec)

mysql> exit
Bye
openxs@suse:~/dbs/5.0> bin/mysqldumpslow var/suse-slow.log

Reading mysql slow query log from var/suse-slow.log
Count: 1  Time=20.00s (20s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@localhost

  select sleep(N) from t where x = N

Count: 2  Time=15.00s (30s)  Lock=0.00s (0s)  Rows=1.0 (2), root[root]@localhost

  select sleep(N)
[7 Apr 2006 10:39] Oli Sennhauser
Hi Valeriy
5.0.19 and 5.1.7 have still the same (erroneous) behaviour and I could not find any comment in the change list for a bugfix/change on this.
Where can I get 5.0.21?