-------------+ -- | variable_name | variable_value | -- +----------------------------------------+----------------+ -- | Performance_schema_file_handles_lost | 101223 | -- | Performance_schema_file_instances_lost | 1231 | -- +----------------------------------------+----------------+ -- CREATE OR REPLACE ALGORITHM = MERGE DEFINER = 'mysql.sys'@'localhost' SQL SECURITY INVOKER VIEW ps_check_lost_instrumentation ( variable_name, variable_value ) AS SELECT variable_name, variable_value FROM performance_schema.global_status WHERE variable_name LIKE 'perf%lost' AND variable_value > 0;