Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 show databases;
4
5 select count(*) from performance_schema.performance_timers;
6 select count(*) from performance_schema.setup_consumers;
7 # wait/io/table/sql/handler is a native instrument
8 # wait/lock/table/sql/handler is a native instrument
9 # idle/io/socket is a native instrument
10 # wait/lock/metadata is a native instrument
11 select count(*) > 4 from performance_schema.setup_instruments;
12 select count(*) from performance_schema.setup_timers;
13
14 # Make sure we don't crash, no matter what the starting parameters are
15
16 --disable_result_log
17 select * from performance_schema.accounts;
18 select * from performance_schema.cond_instances;
19 select * from performance_schema.events_stages_current;
20 select * from performance_schema.events_stages_history;
21 select * from performance_schema.events_stages_history_long;
22 select * from performance_schema.events_stages_summary_by_account_by_event_name;
23 select * from performance_schema.events_stages_summary_by_host_by_event_name;
24 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
25 select * from performance_schema.events_stages_summary_by_user_by_event_name;
26 select * from performance_schema.events_stages_summary_global_by_event_name;
27 select * from performance_schema.events_statements_current;
28 select * from performance_schema.events_statements_history;
29 select * from performance_schema.events_statements_history_long;
30 select * from performance_schema.events_statements_summary_by_account_by_event_name;
31 select * from performance_schema.events_statements_summary_by_digest;
32 select * from performance_schema.events_statements_summary_by_host_by_event_name;
33 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
34 select * from performance_schema.events_statements_summary_by_user_by_event_name;
35 select * from performance_schema.events_statements_summary_global_by_event_name;
36 select * from performance_schema.events_transactions_current;
37 select * from performance_schema.events_transactions_history;
38 select * from performance_schema.events_transactions_history_long;
39 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
40 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
41 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
42 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
43 select * from performance_schema.events_transactions_summary_global_by_event_name;
44 select * from performance_schema.events_waits_current;
45 select * from performance_schema.events_waits_history;
46 select * from performance_schema.events_waits_history_long;
47 select * from performance_schema.events_waits_summary_by_account_by_event_name;
48 select * from performance_schema.events_waits_summary_by_host_by_event_name;
49 select * from performance_schema.events_waits_summary_by_instance;
50 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
51 select * from performance_schema.events_waits_summary_by_user_by_event_name;
52 select * from performance_schema.events_waits_summary_global_by_event_name;
53 select * from performance_schema.memory_summary_by_account_by_event_name;
54 select * from performance_schema.memory_summary_by_host_by_event_name;
55 select * from performance_schema.memory_summary_by_thread_by_event_name;
56 select * from performance_schema.memory_summary_by_user_by_event_name;
57 select * from performance_schema.memory_summary_global_by_event_name;
58 select * from performance_schema.file_instances;
59 select * from performance_schema.file_summary_by_event_name;
60 select * from performance_schema.file_summary_by_instance;
61 select * from performance_schema.host_cache;
62 select * from performance_schema.hosts;
63 select * from performance_schema.memory_summary_by_account_by_event_name;
64 select * from performance_schema.memory_summary_by_host_by_event_name;
65 select * from performance_schema.memory_summary_by_thread_by_event_name;
66 select * from performance_schema.memory_summary_by_user_by_event_name;
67 select * from performance_schema.memory_summary_global_by_event_name;
68 select * from performance_schema.metadata_locks;
69 select * from performance_schema.mutex_instances;
70 select * from performance_schema.objects_summary_global_by_type;
71 select * from performance_schema.performance_timers;
72 select * from performance_schema.rwlock_instances;
73 select * from performance_schema.session_account_connect_attrs;
74 select * from performance_schema.session_connect_attrs;
75 select * from performance_schema.setup_actors;
76 select * from performance_schema.setup_consumers;
77 select * from performance_schema.setup_instruments;
78 select * from performance_schema.setup_objects;
79 select * from performance_schema.setup_timers;
80 select * from performance_schema.socket_instances;
81 select * from performance_schema.socket_summary_by_instance;
82 select * from performance_schema.socket_summary_by_event_name;
83 select * from performance_schema.table_handles;
84 select * from performance_schema.table_io_waits_summary_by_index_usage;
85 select * from performance_schema.table_io_waits_summary_by_table;
86 select * from performance_schema.table_lock_waits_summary_by_table;
87 select * from performance_schema.threads;
88 select * from performance_schema.users;
89 select * from performance_schema.replication_connection_configuration;
90 #select * from performance_schema.replication_connection_status;
91 select * from performance_schema.replication_applier_configuration;
92 select * from performance_schema.replication_applier_status;
93 select * from performance_schema.replication_applier_status_by_coordinator;
94 #select * from performance_schema.replication_applier_status_by_worker;
95 select * from performance_schema.global_status;
96 select * from performance_schema.status_by_thread;
97 select * from performance_schema.status_by_user;
98 select * from performance_schema.status_by_host;
99 select * from performance_schema.status_by_account;
100 select * from performance_schema.session_status;
101 #select * from performance_schema.global_variables;
102 #select * from performance_schema.variables_by_thread;
103 #select * from performance_schema.session_variables;
104 --enable_result_log
105
106 # This has a stable output, printing the result:
107 show global variables like "performance_schema%";
108
109 # This has an unrepeatable output, it does depends too much on
110 # - the platform hardware (sizeof structures, padding)
111 # - the compiler used (sizeof(enum))
112 # - the platform header files (sizeof(size_t))
113 # - the code path in the server (what gets executed and instrumented
114 # at runtime)
115
116 --disable_result_log
117 show engine PERFORMANCE_SCHEMA status;
118 show global status like "performance_schema%";
119 --enable_result_log
120