MySQL Forums
Forum List  »  Quality Assurance

Abnormal/impossible Query_time in slow query log (again)
Posted by: Miko M
Date: December 12, 2014 02:16AM

Dear MySQL Forum Users,

I wonder if someone has experienced the following bug:

# Query_time: 18446742698159.859375 Lock_time: 0.000841 Rows_sent: 0 Rows_examined: 1557
SET timestamp=1416995188;
call dbs.GetIntoMemoryTable();
(...)
# Query_time: 18446742701340.859375 Lock_time: 0.000682 Rows_sent: 0 Rows_examined: 107
SET timestamp=1416995188;
call dbs.UpdateInfo();

It occurs for stored procedures only, on MariaDB 10.0.14 with the following configuration:

[mariadb-10.0]
slow-query-log=1
slow-query-log-file=/var/log/mysqld_slow.log
log-queries-not-using-indexes=1
long_query_time=1

However it does not appear at all with this configuration:

[mariadb-10.0]
slow-query-log=1
slow-query-log-file=/var/log/mysqld_slow.log
log-queries-not-using-indexes=0
long_query_time=1
min_examined_row_limit=1000


A few very similar bugs have been raised in the past, such as:
http://bugs.mysql.com/bug.php?id=35396
http://bugs.mysql.com/bug.php?id=63524

But they seem to be fixed, although none of them have been opened for stored procedures only.

Many thanks.

Miko

Options: ReplyQuote


Subject
Views
Written By
Posted
Abnormal/impossible Query_time in slow query log (again)
1983
December 12, 2014 02:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.