MySQL Forums
Forum List  »  Performance

Re: Performance_schema_table_handles_lost is increasing
Posted by: Frederic Descamps
Date: September 10, 2021 04:49AM

Hi,

the _lost status are information about instrumentation that could not be loaded or created due to memory constraints see https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html

the table_handles table (documented here: https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-handles-table.html) contains lock_information.

To disable it, you need to run:

UPDATE performance_schema.setup_instruments
SET ENABLED = 'NO', TIMED = 'NO'
WHERE NAME = 'wait/lock/table/sql/handler';

regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Performance_schema_table_handles_lost is increasing
39
September 10, 2021 04:49AM


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.