Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/include/

View File Name : explain_other.inc

# Prerequisites:
# connections:
#   cq - connection where queries are run
#   ce - connection where explain is run
# variables:
#   query - query to explain
#   format - explain format: 'json' for json, or traditional otherwise
#   point  - syncing point

--disable_reconnect

connection cq;
--disable_result_log
--disable_query_log
let $QID= `SELECT CONNECTION_ID()`;
eval SET DEBUG_SYNC= '$point SIGNAL ready_for_explain WAIT_FOR explained';
send_eval $query;

connection ce;
--disable_result_log
--disable_query_log
if ($format == 'json') {
  let $fmt= FORMAT=JSON;
}
if ($format != 'json') {
  let $fmt= FORMAT=TRADITIONAL;
}
--enable_result_log
--echo EXPLAIN $fmt FOR QUERY '$query'
# Let the query being explained reach the sync point
SET DEBUG_SYNC= 'now WAIT_FOR ready_for_explain';
SET DEBUG_SYNC= 'after_explain_other SIGNAL explained';
--error $err
--eval EXPLAIN $fmt FOR CONNECTION $QID;

connection cq;
--disable_result_log
--disable_query_log
reap;
SET DEBUG_SYNC= 'RESET';
--enable_query_log
--enable_result_log

--enable_reconnect