File: threads_insert_delayed.result

package info (click to toggle)
percona-xtrabackup 2.2.3-2.1
  • links: PTS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 293,260 kB
  • ctags: 146,881
  • sloc: cpp: 1,051,960; ansic: 570,217; java: 54,595; perl: 53,495; pascal: 44,194; sh: 27,826; yacc: 15,314; python: 12,142; xml: 7,848; sql: 4,125; makefile: 1,459; awk: 785; lex: 758
file content (21 lines) | stat: -rw-r--r-- 845 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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);
Warnings:
Warning	1287	'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead
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;