1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
# Tests for PERFORMANCE_SCHEMA
truncate performance_schema.status_by_account;
truncate performance_schema.status_by_host;
truncate performance_schema.status_by_user;
truncate performance_schema.status_by_thread;
let $get_thread_id=
SELECT thread_id INTO @my_thread_id
FROM performance_schema.threads
WHERE processlist_id = connection_id();
eval $get_thread_id;
CREATE USER user1@localhost;
GRANT ALL ON *.* to 'user1'@localhost;
connect(con1, localhost, user1,,);
--connection default
--replace_column 3 #
SELECT * FROM performance_schema.status_by_account WHERE user = 'user1' AND variable_name = 'Opened_tables';
--replace_column 3 #
SELECT * FROM performance_schema.status_by_host WHERE host = 'localhost' AND variable_name = 'Opened_tables';
--replace_column 3 #
SELECT * FROM performance_schema.status_by_user WHERE user = 'user1' AND variable_name = 'Opened_tables';
--replace_column 1 tid 3 #
SELECT * FROM performance_schema.status_by_thread WHERE thread_id = @my_thread_id AND variable_name = 'Opened_tables';
DROP USER user1@localhost;
--disconnect con1
|
