MOON
Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
System: Linux vps.panamaemb.org.sg 3.10.0-1160.80.1.vz7.191.4 #1 SMP Thu Dec 15 20:31:06 MSK 2022 x86_64
User: panama (500)
PHP: 5.2.17
Disabled: NONE
Upload Files
File: //proc/2/root/usr/share/mysql-test/include/print_greedy_search_count.inc
# include/print_greedy_search_count.inc
#
# SUMMARY
#
#    $query should be assigned a select statement. 
#    The query will be EXPLAINed and the number of 
#    partial plans greedy search went through to 
#    create the QEP is printed.
#
# USAGE
#
#    let $query= <query>;
#    --source include/print_greedy_search_count.inc
#
# EXAMPLE
#    t/greedy_search.test
#

eval EXPLAIN $query;

let $greedy_search_partial_plans=
  query_get_value(SHOW STATUS LIKE 'Last_query_partial_plans', Value, 1);

--echo ### Partial_plans: $greedy_search_partial_plans
FLUSH STATUS;