1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
# Tests for special content of performance_schema.threads
#
# The feature INSERT DELAYED (supported by MyISAM,MEMORY,ARCHIVE,BLACKHOLE)
# causes that a "delayed_insert" thread shows up as soon as the first
# INSERT DELAYED was issued.
--source include/not_embedded.inc
--source include/have_perfschema.inc
--disable_warnings
DROP TABLE IF EXISTS t1;
DROP TEMPORARY TABLE IF EXISTS t2;
--enable_warnings
CREATE TABLE t1 (f1 BIGINT) ENGINE = MyISAM;
CREATE TEMPORARY TABLE t2 AS
SELECT thread_id FROM performance_schema.threads WHERE 1 = 2;
# Reveal that the delayed_insert thread does not exist.
# Note(mleich): This expectation is probably not all time true.
SELECT COUNT(*) = 0 AS expect_1 FROM performance_schema.threads
WHERE name = 'thread/sql/delayed_insert';
INSERT INTO t2 SELECT thread_id
FROM performance_schema.threads;
let $wait_condition= SELECT COUNT(*) = 1 AS expect_0 FROM performance_schema.threads
WHERE name = 'thread/sql/delayed_insert';
INSERT DELAYED INTO t1 SET f1 = SLEEP(3);
--source include/wait_condition.inc
# Expect to get
# thread/sql/delayed_insert FOREGROUND YES root localhost
SELECT name, type, instrumented, processlist_user, processlist_host
FROM performance_schema.threads
WHERE thread_id NOT IN (SELECT thread_id FROM t2);
DROP TABLE t1;
DROP TEMPORARY TABLE t2;
|
