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