diff options
author | Sergey Petrunya <psergey@askmonty.org> | 2012-07-07 08:47:41 +0400 |
---|---|---|
committer | Sergey Petrunya <psergey@askmonty.org> | 2012-07-07 08:47:41 +0400 |
commit | a931467e17c4826ce4fa473de0479953d9bbcc59 (patch) | |
tree | 6e017fc3f244fa2a9a3f940ded632de0b96822a0 /mysql-test/t/show_explain_ps.test | |
parent | ae3bc191613fdec05d4d84a74648d1e84edc8ce4 (diff) | |
download | mariadb-git-a931467e17c4826ce4fa473de0479953d9bbcc59.tar.gz |
Enable PERFORMANCE_SCHEMA tracking for SHOW EXPLAIN's conditions.
Diffstat (limited to 'mysql-test/t/show_explain_ps.test')
-rw-r--r-- | mysql-test/t/show_explain_ps.test | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/mysql-test/t/show_explain_ps.test b/mysql-test/t/show_explain_ps.test new file mode 100644 index 00000000000..67634ac57e2 --- /dev/null +++ b/mysql-test/t/show_explain_ps.test @@ -0,0 +1,48 @@ +# +# Test how SHOW EXPLAIN is represented in performance schema +# +--source include/have_perfschema.inc + +--disable_warnings +drop table if exists t0, t1; +--enable_warnings + +select * from performance_schema.setup_instruments where name like '%show_explain%'; + +--echo # We've got no instances +select * from performance_schema.cond_instances where name like '%show_explain%'; + +--echo # Check out if our cond is hit. + +create table t0 (a int); +insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); + +let $thr1=`select connection_id()`; +connect (con1, localhost, root,,); +connection con1; +let $thr2=`select connection_id()`; +connection default; + +let $wait_condition= select State='show_explain_trap' from information_schema.processlist where id=$thr2; + +# +# Test SHOW EXPLAIN for simple queries +# +connection con1; +set @show_explain_probe_select_id=1; +set debug_dbug='d,show_explain_probe_join_exec_start'; +send select count(*) from t0 where a < 100000; + +connection default; +--source include/wait_condition.inc +evalp show explain for $thr2; +connection con1; +reap; + +set debug_dbug=''; + +select event_name +from performance_schema.events_waits_history_long +where event_name='wait/synch/cond/sql/show_explain'; + +drop table t0; |