Debian Codegraph @

mysql-test/suite/perfschema/r/selects.result

raw
1 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
2 UPDATE performance_schema.setup_threads SET ENABLED='NO';
3 UPDATE performance_schema.threads SET INSTRUMENTED='NO';
4 UPDATE performance_schema.threads
5 SET INSTRUMENTED='YES' WHERE PROCESSLIST_ID = connection_id();
6 UPDATE performance_schema.setup_instruments SET enabled = 'NO', timed = 'NO'
7 where NAME='wait/io/table/sql/handler';
8 TRUNCATE TABLE performance_schema.events_waits_current;
9 TRUNCATE TABLE performance_schema.events_waits_history;
10 TRUNCATE TABLE performance_schema.events_waits_history_long;
11 DROP TABLE IF EXISTS t1;
12 CREATE TABLE t1 (id INT PRIMARY KEY, b CHAR(100) DEFAULT 'initial value')
13 ENGINE=MyISAM;
14 INSERT INTO t1 (id) VALUES (1), (2), (3), (4), (5), (6), (7), (8);
15 SELECT OPERATION, SUM(NUMBER_OF_BYTES) AS TOTAL
16 FROM performance_schema.events_waits_history_long
17 GROUP BY OPERATION
18 HAVING TOTAL IS NOT NULL
19 ORDER BY OPERATION
20 LIMIT 1;
21 OPERATION TOTAL
22 chsize [NUM_BYTES]
23 SELECT EVENT_ID FROM performance_schema.events_waits_current
24 WHERE THREAD_ID IN
25 (SELECT THREAD_ID FROM performance_schema.threads)
26 AND EVENT_NAME IN
27 (SELECT NAME FROM performance_schema.setup_instruments
28 WHERE NAME LIKE "wait/synch/%")
29 LIMIT 1;
30 EVENT_ID
31 [EVENT_ID]
32 SELECT DISTINCT EVENT_ID
33 FROM performance_schema.events_waits_current
34 JOIN performance_schema.events_waits_history USING (EVENT_ID)
35 JOIN performance_schema.events_waits_history_long USING (EVENT_ID)
36 ORDER BY EVENT_ID
37 LIMIT 1;
38 EVENT_ID
39 [EVENT_ID]
40 SELECT t1.THREAD_ID, t2.EVENT_ID, t3.EVENT_NAME, t4.TIMER_WAIT
41 FROM performance_schema.events_waits_history t1
42 JOIN performance_schema.events_waits_history t2 USING (EVENT_ID)
43 JOIN performance_schema.events_waits_history t3 ON (t2.THREAD_ID = t3.THREAD_ID)
44 JOIN performance_schema.events_waits_history t4 ON (t3.EVENT_NAME = t4.EVENT_NAME)
45 ORDER BY t1.EVENT_ID, t2.EVENT_ID
46 LIMIT 5;
47 THREAD_ID EVENT_ID EVENT_NAME TIMER_WAIT
48 [THREAD_ID] [EVENT_ID] [EVENT_NAME] [TIMER_WAIT]
49 [THREAD_ID] [EVENT_ID] [EVENT_NAME] [TIMER_WAIT]
50 [THREAD_ID] [EVENT_ID] [EVENT_NAME] [TIMER_WAIT]
51 [THREAD_ID] [EVENT_ID] [EVENT_NAME] [TIMER_WAIT]
52 [THREAD_ID] [EVENT_ID] [EVENT_NAME] [TIMER_WAIT]
53 SELECT THREAD_ID, EVENT_ID FROM (
54 SELECT THREAD_ID, EVENT_ID FROM performance_schema.events_waits_current
55 UNION
56 SELECT THREAD_ID, EVENT_ID FROM performance_schema.events_waits_history
57 UNION
58 SELECT THREAD_ID, EVENT_ID FROM performance_schema.events_waits_history_long
59 ) t1 ORDER BY THREAD_ID, EVENT_ID
60 LIMIT 5;
61 THREAD_ID EVENT_ID
62 [THREAD_ID] [EVENT_ID]
63 [THREAD_ID] [EVENT_ID]
64 [THREAD_ID] [EVENT_ID]
65 [THREAD_ID] [EVENT_ID]
66 [THREAD_ID] [EVENT_ID]
67 DROP TABLE IF EXISTS t_event;
68 DROP EVENT IF EXISTS t_ps_event;
69 CREATE TABLE t_event AS
70 SELECT EVENT_ID FROM performance_schema.events_waits_current
71 WHERE 1 = 2;
72 CREATE EVENT t_ps_event
73 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 SECOND
74 ON COMPLETION PRESERVE
75 DO INSERT INTO t_event
76 SELECT DISTINCT EVENT_ID
77 FROM performance_schema.events_waits_current
78 ORDER BY EVENT_ID
79 LIMIT 1;
80 ALTER TABLE t1 ADD COLUMN c INT;
81 DROP TRIGGER IF EXISTS t_ps_trigger;
82 CREATE TRIGGER t_ps_trigger BEFORE INSERT ON t1
83 FOR EACH ROW BEGIN
84 SET NEW.c = (SELECT MAX(EVENT_ID)
85 FROM performance_schema.events_waits_current);
86 END;
87 |
88 INSERT INTO t1 (id) VALUES (11), (12), (13);
89 SELECT id, c FROM t1 WHERE id > 10 ORDER BY id, c;
90 id c
91 11 [EVENT_ID]
92 12 [EVENT_ID]
93 13 [EVENT_ID]
94 DROP TRIGGER t_ps_trigger;
95 DROP PROCEDURE IF EXISTS t_ps_proc;
96 CREATE PROCEDURE t_ps_proc(IN conid INT, OUT pid INT)
97 BEGIN
98 SELECT thread_id FROM performance_schema.threads
99 WHERE PROCESSLIST_ID = conid INTO pid;
100 END;
101 |
102 CALL t_ps_proc(connection_id(), @p_id);
103 DROP FUNCTION IF EXISTS t_ps_proc;
104 CREATE FUNCTION t_ps_func(conid INT) RETURNS int
105 BEGIN
106 return (SELECT thread_id FROM performance_schema.threads
107 WHERE PROCESSLIST_ID = conid);
108 END;
109 |
110 SELECT t_ps_func(connection_id()) = @p_id;
111 t_ps_func(connection_id()) = @p_id
112 1
113 SELECT * FROM t_event;
114 EVENT_ID
115 [EVENT_ID]
116 DROP PROCEDURE t_ps_proc;
117 DROP FUNCTION t_ps_func;
118 DROP EVENT t_ps_event;
119 DROP TABLE t1;
120 DROP TABLE t_event;
121 UPDATE performance_schema.setup_threads SET ENABLED='YES';
122 UPDATE performance_schema.threads SET INSTRUMENTED='YES';
123 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';