Debian Codegraph @

mysql-test/suite/perfschema/include/transaction_nested_events_verifier.inc

raw
1 # Tests for the performance schema
2
3 # =====================================================
4 # HELPER include/transaction_nested_events_verifier.inc
5 # =====================================================
6
7 --connection default
8 --disable_query_log
9
10 # Poll till the activity of the actor connection con1 caused by the last
11 # statement issued has finished.
12 let $wait_timeout= 10;
13 let $wait_condition=
14 SELECT COUNT(*) > 0 FROM performance_schema.threads
15 WHERE THREAD_ID = @con1_thread_id
16 AND (PROCESSLIST_STATE = 'Sleep' OR PROCESSLIST_STATE IS NULL);
17 --source include/wait_condition.inc
18 if(!$success)
19 {
20 --echo The activity of connection con1 did not finish.
21 SELECT thread_id , PROCESSLIST_id, PROCESSLIST_STATE, PROCESSLIST_INFO
22 FROM performance_schema.threads
23 WHERE thread_id = @con1_thread_id;
24 --echo Abort.
25 exit;
26 }
27
28 --echo #========================================================================
29 --echo # Verify
30 --echo #========================================================================
31
32 SELECT event_id from performance_schema.events_transactions_history_long
33 where (THREAD_ID = @con1_thread_id)
34 order by event_id limit 1
35 into @base_tx_event_id;
36
37 SELECT event_id from performance_schema.events_statements_history_long
38 where (THREAD_ID = @con1_thread_id)
39 order by event_id limit 1
40 into @base_stmt_event_id;
41
42 select if(@base_tx_event_id < @base_stmt_event_id,
43 @base_tx_event_id - 1,
44 @base_stmt_event_id - 1)
45 into @base_event_id;
46
47 # Debug helpers
48 # set @base_event_id = 0;
49 # select @base_tx_event_id, @base_stmt_event_id, @base_event_id;
50
51 --echo EVENTS_TRANSACTIONS_CURRENT
52 --echo
53
54 --replace_column 1 thread_id
55
56 SELECT THREAD_ID,
57 LPAD(EVENT_ID - @base_event_id, 11, ' ') as R_EVENT_ID,
58 LPAD(END_EVENT_ID - @base_event_id, 11, ' ') as R_END_EVENT_ID,
59 RPAD(EVENT_NAME, 11, ' ') 'EVENT_NAME ',
60 RPAD(STATE, 11, ' ') 'STATE ',
61 RPAD(ACCESS_MODE, 11, ' ') ACCESS_MODE,
62 RPAD(ISOLATION_LEVEL, 16, ' ') 'ISOLATION_LEVEL ',
63 RPAD(AUTOCOMMIT, 4, ' ') AUTO,
64 LPAD(NESTING_EVENT_ID - @base_event_id, 19, ' ') as R_NESTING_EVENT_ID,
65 RPAD(IFNULL(NESTING_EVENT_TYPE, 'NULL'), 18, ' ') NESTING_EVENT_TYPE
66 FROM performance_schema.events_transactions_current
67 WHERE ((THREAD_ID = @con1_thread_id) OR (@all_threads = 1))
68 ORDER BY thread_id, event_id;
69
70 --echo
71 --echo EVENTS_TRANSACTIONS_HISTORY_LONG
72 --echo
73
74 --replace_column 1 thread_id
75
76 SELECT THREAD_ID,
77 LPAD(EVENT_ID - @base_event_id, 11, ' ') as R_EVENT_ID,
78 LPAD(END_EVENT_ID - @base_event_id, 11, ' ') as R_END_EVENT_ID,
79 RPAD(EVENT_NAME, 11, ' ') 'EVENT_NAME ',
80 RPAD(STATE, 11, ' ') 'STATE ',
81 RPAD(ACCESS_MODE, 11, ' ') ACCESS_MODE,
82 RPAD(ISOLATION_LEVEL, 16, ' ') 'ISOLATION_LEVEL ',
83 RPAD(AUTOCOMMIT, 4, ' ') AUTO,
84 LPAD(NESTING_EVENT_ID - @base_event_id, 19, ' ') as R_NESTING_EVENT_ID,
85 RPAD(IFNULL(NESTING_EVENT_TYPE, 'NULL'), 18, ' ') NESTING_EVENT_TYPE
86 FROM performance_schema.events_transactions_history_long
87 WHERE ((THREAD_ID = @con1_thread_id) OR (@all_threads = 1))
88 ORDER BY thread_id, event_id;
89
90 --echo
91 --echo EVENTS_STATEMENTS_HISTORY_LONG
92 --echo
93
94 --replace_column 1 thread_id
95
96 SELECT THREAD_ID,
97 LPAD(EVENT_ID - @base_event_id, 11, ' ') as R_EVENT_ID,
98 LPAD(END_EVENT_ID - @base_event_id, 11, ' ') as R_END_EVENT_ID,
99 RPAD(EVENT_NAME, 30, ' ') 'EVENT_NAME ',
100 RPAD(IFNULL(object_name, 'NULL'), 12, ' ') 'OBJECT_NAME ',
101 LPAD(IFNULL(NESTING_EVENT_ID - @base_event_id, 'NULL'), 19, ' ') as R_NESTING_EVENT_ID,
102 RPAD(IFNULL(NESTING_EVENT_TYPE, 'NULL'), 18, ' ') NESTING_EVENT_TYPE,
103 LPAD(NESTING_EVENT_LEVEL, 5, ' ') LEVEL,
104 SQL_TEXT
105 FROM performance_schema.events_statements_history_long
106 WHERE ((THREAD_ID = @con1_thread_id) OR (@all_threads = 1))
107 ORDER BY thread_id, event_id;
108
109 --echo
110 --echo ## Combined statement and transaction event history ordered by event id
111 --echo
112 --echo EVENTS_STATEMENTS_HISTORY_LONG + EVENTS_TRANSACTIONS_HISTORY_LONG
113 --echo
114
115 --replace_column 1 thread_id
116
117 SELECT THREAD_ID,
118 LPAD(EVENT_ID - @base_event_id, 11, ' ') as R_EVENT_ID,
119 LPAD(END_EVENT_ID - @base_event_id, 11, ' ') as R_END_EVENT_ID,
120 RPAD(EVENT_NAME, 25, ' ') 'EVENT_NAME ',
121 LPAD(NESTING_EVENT_ID - @base_event_id, 19, ' ') as R_NESTING_EVENT_ID,
122 RPAD(IFNULL(NESTING_EVENT_TYPE, 'NULL'), 18, ' ') NESTING_EVENT_TYPE,
123 '<transaction started>' AS SQL_TXT
124 FROM performance_schema.events_transactions_history_long t
125 WHERE (t.thread_id = @con1_thread_id)
126 UNION
127 SELECT THREAD_ID,
128 LPAD(EVENT_ID - @base_event_id, 11, ' ') as R_EVENT_ID,
129 LPAD(END_EVENT_ID - @base_event_id, 11, ' ') as R_END_EVENT_ID,
130 RPAD(EVENT_NAME, 25, ' ') 'EVENT_NAME ',
131 LPAD(IFNULL(NESTING_EVENT_ID - @base_event_id, 'NULL'), 19, ' ') as R_NESTING_EVENT_ID,
132 RPAD(IFNULL(NESTING_EVENT_TYPE, 'NULL'), 18, ' ') NESTING_EVENT_TYPE,
133 SQL_TEXT
134 FROM performance_schema.events_statements_history_long s
135 WHERE ((s.thread_id = @con1_thread_id) OR (@all_threads = 1))
136 ORDER BY thread_id, r_event_id;
137
138 --echo
139 --echo ## Clear statement and transaction history
140 --echo CALL test.clear_history();
141 CALL test.clear_history();
142 --enable_query_log
143 --echo ## Reset db.t1
144 DELETE FROM db.t1;
145 --echo