UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "wait/synch/%"; SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'performance_schema' AND COLUMN_NAME LIKE '%SCHEMA%' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLLATION_NAME performance_schema data_locks OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_statements_current CURRENT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_statements_current OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_statements_histogram_by_digest SCHEMA_NAME utf8mb4_0900_ai_ci performance_schema events_statements_history CURRENT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_statements_history OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_statements_history_long CURRENT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_statements_history_long OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_statements_summary_by_digest SCHEMA_NAME utf8mb4_0900_ai_ci performance_schema events_statements_summary_by_program OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_waits_current OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_waits_history OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema events_waits_history_long OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema metadata_locks OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema objects_summary_global_by_type OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema prepared_statements_instances OWNER_OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema setup_objects OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema table_handles OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema table_io_waits_summary_by_index_usage OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema table_io_waits_summary_by_table OBJECT_SCHEMA utf8mb4_0900_ai_ci performance_schema table_lock_waits_summary_by_table OBJECT_SCHEMA utf8mb4_0900_ai_ci SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'performance_schema' AND COLUMN_NAME LIKE '%OBJECT_NAME%' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLLATION_NAME performance_schema data_locks OBJECT_NAME utf8mb4_0900_ai_ci performance_schema events_statements_current OBJECT_NAME utf8mb4_0900_ai_ci performance_schema events_statements_history OBJECT_NAME utf8mb4_0900_ai_ci performance_schema events_statements_history_long OBJECT_NAME utf8mb4_0900_ai_ci performance_schema events_statements_summary_by_program OBJECT_NAME utf8mb4_0900_ai_ci performance_schema events_waits_current OBJECT_NAME utf8mb4_0900_ai_ci performance_schema events_waits_history OBJECT_NAME utf8mb4_0900_ai_ci performance_schema events_waits_history_long OBJECT_NAME utf8mb4_0900_ai_ci performance_schema metadata_locks OBJECT_NAME utf8mb4_0900_ai_ci performance_schema objects_summary_global_by_type OBJECT_NAME utf8mb4_0900_ai_ci performance_schema prepared_statements_instances OWNER_OBJECT_NAME utf8mb4_0900_ai_ci performance_schema setup_objects OBJECT_NAME utf8mb4_0900_ai_ci performance_schema table_handles OBJECT_NAME utf8mb4_0900_ai_ci performance_schema table_io_waits_summary_by_index_usage OBJECT_NAME utf8mb4_0900_ai_ci performance_schema table_io_waits_summary_by_table OBJECT_NAME utf8mb4_0900_ai_ci performance_schema table_lock_waits_summary_by_table OBJECT_NAME utf8mb4_0900_ai_ci SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'performance_schema' AND COLUMN_NAME LIKE '%COLUMN%' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLLATION_NAME performance_schema metadata_locks COLUMN_NAME utf8mb4_0900_ai_ci TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_statements_history_long; CREATE SCHEMA `BroKen`; CREATE SCHEMA `BroKén`; CREATE SCHEMA `bRŎKȩn`; CREATE SCHEMA `∀p∊ℙ`; SHOW DATABASES; Database broken brokén brŏkȩn information_schema mtr mysql performance_schema sys test ∀p∊ℙ use `∀p∊ℙ`; INSERT IGNORE INTO performance_schema.setup_objects VALUES ('TABLE', 'BroKen', '%', 'YES', 'YES'), ('TABLE', 'BroKén', '%', 'YES', 'YES'), ('TABLE', 'bRŎKȩn', '%', 'YES', 'YES'), ('TABLE', '∀p∊ℙ', '%', 'YES', 'YES'); "---------------------------------------------------------" SELECT * FROM performance_schema.setup_objects ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED EVENT % % YES YES EVENT information_schema % NO NO EVENT mysql % NO NO EVENT performance_schema % NO NO FUNCTION % % YES YES FUNCTION information_schema % NO NO FUNCTION mysql % NO NO FUNCTION performance_schema % NO NO PROCEDURE % % YES YES PROCEDURE information_schema % NO NO PROCEDURE mysql % NO NO PROCEDURE performance_schema % NO NO TABLE % % YES YES TABLE ∀p∊ℙ % YES YES TABLE broken % YES YES TABLE brokén % YES YES TABLE brŏkȩn % YES YES TABLE information_schema % NO NO TABLE mysql % NO NO TABLE performance_schema % NO NO TRIGGER % % YES YES TRIGGER information_schema % NO NO TRIGGER mysql % NO NO TRIGGER performance_schema % NO NO "---------------------------------------------------------" CREATE TABLE `∀p∊ℙ`.`torture`(a int); CREATE TABLE `BroKen`.`torture`(a int); CREATE TABLE `BroKén`.`torture`(a int); CREATE TABLE `bRŎKȩn`.`torture`(a int); BEGIN; SELECT * from `∀p∊ℙ`.`torture`; a SELECT * from `BroKen`.`torture`; a SELECT * from `BroKén`.`torture`; a SELECT * from `bRŎKȩn`.`torture`; a "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME FROM performance_schema.events_waits_history_long WHERE OBJECT_NAME = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME TABLE ∀p∊ℙ torture NULL wait/io/table/sql/handler TABLE ∀p∊ℙ torture NULL wait/lock/table/sql/handler TABLE broken torture NULL wait/io/table/sql/handler TABLE brokén torture NULL wait/io/table/sql/handler TABLE brŏkȩn torture NULL wait/io/table/sql/handler TABLE broken torture NULL wait/lock/table/sql/handler TABLE brokén torture NULL wait/lock/table/sql/handler TABLE brŏkȩn torture NULL wait/lock/table/sql/handler "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA FROM performance_schema.events_statements_history_long WHERE OBJECT_NAME = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS FROM performance_schema.metadata_locks WHERE OBJECT_NAME = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS TABLE ∀p∊ℙ torture SHARED_READ TRANSACTION GRANTED TABLE broken torture SHARED_READ TRANSACTION GRANTED TABLE brokén torture SHARED_READ TRANSACTION GRANTED TABLE brŏkȩn torture SHARED_READ TRANSACTION GRANTED "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_lock_waits_summary_by_table WHERE OBJECT_NAME = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE ∀p∊ℙ torture TABLE broken torture TABLE brokén torture TABLE brŏkȩn torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_io_waits_summary_by_table WHERE OBJECT_NAME = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE ∀p∊ℙ torture TABLE broken torture TABLE brokén torture TABLE brŏkȩn torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_io_waits_summary_by_index_usage WHERE OBJECT_NAME = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE ∀p∊ℙ torture TABLE broken torture TABLE brokén torture TABLE brŏkȩn torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_handles WHERE OBJECT_NAME = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE ∀p∊ℙ torture TABLE broken torture TABLE brokén torture TABLE brŏkȩn torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.objects_summary_global_by_type WHERE OBJECT_NAME = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_SCHEMA USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE ∀p∊ℙ torture TABLE broken torture TABLE brokén torture TABLE brŏkȩn torture "---------------------------------------------------------" COMMIT; DELETE FROM performance_schema.setup_objects WHERE OBJECT_SCHEMA IN ('BroKen', 'BroKén', 'bRŎKȩn', '∀p∊ℙ'); DROP SCHEMA `BroKen`; DROP SCHEMA `BroKén`; DROP SCHEMA `bRŎKȩn`; DROP SCHEMA `∀p∊ℙ`; TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_statements_history_long; CREATE SCHEMA `torture`; use `torture`; INSERT IGNORE INTO performance_schema.setup_objects VALUES ('TABLE', 'torture', 'BroKen', 'YES', 'YES'), ('TABLE', 'torture', 'BroKén', 'YES', 'YES'), ('TABLE', 'torture', 'bRŎKȩn', 'YES', 'YES'), ('TABLE', 'torture', '∀p∊ℙ', 'YES', 'YES'); "---------------------------------------------------------" SELECT * FROM performance_schema.setup_objects ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED EVENT % % YES YES EVENT information_schema % NO NO EVENT mysql % NO NO EVENT performance_schema % NO NO FUNCTION % % YES YES FUNCTION information_schema % NO NO FUNCTION mysql % NO NO FUNCTION performance_schema % NO NO PROCEDURE % % YES YES PROCEDURE information_schema % NO NO PROCEDURE mysql % NO NO PROCEDURE performance_schema % NO NO TABLE % % YES YES TABLE information_schema % NO NO TABLE mysql % NO NO TABLE performance_schema % NO NO TABLE torture ∀p∊ℙ YES YES TABLE torture broken YES YES TABLE torture brokén YES YES TABLE torture brŏkȩn YES YES TRIGGER % % YES YES TRIGGER information_schema % NO NO TRIGGER mysql % NO NO TRIGGER performance_schema % NO NO "---------------------------------------------------------" CREATE TABLE `torture`.`∀p∊ℙ`(a int); CREATE TABLE `torture`.`BroKen`(a int); CREATE TABLE `torture`.`BroKén`(a int); CREATE TABLE `torture`.`bRŎKȩn`(a int); BEGIN; SELECT * from `torture`.`∀p∊ℙ`; a SELECT * from `torture`.`BroKen`; a SELECT * from `torture`.`BroKén`; a SELECT * from `torture`.`bRŎKȩn`; a "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME FROM performance_schema.events_waits_history_long WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME TABLE torture ∀p∊ℙ NULL wait/io/table/sql/handler TABLE torture ∀p∊ℙ NULL wait/lock/table/sql/handler TABLE torture broken NULL wait/io/table/sql/handler TABLE torture brokén NULL wait/io/table/sql/handler TABLE torture brŏkȩn NULL wait/io/table/sql/handler TABLE torture broken NULL wait/lock/table/sql/handler TABLE torture brokén NULL wait/lock/table/sql/handler TABLE torture brŏkȩn NULL wait/lock/table/sql/handler "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA FROM performance_schema.events_statements_history_long WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS FROM performance_schema.metadata_locks WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS SCHEMA torture NULL INTENTION_EXCLUSIVE TRANSACTION GRANTED TABLE torture ∀p∊ℙ SHARED_READ TRANSACTION GRANTED TABLE torture broken SHARED_READ TRANSACTION GRANTED TABLE torture brokén SHARED_READ TRANSACTION GRANTED TABLE torture brŏkȩn SHARED_READ TRANSACTION GRANTED "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_lock_waits_summary_by_table WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture ∀p∊ℙ TABLE torture broken TABLE torture brokén TABLE torture brŏkȩn "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_io_waits_summary_by_table WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture ∀p∊ℙ TABLE torture broken TABLE torture brokén TABLE torture brŏkȩn "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_io_waits_summary_by_index_usage WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture ∀p∊ℙ TABLE torture broken TABLE torture brokén TABLE torture brŏkȩn "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_handles WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture ∀p∊ℙ TABLE torture broken TABLE torture brokén TABLE torture brŏkȩn "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.objects_summary_global_by_type WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture ∀p∊ℙ TABLE torture broken TABLE torture brokén TABLE torture brŏkȩn "---------------------------------------------------------" COMMIT; DELETE FROM performance_schema.setup_objects WHERE OBJECT_NAME IN ('BroKen', 'BroKén', 'bRŎKȩn', '∀p∊ℙ'); DROP TABLE `torture`.`BroKen`; DROP TABLE `torture`.`BroKén`; DROP TABLE `torture`.`bRŎKȩn`; DROP TABLE `torture`.`∀p∊ℙ`; TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_statements_history_long; CREATE TABLE `torture`.`torture`( id int, `∀p∊ℙ` int, `BroKen` int, `BroKén` int, `bRŎKȩn` int, PRIMARY KEY (`id`), KEY (`∀p∊ℙ`), KEY (`BroKen`), KEY (`BroKén`), KEY (`bRŎKȩn`) ); BEGIN; INSERT INTO `torture`.`torture` VALUES (0, 1, 2, 3, 4); SELECT * from `torture`.`torture`; id ∀p∊ℙ BroKen BroKén bRŎKȩn 0 1 2 3 4 SELECT * from `torture`.`torture` USE INDEX (`∀p∊ℙ`) WHERE `∀p∊ℙ` = 1; id ∀p∊ℙ BroKen BroKén bRŎKȩn 0 1 2 3 4 SELECT * from `torture`.`torture` USE INDEX (`BroKen`) WHERE `BroKen` = 2; id ∀p∊ℙ BroKen BroKén bRŎKȩn 0 1 2 3 4 SELECT * from `torture`.`torture` USE INDEX (`BroKén`) WHERE `BroKén` = 3; id ∀p∊ℙ BroKen BroKén bRŎKȩn 0 1 2 3 4 SELECT * from `torture`.`torture` USE INDEX (`bRŎKȩn`) WHERE `bRŎKȩn` = 4; id ∀p∊ℙ BroKen BroKén bRŎKȩn 0 1 2 3 4 "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME FROM performance_schema.events_waits_history_long WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME, CONVERT(INDEX_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME TABLE torture torture NULL wait/io/table/sql/handler TABLE torture torture NULL wait/io/table/sql/handler TABLE torture torture ∀p∊ℙ wait/io/table/sql/handler TABLE torture torture BroKen wait/io/table/sql/handler TABLE torture torture BroKén wait/io/table/sql/handler TABLE torture torture bRŎKȩn wait/io/table/sql/handler TABLE torture torture PRIMARY wait/lock/table/sql/handler TABLE torture torture PRIMARY wait/lock/table/sql/handler TABLE torture torture PRIMARY wait/lock/table/sql/handler TABLE torture torture PRIMARY wait/lock/table/sql/handler TABLE torture torture PRIMARY wait/lock/table/sql/handler TABLE torture torture PRIMARY wait/lock/table/sql/handler "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA FROM performance_schema.events_statements_history_long WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS FROM performance_schema.metadata_locks WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS SCHEMA torture NULL INTENTION_EXCLUSIVE TRANSACTION GRANTED TABLE torture torture SHARED_WRITE TRANSACTION GRANTED "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_lock_waits_summary_by_table WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_io_waits_summary_by_table WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME FROM performance_schema.table_io_waits_summary_by_index_usage WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, CONVERT(INDEX_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME TABLE torture torture NULL TABLE torture torture ∀p∊ℙ TABLE torture torture BroKen TABLE torture torture BroKén TABLE torture torture bRŎKȩn TABLE torture torture PRIMARY "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_handles WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.objects_summary_global_by_type WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TABLE torture torture "---------------------------------------------------------" COMMIT; DROP TABLE `torture`.`torture`; TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_statements_history_long; CREATE PROCEDURE `torture`.`∀p∊ℙ`() BEGIN SELECT 1; END $$ CREATE PROCEDURE `torture`.`BroKen`() BEGIN SELECT 2; END $$ CREATE PROCEDURE `torture`.`BroKén`() BEGIN SELECT 3; END $$ ERROR 42000: PROCEDURE BroKén already exists CREATE PROCEDURE `torture`.`bRŎKȩn`() BEGIN SELECT 4; END $$ ERROR 42000: PROCEDURE bRŎKȩn already exists BEGIN; CALL `torture`.`∀p∊ℙ`; 1 1 CALL `torture`.`BroKen`; 2 2 CALL `torture`.`BroKén`; 2 2 CALL `torture`.`bRŎKȩn`; 2 2 "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME FROM performance_schema.events_waits_history_long WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA FROM performance_schema.events_statements_history_long WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA PROCEDURE torture ∀p∊ℙ statement/sp/stmt torture PROCEDURE torture BroKen statement/sp/stmt torture PROCEDURE torture BroKen statement/sp/stmt torture PROCEDURE torture BroKen statement/sp/stmt torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS FROM performance_schema.metadata_locks WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS PROCEDURE torture ∀p∊ℙ SHARED TRANSACTION GRANTED PROCEDURE torture BroKen SHARED TRANSACTION GRANTED "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_lock_waits_summary_by_table WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_io_waits_summary_by_table WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME FROM performance_schema.table_io_waits_summary_by_index_usage WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_handles WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.objects_summary_global_by_type WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME PROCEDURE torture ∀p∊ℙ PROCEDURE torture BroKen "---------------------------------------------------------" COMMIT; DROP PROCEDURE `torture`.`∀p∊ℙ`; DROP PROCEDURE `torture`.`BroKen`; DROP PROCEDURE `torture`.`BroKén`; ERROR 42000: PROCEDURE torture.BroKén does not exist DROP PROCEDURE `torture`.`bRŎKȩn`; ERROR 42000: PROCEDURE torture.bRŎKȩn does not exist TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_statements_history_long; CREATE FUNCTION `torture`.`∀p∊ℙ`() RETURNS INTEGER BEGIN RETURN 1; END $$ CREATE FUNCTION `torture`.`BroKen`() RETURNS INTEGER BEGIN RETURN 2; END $$ CREATE FUNCTION `torture`.`BroKén`() RETURNS INTEGER BEGIN RETURN 3; END $$ ERROR 42000: FUNCTION BroKén already exists CREATE FUNCTION `torture`.`bRŎKȩn`() RETURNS INTEGER BEGIN RETURN 4; END $$ ERROR 42000: FUNCTION bRŎKȩn already exists BEGIN; SELECT `torture`.`∀p∊ℙ`(); `torture`.`∀p∊ℙ`() 1 SELECT `torture`.`BroKen`(); `torture`.`BroKen`() 2 SELECT `torture`.`BroKén`(); `torture`.`BroKén`() 2 SELECT `torture`.`bRŎKȩn`(); `torture`.`bRŎKȩn`() 2 "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME FROM performance_schema.events_waits_history_long WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME, EVENT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME EVENT_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CURRENT_SCHEMA FROM performance_schema.events_statements_history_long WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, EVENT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME EVENT_NAME CURRENT_SCHEMA FUNCTION torture ∀p∊ℙ statement/sp/freturn torture FUNCTION torture BroKen statement/sp/freturn torture FUNCTION torture BroKen statement/sp/freturn torture FUNCTION torture BroKen statement/sp/freturn torture "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, LOCK_TYPE, LOCK_DURATION, LOCK_STATUS FROM performance_schema.metadata_locks WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS FUNCTION torture ∀p∊ℙ SHARED TRANSACTION GRANTED FUNCTION torture BroKen SHARED TRANSACTION GRANTED "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_lock_waits_summary_by_table WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_io_waits_summary_by_table WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME FROM performance_schema.table_io_waits_summary_by_index_usage WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.table_handles WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME "---------------------------------------------------------" SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.objects_summary_global_by_type WHERE OBJECT_SCHEMA = 'torture' ORDER BY OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, CONVERT(OBJECT_NAME USING 'utf8mb4') COLLATE utf8mb4_bin; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME FUNCTION torture ∀p∊ℙ FUNCTION torture BroKen "---------------------------------------------------------" COMMIT; DROP FUNCTION `torture`.`∀p∊ℙ`; DROP FUNCTION `torture`.`BroKen`; DROP FUNCTION `torture`.`BroKén`; ERROR 42000: FUNCTION torture.BroKén does not exist DROP FUNCTION `torture`.`bRŎKȩn`; ERROR 42000: FUNCTION torture.bRŎKȩn does not exist CREATE TABLE test.t1(a int); CREATE TRIGGER test.t1_bi_broken BEFORE INSERT ON test.t1 FOR EACH ROW BEGIN END; INSERT INTO test.t1 VALUES (1); SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_summary_by_program WHERE OBJECT_SCHEMA='test'; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME TRIGGER test t1_bi_broken DROP TRIGGER test.`t1_bi_brokén`; SELECT OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_summary_by_program WHERE OBJECT_SCHEMA='test'; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME DROP TABLE test.t1; DROP SCHEMA `torture`; UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "wait/synch/%";