Debian Codegraph @

mysql-test/suite/x/t/performance_schema_memory.test

raw
1 ## Tests detecting presence of xplugin objects in PERFORMANCE_SCHEMA memory related tables.
2
3 ## Preamble
4 --source ../include/have_performance_schema_threads.inc
5 --source include/xplugin_preamble.inc
6 --source include/xplugin_create_user.inc
7
8 # Tests
9
10 --write_file $MYSQL_TMP_DIR/performance_schema_memory.xpl
11 -->quiet
12
13 -->echo See for existence of required events in the tables
14
15 -->macro Read_status_values %TABLE% %EVENT% %VAR_SET_NO%
16 -->sql
17 SET
18 @MY_COUNT_ALLOC%VAR_SET_NO% = (SELECT SUM(COUNT_ALLOC) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
19 @MY_COUNT_FREE%VAR_SET_NO% = (SELECT SUM(COUNT_FREE) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
20 @MY_SUM_NUMBER_OF_BYTES_ALLOC%VAR_SET_NO% = (SELECT SUM(SUM_NUMBER_OF_BYTES_ALLOC) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
21 @MY_SUM_NUMBER_OF_BYTES_FREE%VAR_SET_NO% = (SELECT SUM(SUM_NUMBER_OF_BYTES_FREE) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
22 @MY_LOW_COUNT_USED%VAR_SET_NO% = (SELECT SUM(LOW_COUNT_USED) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
23 @MY_CURRENT_COUNT_USED%VAR_SET_NO% = (SELECT SUM(CURRENT_COUNT_USED) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
24 @MY_HIGH_COUNT_USED%VAR_SET_NO% = (SELECT SUM(HIGH_COUNT_USED) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
25 @MY_LOW_NUMBER_OF_BYTES_USED%VAR_SET_NO% = (SELECT SUM(LOW_NUMBER_OF_BYTES_USED) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
26 @MY_CURRENT_NUMBER_OF_BYTES_USED%VAR_SET_NO% = (SELECT SUM(CURRENT_NUMBER_OF_BYTES_USED) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%'),
27 @MY_HIGH_NUMBER_OF_BYTES_USED%VAR_SET_NO% = (SELECT SUM(HIGH_NUMBER_OF_BYTES_USED) FROM performance_schema.%TABLE% where EVENT_NAME = 'memory/mysqlx/%EVENT%');
28 -->endsql
29 -->endmacro
30
31 -->sql
32 select distinct event_name from performance_schema.memory_summary_global_by_event_name where event_name like '%mysqlx%' order by event_name;
33 -->endsql
34
35
36 -->echo memory_summary_global_by_event_name 'memory/mysqlx/objects'
37
38 -->sql
39 TRUNCATE TABLE performance_schema.memory_summary_global_by_event_name;
40 -->endsql
41
42 -->callmacro Read_status_values memory_summary_global_by_event_name objects 1
43
44 -->sql
45 SELECT IF(@MY_COUNT_ALLOC1 > 0, "SUCCESS", "ERROR");
46 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_ALLOC1 > 0, "SUCCESS", "ERROR");
47 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 > 0, "SUCCESS", "ERROR");
48 SELECT IF(@MY_HIGH_NUMBER_OF_BYTES_USED1 > 0, "SUCCESS", "ERROR");
49 SELECT IF(@MY_COUNT_ALLOC1 >= @MY_COUNT_FREE1, "SUCCESS", "ERROR");
50 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_ALLOC1 >= @MY_SUM_NUMBER_OF_BYTES_FREE1, "SUCCESS", "ERROR");
51 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 <= @MY_HIGH_NUMBER_OF_BYTES_USED1, "SUCCESS", "ERROR");
52 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 >= @MY_LOW_NUMBER_OF_BYTES_USED1, "SUCCESS", "ERROR");
53 -->endsql
54
55 -->echo second query, more allocations and memory used expected
56
57 -->callmacro Read_status_values memory_summary_global_by_event_name objects 2
58
59 -->sql
60 SELECT IF(@MY_COUNT_ALLOC2 >= @MY_COUNT_FREE2, "SUCCESS", "ERROR");
61 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_ALLOC2 >= @MY_SUM_NUMBER_OF_BYTES_FREE2, "SUCCESS", "ERROR");
62 SELECT IF(@MY_COUNT_ALLOC2 >= @MY_COUNT_ALLOC1, "SUCCESS", "ERROR");
63 SELECT IF(@MY_COUNT_FREE2 >= @MY_COUNT_FREE1, "SUCCESS", "ERROR");
64 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_ALLOC2 >= @MY_SUM_NUMBER_OF_BYTES_ALLOC1, "SUCCESS", "ERROR");
65 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_FREE2 >= @MY_SUM_NUMBER_OF_BYTES_FREE1, "SUCCESS", "ERROR");
66 SELECT IF(@MY_HIGH_NUMBER_OF_BYTES_USED2 >= @MY_HIGH_NUMBER_OF_BYTES_USED1, "SUCCESS", "ERROR");
67 -->endsql
68
69 -->echo memory_summary_global_by_event_name 'memory/mysqlx/recv_buffer'
70
71 -->sql
72 TRUNCATE TABLE performance_schema.memory_summary_global_by_event_name;
73 -->endsql
74
75 -->callmacro Read_status_values memory_summary_global_by_event_name recv_buffer 1
76
77 -->sql
78 SELECT IF(@MY_COUNT_ALLOC1 > 0, "SUCCESS", "ERROR");
79 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_ALLOC1 > 0, "SUCCESS", "ERROR");
80 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 > 0, "SUCCESS", "ERROR");
81 SELECT IF(@MY_HIGH_NUMBER_OF_BYTES_USED1 > 0, "SUCCESS", "ERROR");
82 SELECT IF(@MY_COUNT_ALLOC1 >= @MY_COUNT_FREE1, "SUCCESS", "ERROR");
83 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_ALLOC1 >= @MY_SUM_NUMBER_OF_BYTES_FREE1, "SUCCESS", "ERROR");
84 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 <= @MY_HIGH_NUMBER_OF_BYTES_USED1, "SUCCESS", "ERROR");
85 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 >= @MY_LOW_NUMBER_OF_BYTES_USED1, "SUCCESS", "ERROR");
86 -->endsql
87
88 -->echo memory_summary_global_by_event_name 'memory/mysqlx/send_buffer'
89
90 -->sql
91 TRUNCATE TABLE performance_schema.memory_summary_global_by_event_name;
92 -->endsql
93
94 -->callmacro Read_status_values memory_summary_global_by_event_name send_buffer 1
95
96 -->sql
97 SELECT IF(@MY_COUNT_ALLOC1 > 0, "SUCCESS", "ERROR");
98 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_ALLOC1 > 0, "SUCCESS", "ERROR");
99 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 > 0, "SUCCESS", "ERROR");
100 SELECT IF(@MY_HIGH_NUMBER_OF_BYTES_USED1 > 0, "SUCCESS", "ERROR");
101 SELECT IF(@MY_COUNT_ALLOC1 >= @MY_COUNT_FREE1, "SUCCESS", "ERROR");
102 SELECT IF(@MY_SUM_NUMBER_OF_BYTES_ALLOC1 >= @MY_SUM_NUMBER_OF_BYTES_FREE1, "SUCCESS", "ERROR");
103 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 <= @MY_HIGH_NUMBER_OF_BYTES_USED1, "SUCCESS", "ERROR");
104 SELECT IF(@MY_CURRENT_NUMBER_OF_BYTES_USED1 >= @MY_LOW_NUMBER_OF_BYTES_USED1, "SUCCESS", "ERROR");
105 -->endsql
106 EOF
107
108
109 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/performance_schema_memory.xpl 2>&1
110
111 ## Cleanup
112 --source ../include/xplugin_cleanup.inc