Skip to content

Commit c5a90ef

Browse files
marcalffmarcalff
committed
WL#5259 PERFORMANCE SCHEMA HOST_CACHE
Work in progress
1 parent 7e3ba77 commit c5a90ef

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

43 files changed

+886
-234
lines changed

‎mysql-test/suite/perfschema/include/schema.inc‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -43,6 +43,7 @@ show create table events_waits_summary_global_by_event_name;
4343
show create table file_instances;
4444
show create table file_summary_by_event_name;
4545
show create table file_summary_by_instance;
46+
show create table host_cache;
4647
show create table mutex_instances;
4748
show create table objects_summary_global_by_type;
4849
show create table performance_timers;

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

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -47,6 +47,7 @@ select * from performance_schema.events_waits_summary_global_by_event_name;
4747
select * from performance_schema.file_instances;
4848
select * from performance_schema.file_summary_by_event_name;
4949
select * from performance_schema.file_summary_by_instance;
50+
select * from performance_schema.host_cache;
5051
select * from performance_schema.mutex_instances;
5152
select * from performance_schema.objects_summary_global_by_type;
5253
select * from performance_schema.performance_timers;

‎mysql-test/suite/perfschema/r/information_schema.result‎

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -22,6 +22,7 @@ performance_schema events_waits_summary_global_by_event_name def
2222
performance_schema file_instances def
2323
performance_schema file_summary_by_event_name def
2424
performance_schema file_summary_by_instance def
25+
performance_schema host_cache def
2526
performance_schema mutex_instances def
2627
performance_schema objects_summary_global_by_type def
2728
performance_schema performance_timers def
@@ -59,6 +60,7 @@ events_waits_summary_global_by_event_name BASE TABLE PERFORMANCE_SCHEMA
5960
file_instances BASE TABLE PERFORMANCE_SCHEMA
6061
file_summary_by_event_name BASE TABLE PERFORMANCE_SCHEMA
6162
file_summary_by_instance BASE TABLE PERFORMANCE_SCHEMA
63+
host_cache BASE TABLE PERFORMANCE_SCHEMA
6264
mutex_instances BASE TABLE PERFORMANCE_SCHEMA
6365
objects_summary_global_by_type BASE TABLE PERFORMANCE_SCHEMA
6466
performance_timers BASE TABLE PERFORMANCE_SCHEMA
@@ -96,6 +98,7 @@ events_waits_summary_global_by_event_name 10 Dynamic
9698
file_instances 10 Dynamic
9799
file_summary_by_event_name 10 Dynamic
98100
file_summary_by_instance 10 Dynamic
101+
host_cache 10 Dynamic
99102
mutex_instances 10 Dynamic
100103
objects_summary_global_by_type 10 Dynamic
101104
performance_timers 10 Fixed
@@ -133,6 +136,7 @@ events_waits_summary_global_by_event_name 1000 0
133136
file_instances 1000 0
134137
file_summary_by_event_name 1000 0
135138
file_summary_by_instance 1000 0
139+
host_cache 1000 0
136140
mutex_instances 1000 0
137141
objects_summary_global_by_type 1000 0
138142
performance_timers 5 0
@@ -170,6 +174,7 @@ events_waits_summary_global_by_event_name 0 0
170174
file_instances 0 0
171175
file_summary_by_event_name 0 0
172176
file_summary_by_instance 0 0
177+
host_cache 0 0
173178
mutex_instances 0 0
174179
objects_summary_global_by_type 0 0
175180
performance_timers 0 0
@@ -207,6 +212,7 @@ events_waits_summary_global_by_event_name 0 0 NULL
207212
file_instances 0 0 NULL
208213
file_summary_by_event_name 0 0 NULL
209214
file_summary_by_instance 0 0 NULL
215+
host_cache 0 0 NULL
210216
mutex_instances 0 0 NULL
211217
objects_summary_global_by_type 0 0 NULL
212218
performance_timers 0 0 NULL
@@ -244,6 +250,7 @@ events_waits_summary_global_by_event_name NULL NULL NULL
244250
file_instances NULL NULL NULL
245251
file_summary_by_event_name NULL NULL NULL
246252
file_summary_by_instance NULL NULL NULL
253+
host_cache NULL NULL NULL
247254
mutex_instances NULL NULL NULL
248255
objects_summary_global_by_type NULL NULL NULL
249256
performance_timers NULL NULL NULL
@@ -281,6 +288,7 @@ events_waits_summary_global_by_event_name utf8_general_ci NULL
281288
file_instances utf8_general_ci NULL
282289
file_summary_by_event_name utf8_general_ci NULL
283290
file_summary_by_instance utf8_general_ci NULL
291+
host_cache utf8_general_ci NULL
284292
mutex_instances utf8_general_ci NULL
285293
objects_summary_global_by_type utf8_general_ci NULL
286294
performance_timers utf8_general_ci NULL
@@ -318,6 +326,7 @@ events_waits_summary_global_by_event_name
318326
file_instances
319327
file_summary_by_event_name
320328
file_summary_by_instance
329+
host_cache
321330
mutex_instances
322331
objects_summary_global_by_type
323332
performance_timers

