MySQL Forums
Forum List  »  Performance

Performance_schema_table_handles_lost is increasing
Posted by: jongse park
Date: September 08, 2021 06:02PM

Hi all

I wonder that Performance_schema_table_handles_lost is getting increasing in mysql 5.7.


select * from sys.memory_global_by_current_bytes
where event_name like '%performance_schema%' and current_count > 0;
==>
event_name current_count current_alloc current_avg_alloc high_count high_alloc high_avg_alloc
memory/performance_schema/table_handles 1024 9.06GiB 9.06MiB 1024 9.06GiB 9.06MiB
...
...

memory/performance_schema/table_handles ==> current_alloc 9.06GiB

I have 160 tables in mysql 5.7.
variable:
table_definition_cache | 1400
table_open_cache | 2000
table_open_cache_instaces | 16
performance_schema_max_table_handles | -1

status:
performance_schema_table_handles_lost | 290679654 (increasing..)
performance_schema_table_instances_lost | 0

Can I reduce or tune memory/performance_schema/table_handles memory?
and performance_schema_table_handles_lost values?

How can I fix performance_schema_table_handles_lost values and memory using memory/performance_schema/table_handles?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Performance_schema_table_handles_lost is increasing
130
September 08, 2021 06:02PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.