diff options
| -rw-r--r-- | mysql-test/r/show_explain_ps.result | 11 | ||||
| -rw-r--r-- | mysql-test/t/show_explain_ps.test | 12 |
2 files changed, 17 insertions, 6 deletions
diff --git a/mysql-test/r/show_explain_ps.result b/mysql-test/r/show_explain_ps.result index f5c487e9e44..1b38a9ad1e5 100644 --- a/mysql-test/r/show_explain_ps.result +++ b/mysql-test/r/show_explain_ps.result @@ -28,8 +28,13 @@ count(*) 10 set debug_dbug=''; select event_name -from performance_schema.events_waits_history_long -where event_name='wait/synch/cond/sql/show_explain'; +from +performance_schema.events_stages_history_long +where +event_name like '%show explain' and +thread_id in(select thread_id +from performance_schema.events_statements_history_long +where EVENT_NAME='statement/sql/show_explain'); event_name -wait/synch/cond/sql/show_explain +stage/sql/show explain drop table t0; diff --git a/mysql-test/t/show_explain_ps.test b/mysql-test/t/show_explain_ps.test index 4ad1e4304de..e847abe3096 100644 --- a/mysql-test/t/show_explain_ps.test +++ b/mysql-test/t/show_explain_ps.test @@ -6,6 +6,8 @@ # Like all other perfschema tests, we don't work on embedded server: --source include/not_embedded.inc +--source include/restart_mysqld.inc + --disable_warnings drop table if exists t0, t1; --enable_warnings @@ -45,7 +47,11 @@ reap; set debug_dbug=''; select event_name -from performance_schema.events_waits_history_long -where event_name='wait/synch/cond/sql/show_explain'; - +from +performance_schema.events_stages_history_long +where + event_name like '%show explain' and + thread_id in(select thread_id + from performance_schema.events_statements_history_long + where EVENT_NAME='statement/sql/show_explain'); drop table t0; |