Server IP : 185.86.78.101 / Your IP : 216.73.216.213 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/include/ |
Upload File : |
# include/check_qep.inc # # SUMMARY # # Designed to be used together with include/check_qep.inc # # $query should be assigned a select statement using # straight_join to force the tables to be joined in most # optimal order. # # expect_qep.inc will then store the estimated 'Last_query_cost' # and total # 'Handler_read%' for this straight_joined query. # # We should then assign a non-straight_join'ed version of # the same query to $query and execute it using # 'include/check_qep.inc'. Its estimated cost and # #handler_reads will then be verified against the # previous straight_joined query. # # USAGE # # let $query= <select straight_join optimal statement>; # --source include/expect_qep.inc # let $query= <select statement>; # --source include/check_qep.inc # # EXAMPLE # t/greedy_optimizer.test # flush status; eval EXPLAIN $query; eval $query; let $cost= query_get_value(SHOW STATUS LIKE 'Last_query_cost', Value, 1); --disable_warnings let $reads= `select sum(variable_value) from information_schema.session_status where VARIABLE_NAME like 'Handler_read%'`; --enable_warnings #echo Cost: $cost, Handler_reads: $reads; if ($cost != $best_cost) { echo ### FAILED: Query_cost: $cost, expected: $best_cost ###; } if ($reads != $best_reads) { echo ### FAILED: Handler_reads: $reads, expected: $best_reads ###; }