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