Bug #52487 | SHOW PROFILE duration time seems incorrect | ||
---|---|---|---|
Submitted: | 30 Mar 2010 21:30 | Modified: | 31 Mar 2010 6:12 |
Reporter: | Peiran Song | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
Version: | 5.1.42, 5.1. bzr | OS: | Any (OpenSolaris, Linux) |
Assigned to: | CPU Architecture: | Any |
[30 Mar 2010 21:30]
Peiran Song
[31 Mar 2010 6:12]
Sveta Smirnova
Thank you for the report. Verified as described. Not only "copy to tmp table" affected: mysql> select sleep(1100); +-------------+ | sleep(1100) | +-------------+ | 0 | +-------------+ 1 row in set (18 min 20.00 sec) mysql> show profiles; +----------+---------------+--------------------+ | Query_ID | Duration | Query | +----------+---------------+--------------------+ | 1 | 10.11582100 | select sleep(10) | | 2 | 1100.00622500 | select sleep(1100) | +----------+---------------+--------------------+ 2 rows in set (0.00 sec) mysql> show profile for query 2; +----------------------+------------+ | Status | Duration | +----------------------+------------+ | starting | 0.000953 | | checking permissions | 0.000497 | | Opening tables | 0.000473 | | init | 0.000333 | | optimizing | 0.000314 | | executing | 0.000328 | | User sleep | 999.999999 | | end | 0.000695 | | query end | 0.000308 | | freeing items | 0.001013 | | logging slow query | 0.000572 | | logging slow query | 0.000342 | | cleaning up | 0.000338 | +----------------------+------------+ 13 rows in set (0.02 sec)
[31 Mar 2010 6:23]
Peter Laursen
Also see: http://bugs.mysql.com/bug.php?id=52492