Re: Performance_schema_table_handles_lost is increasing

[Frederic Descamps]

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,