diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/threads_insert_delayed.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/threads_insert_delayed.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/threads_insert_delayed.result b/mysql-test/suite/perfschema/r/threads_insert_delayed.result new file mode 100644 index 00000000..b3bcdc49 --- /dev/null +++ b/mysql-test/suite/perfschema/r/threads_insert_delayed.result @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS t1; +DROP TEMPORARY TABLE IF EXISTS t2; +CREATE TABLE t1 (f1 BIGINT) ENGINE = MyISAM; +CREATE TEMPORARY TABLE t2 AS +SELECT thread_id FROM performance_schema.threads WHERE 1 = 2; +SELECT COUNT(*) = 0 AS expect_1 FROM performance_schema.threads +WHERE name = 'thread/sql/delayed_insert'; +expect_1 +1 +INSERT INTO t2 SELECT thread_id +FROM performance_schema.threads; +INSERT DELAYED INTO t1 SET f1 = SLEEP(3); +SELECT name, type, instrumented, processlist_user, processlist_host +FROM performance_schema.threads +WHERE thread_id NOT IN (SELECT thread_id FROM t2); +name type instrumented processlist_user processlist_host +thread/sql/delayed_insert FOREGROUND YES root localhost +DROP TABLE t1; +DROP TEMPORARY TABLE t2; |