Debian Codegraph @

mysql-test/suite/perfschema/t/statement_program_nested.test

raw
1 # -----------------------------------------------------------------------
2 # Tests for the performance schema nested stored program instrumentation.
3 # -----------------------------------------------------------------------
4
5 --source include/not_embedded.inc
6 --source include/have_perfschema.inc
7 --source include/have_innodb.inc
8 --source include/not_msan_with_debug.inc
9
10 TRUNCATE TABLE performance_schema.events_statements_summary_by_program;
11 TRUNCATE TABLE performance_schema.events_statements_history_long;
12
13 --echo #################################################
14 --echo # Quering PS statement summary and history_long #
15 --echo #################################################
16
17 --source suite/perfschema/include/program_nested_setup.inc
18 ALTER TABLE t2 ENGINE=InnoDB;
19 --source suite/perfschema/include/program_nested_execution.inc
20
21 SELECT EVENT_NAME, SQL_TEXT, CURRENT_SCHEMA, OBJECT_TYPE, OBJECT_SCHEMA,
22 OBJECT_NAME, NESTING_EVENT_TYPE, NESTING_EVENT_LEVEL
23 FROM performance_schema.events_statements_history_long WHERE
24 CURRENT_SCHEMA='nested_sp' ORDER BY
25 OBJECT_NAME,NESTING_EVENT_LEVEL,SQL_TEXT,EVENT_NAME;
26
27 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_STATEMENTS
28 FROM performance_schema.events_statements_summary_by_program
29 WHERE OBJECT_SCHEMA='nested_sp' ORDER BY OBJECT_NAME;
30
31 --echo # clean-up
32 TRUNCATE TABLE performance_schema.events_statements_summary_by_program;
33 TRUNCATE TABLE performance_schema.events_statements_history_long;
34
35 # After truncate the statictics collected will are reset
36 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_STATEMENTS
37 FROM performance_schema.events_statements_summary_by_program
38 WHERE OBJECT_SCHEMA='nested_sp' ORDER BY OBJECT_NAME;
39
40 --source suite/perfschema/include/program_nested_cleanup.inc
41
42 # After clean-up the stored programs are removed from PS tables
43 SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_STATEMENTS
44 FROM performance_schema.events_statements_summary_by_program
45 WHERE OBJECT_SCHEMA='nested_sp' ORDER BY OBJECT_NAME;
46
47
48 # Check the intrumentation of stored programs
49 # when statement/sp/% instruments not timed
50
51 --source suite/perfschema/include/program_nested_setup.inc
52
53 update performance_schema.setup_instruments set enabled='YES', timed='NO'
54 where name like "statement/sp/%" order by name;
55
56 TRUNCATE TABLE performance_schema.events_statements_summary_by_program;
57 TRUNCATE TABLE performance_schema.events_statements_history_long;
58
59 --source suite/perfschema/include/program_nested_execution.inc
60
61 # check instrumentation
62
63 SELECT EVENT_NAME, TIMER_START, TIMER_END, TIMER_WAIT FROM
64 performance_schema.events_statements_history_long WHERE
65 CURRENT_SCHEMA='nested_sp' AND EVENT_NAME like "statement/sp/%";
66
67 # clean-up
68
69 # Restore the setup
70 update performance_schema.setup_instruments set enabled='YES', timed='YES'
71 where name like "statement/sp/%" order by name;
72
73 TRUNCATE TABLE performance_schema.events_statements_summary_by_program;
74 TRUNCATE TABLE performance_schema.events_statements_history_long;
75
76 --source suite/perfschema/include/program_nested_cleanup.inc