diff options
Diffstat (limited to 'mysql-test/suite/perfschema/include/wait_for_pfs_thread_count.inc')
| -rw-r--r-- | mysql-test/suite/perfschema/include/wait_for_pfs_thread_count.inc | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/include/wait_for_pfs_thread_count.inc b/mysql-test/suite/perfschema/include/wait_for_pfs_thread_count.inc new file mode 100644 index 00000000000..a2ed41d9d1b --- /dev/null +++ b/mysql-test/suite/perfschema/include/wait_for_pfs_thread_count.inc @@ -0,0 +1,20 @@ +# Tests for the performance schema +# This helper can be used to enforce that no threads from previous +# tests are still running, which can impact some test scripts. + +# Wait until there is only one session left, this one. + +let $wait_condition= + select count(*) = 1 from information_schema.processlist; +--source include/wait_condition.inc + +# Threads are removed from information_schema.processlist +# very soon, but continue to execute in the server, +# before finally be removed from performance_schema.threads. +# Because instrumentation is optional, we use "<=" here. + +let $wait_condition= + select count(*) <= 1 from performance_schema.threads + where `TYPE`='FOREGROUND'; +--source include/wait_condition.inc + |