Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
None
-
None
Description
bzr version-info
|
revision-id: psergey@askmonty.org-20130919043358-hkwt0vyh9zl9xhy5
|
revno: 3691
|
branch-nick: 10.0-base-explain-slowquerylog
|
#3 <signal handler called>
|
#4 0x000000000076f5f2 in QPF_query::print_explain (this=0x7f5620006af0, output=0x7f567036fc20, explain_flags=0 '\000') at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:119
|
#5 0x000000000076f6d2 in QPF_query::print_explain_str (this=0x7f5620006af0, thd=0x3c8edb8, out_str=0x7f567036fdb0) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:135
|
#6 0x000000000076f646 in print_qpf_query (lex=0x3c92270, thd=0x3c8edb8, str=0x7f567036fdb0) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:125
|
#7 0x00000000008d3097 in MYSQL_QUERY_LOG::write (this=0x263e4d0, thd=0x3c8edb8, current_time=1379697846, user_host=0x7f5670370250 "root[root] @ localhost [127.0.0.1]", user_host_len=34, query_utime=122, lock_utime=0, is_command=false, sql_text=0x7f56200187a0 "set long_query_time=0.000001", sql_text_len=28) at 10.0-base-explain-slowquerylog/sql/log.cc:2833
|
#8 0x00000000008ce232 in Log_to_file_event_handler::log_slow (this=0x263df80, thd=0x3c8edb8, current_time=..., user_host=0x7f5670370250 "root[root] @ localhost [127.0.0.1]", user_host_len=34, query_utime=122, lock_utime=0, is_command=false, sql_text=0x7f56200187a0 "set long_query_time=0.000001", sql_text_len=28) at 10.0-base-explain-slowquerylog/sql/log.cc:996
|
#9 0x00000000008ced09 in LOGGER::slow_log_print (this=0x1593b80, thd=0x3c8edb8, query=0x7f56200187a0 "set long_query_time=0.000001", query_length=28, current_utime=2112774371346) at 10.0-base-explain-slowquerylog/sql/log.cc:1287
|
#10 0x00000000008db047 in slow_log_print (thd=0x3c8edb8, query=0x7f56200187a0 "set long_query_time=0.000001", query_length=28, current_utime=2112774371346) at 10.0-base-explain-slowquerylog/sql/log.cc:5870
|
#11 0x000000000061fcb1 in log_slow_statement (thd=0x3c8edb8) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1566
|
#12 0x000000000061f965 in dispatch_command (command=COM_QUERY, thd=0x3c8edb8, packet=0x3c93b29 "", packet_length=28) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1495
|
#13 0x000000000061d923 in do_command (thd=0x3c8edb8) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:812
|
#14 0x000000000073da47 in do_handle_one_connection (thd_arg=0x3c8edb8) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1266
|
#15 0x000000000073d7b5 in handle_one_connection (arg=0x3c8edb8) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1181
|
#16 0x00007f5672a4ce9a in start_thread (arg=0x7f5670371700) at pthread_create.c:308
|
#17 0x00007f5671d40cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
set global slow_query_log=1; |
set long_query_time=0.000001; |
set log_slow_verbosity='query_plan,explain'; |
set autocommit = 1; |
Attachments
Issue Links
- relates to
-
MDEV-407 Print EXPLAIN [ANALYZE] in the slow query log
- Closed