Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5
6 # This test verifies that the mysys and server instruments are properly
7 # initialized and recorded by the performance schema during the bootstrap
8 # sequence in mysqld main().
9 # Note that some globals mutexes/rwlocks/conds that depend on #ifdef options
10 # or runtime options are not tested here, to have a predictable result.
11
12 use performance_schema;
13
14 # Verify that these global mutexes have been properly initilized in mysys
15
16 select count(name) from mutex_instances
17 where name like "wait/synch/mutex/mysys/THR_LOCK_malloc";
18
19 select count(name) from mutex_instances
20 where name like "wait/synch/mutex/mysys/THR_LOCK_open";
21
22 select count(name) from mutex_instances
23 where name like "wait/synch/mutex/mysys/THR_LOCK_myisam";
24
25 select count(name) from mutex_instances
26 where name like "wait/synch/mutex/mysys/THR_LOCK_heap";
27
28 select count(name) from mutex_instances
29 where name like "wait/synch/mutex/mysys/THR_LOCK_net";
30
31 select count(name) from mutex_instances
32 where name like "wait/synch/mutex/mysys/THR_LOCK_charset";
33
34 # There are no global rwlock in mysys
35
36 # There are no global conditions in mysys
37 # (THR_COND_threads is only present in debug builds
38
39 # Verify that these global mutexes have been properly initilized in sql
40
41 select count(name) from mutex_instances
42 where name like "wait/synch/mutex/sql/LOCK_thread_count";
43
44 select count(name) from mutex_instances
45 where name like "wait/synch/mutex/sql/LOCK_log_throttle_qni";
46
47 select count(name) from mutex_instances
48 where name like "wait/synch/mutex/sql/LOCK_status";
49
50 select count(name) from mutex_instances
51 where name like "wait/synch/mutex/sql/LOCK_uuid_generator";
52
53 select count(name) from mutex_instances
54 where name like "wait/synch/mutex/sql/LOCK_crypt";
55
56 select count(name) from mutex_instances
57 where name like "wait/synch/mutex/sql/LOCK_active_mi";
58
59 select count(name) from mutex_instances
60 where name like "wait/synch/mutex/sql/LOCK_manager";
61
62 select count(name) from mutex_instances
63 where name like "wait/synch/mutex/sql/LOCK_global_system_variables";
64
65 select count(name) from mutex_instances
66 where name like "wait/synch/mutex/sql/LOCK_user_conn";
67
68 select count(name) from mutex_instances
69 where name like "wait/synch/mutex/sql/LOCK_prepared_stmt_count";
70
71 select count(name) from mutex_instances
72 where name like "wait/synch/mutex/sql/LOCK_server_started";
73
74 # LOG_INFO object are created on demand, and are not global.
75 # select count(name) from mutex_instances
76 # where name like "wait/synch/mutex/sql/LOG_INFO::lock";
77
78 select count(name) from mutex_instances
79 where name like "wait/synch/mutex/sql/Query_cache::structure_guard_mutex";
80
81 # The event scheduler may be disabled
82 # select count(name) from mutex_instances
83 # where name like "wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state";
84
85 select count(name) from mutex_instances
86 where name like "wait/synch/mutex/sql/LOCK_event_queue";
87
88 select count(name) from mutex_instances
89 where name like "wait/synch/mutex/sql/LOCK_item_func_sleep";
90
91 select count(name) from mutex_instances
92 where name like "wait/synch/mutex/sql/LOCK_audit_mask";
93
94 select count(name) from mutex_instances
95 where name like "wait/synch/mutex/sql/LOCK_plugin";
96
97 # Not a global variable, may be destroyed already.
98 # select count(name) from mutex_instances
99 # where name like "wait/synch/mutex/sql/LOCK_gdl";
100
101 select count(name) from mutex_instances
102 where name like "wait/synch/mutex/sql/tz_LOCK";
103
104 # Verify that these global rwlocks have been properly initilized in sql
105
106 select count(name) from rwlock_instances
107 where name like "wait/synch/rwlock/sql/LOCK_sys_init_connect";
108
109 select count(name) from rwlock_instances
110 where name like "wait/synch/rwlock/sql/LOCK_sys_init_slave";
111
112 select count(name) from rwlock_instances
113 where name like "wait/synch/rwlock/sql/LOCK_system_variables_hash";
114
115 # Verify that these global conditions have been properly initilized in sql
116
117 select count(name) from cond_instances
118 where name like "wait/synch/cond/sql/COND_server_started";
119
120 select count(name) from cond_instances
121 where name like "wait/synch/cond/sql/COND_refresh";
122
123 select count(name) from cond_instances
124 where name like "wait/synch/cond/sql/COND_thread_count";
125
126 select count(name) from cond_instances
127 where name like "wait/synch/cond/sql/COND_manager";
128
129 select count(name) from cond_instances
130 where name like "wait/synch/cond/sql/COND_thread_cache";
131
132 select count(name) from cond_instances
133 where name like "wait/synch/cond/sql/COND_flush_thread_cache";
134
135 select count(name) from cond_instances
136 where name like "wait/synch/cond/sql/Query_cache::COND_cache_status_changed";
137
138 # The event scheduler may be disabled
139 # select count(name) from cond_instances
140 # where name like "wait/synch/cond/sql/Event_scheduler::COND_state";
141
142 select count(name) from cond_instances
143 where name like "wait/synch/cond/sql/COND_queue_state";
144