‎mysql-test/suite/perfschema/r/pfs_upgrade.result‎

Lines changed: 125 additions & 120 deletions
Large diffs are not rendered by default.

‎mysql-test/suite/perfschema/r/schema.result‎

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -27,6 +27,7 @@ events_waits_summary_global_by_event_name
2727
file_instances
2828
file_summary_by_event_name
2929
file_summary_by_instance
30+
host_cache
3031
mutex_instances
3132
objects_summary_global_by_type
3233
performance_timers
@@ -412,6 +413,19 @@ file_summary_by_instance CREATE TABLE `file_summary_by_instance` (
412413
`SUM_NUMBER_OF_BYTES_READ` bigint(20) NOT NULL,
413414
`SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL
414415
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
416+
show create table host_cache;
417+
Table Create Table
418+
host_cache CREATE TABLE `host_cache` (
419+
`IP` varchar(64) NOT NULL,
420+
`HOST` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
421+
`SUM_BLOCKING_ERRORS` bigint(20) NOT NULL,
422+
`COUNT_NAMEINFO_ERRORS` bigint(20) NOT NULL,
423+
`COUNT_FORMAT_ERRORS` bigint(20) NOT NULL,
424+
`COUNT_ADDRINFO_ERRORS` bigint(20) NOT NULL,
425+
`COUNT_FCRDNS_ERRORS` bigint(20) NOT NULL,
426+
`COUNT_HOST_ACL_ERRORS` bigint(20) NOT NULL,
427+
`COUNT_USER_ACL_ERRORS` bigint(20) NOT NULL
428+
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
415429
show create table mutex_instances;
416430
Table Create Table
417431
mutex_instances CREATE TABLE `mutex_instances` (

‎mysql-test/suite/perfschema/r/start_server_innodb.result‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,7 @@ select * from performance_schema.events_waits_summary_global_by_event_name;
3737
select * from performance_schema.file_instances;
3838
select * from performance_schema.file_summary_by_event_name;
3939
select * from performance_schema.file_summary_by_instance;
40+
select * from performance_schema.host_cache;
4041
select * from performance_schema.mutex_instances;
4142
select * from performance_schema.objects_summary_global_by_type;
4243
select * from performance_schema.performance_timers;

‎mysql-test/suite/perfschema/r/start_server_no_cond_class.result‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,7 @@ select * from performance_schema.events_waits_summary_global_by_event_name;
3737
select * from performance_schema.file_instances;
3838
select * from performance_schema.file_summary_by_event_name;
3939
select * from performance_schema.file_summary_by_instance;
40+
select * from performance_schema.host_cache;
4041
select * from performance_schema.mutex_instances;
4142
select * from performance_schema.objects_summary_global_by_type;
4243
select * from performance_schema.performance_timers;

‎mysql-test/suite/perfschema/r/start_server_no_cond_inst.result‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,7 @@ select * from performance_schema.events_waits_summary_global_by_event_name;
3737
select * from performance_schema.file_instances;
3838
select * from performance_schema.file_summary_by_event_name;
3939
select * from performance_schema.file_summary_by_instance;
40+
select * from performance_schema.host_cache;
4041
select * from performance_schema.mutex_instances;
4142
select * from performance_schema.objects_summary_global_by_type;
4243
select * from performance_schema.performance_timers;

‎mysql-test/suite/perfschema/r/start_server_no_file_class.result‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,7 @@ select * from performance_schema.events_waits_summary_global_by_event_name;
3737
select * from performance_schema.file_instances;
3838
select * from performance_schema.file_summary_by_event_name;
3939
select * from performance_schema.file_summary_by_instance;
40+
select * from performance_schema.host_cache;
4041
select * from performance_schema.mutex_instances;
4142
select * from performance_schema.objects_summary_global_by_type;
4243
select * from performance_schema.performance_timers;

‎mysql-test/suite/perfschema/r/start_server_no_file_inst.result‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,7 @@ select * from performance_schema.events_waits_summary_global_by_event_name;
3737
select * from performance_schema.file_instances;
3838
select * from performance_schema.file_summary_by_event_name;
3939
select * from performance_schema.file_summary_by_instance;
40+
select * from performance_schema.host_cache;
4041
select * from performance_schema.mutex_instances;
4142
select * from performance_schema.objects_summary_global_by_type;
4243
select * from performance_schema.performance_timers;

0 commit comments

Comments
 (0)