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