diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/schema.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/schema.result | 188 |
1 files changed, 94 insertions, 94 deletions
diff --git a/mysql-test/suite/perfschema/r/schema.result b/mysql-test/suite/perfschema/r/schema.result index 71bbf00bf72..548d58ab009 100644 --- a/mysql-test/suite/perfschema/r/schema.result +++ b/mysql-test/suite/perfschema/r/schema.result @@ -3,7 +3,7 @@ Database (performance_schema) performance_schema show create database performance_schema; Database Create Database -performance_schema CREATE DATABASE `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8 */ +performance_schema CREATE DATABASE `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ use performance_schema; show tables; Tables_in_performance_schema @@ -91,17 +91,17 @@ users show create table accounts; Table Create Table accounts CREATE TABLE `accounts` ( - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `CURRENT_CONNECTIONS` bigint(20) NOT NULL, `TOTAL_CONNECTIONS` bigint(20) NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table cond_instances; Table Create Table cond_instances CREATE TABLE `cond_instances` ( `NAME` varchar(128) NOT NULL, `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_stages_current; Table Create Table events_stages_current CREATE TABLE `events_stages_current` ( @@ -117,7 +117,7 @@ events_stages_current CREATE TABLE `events_stages_current` ( `WORK_ESTIMATED` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_stages_history; Table Create Table events_stages_history CREATE TABLE `events_stages_history` ( @@ -133,7 +133,7 @@ events_stages_history CREATE TABLE `events_stages_history` ( `WORK_ESTIMATED` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_stages_history_long; Table Create Table events_stages_history_long CREATE TABLE `events_stages_history_long` ( @@ -149,18 +149,18 @@ events_stages_history_long CREATE TABLE `events_stages_history_long` ( `WORK_ESTIMATED` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_stages_summary_by_host_by_event_name; Table Create Table events_stages_summary_by_host_by_event_name CREATE TABLE `events_stages_summary_by_host_by_event_name` ( - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_stages_summary_by_thread_by_event_name; Table Create Table events_stages_summary_by_thread_by_event_name CREATE TABLE `events_stages_summary_by_thread_by_event_name` ( @@ -171,30 +171,30 @@ events_stages_summary_by_thread_by_event_name CREATE TABLE `events_stages_summar `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_stages_summary_by_user_by_event_name; Table Create Table events_stages_summary_by_user_by_event_name CREATE TABLE `events_stages_summary_by_user_by_event_name` ( - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_stages_summary_by_account_by_event_name; Table Create Table events_stages_summary_by_account_by_event_name CREATE TABLE `events_stages_summary_by_account_by_event_name` ( - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_stages_summary_global_by_event_name; Table Create Table events_stages_summary_global_by_event_name CREATE TABLE `events_stages_summary_global_by_event_name` ( @@ -204,7 +204,7 @@ events_stages_summary_global_by_event_name CREATE TABLE `events_stages_summary_g `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_current; Table Create Table events_statements_current CREATE TABLE `events_statements_current` ( @@ -249,7 +249,7 @@ events_statements_current CREATE TABLE `events_statements_current` ( `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_history; Table Create Table events_statements_history CREATE TABLE `events_statements_history` ( @@ -294,7 +294,7 @@ events_statements_history CREATE TABLE `events_statements_history` ( `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_history_long; Table Create Table events_statements_history_long CREATE TABLE `events_statements_history_long` ( @@ -339,7 +339,7 @@ events_statements_history_long CREATE TABLE `events_statements_history_long` ( `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_summary_by_digest; Table Create Table events_statements_summary_by_digest CREATE TABLE `events_statements_summary_by_digest` ( @@ -372,11 +372,11 @@ events_statements_summary_by_digest CREATE TABLE `events_statements_summary_by_d `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL, `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_summary_by_host_by_event_name; Table Create Table events_statements_summary_by_host_by_event_name CREATE TABLE `events_statements_summary_by_host_by_event_name` ( - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -402,7 +402,7 @@ events_statements_summary_by_host_by_event_name CREATE TABLE `events_statements_ `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_summary_by_thread_by_event_name; Table Create Table events_statements_summary_by_thread_by_event_name CREATE TABLE `events_statements_summary_by_thread_by_event_name` ( @@ -432,11 +432,11 @@ events_statements_summary_by_thread_by_event_name CREATE TABLE `events_statement `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_summary_by_user_by_event_name; Table Create Table events_statements_summary_by_user_by_event_name CREATE TABLE `events_statements_summary_by_user_by_event_name` ( - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -462,12 +462,12 @@ events_statements_summary_by_user_by_event_name CREATE TABLE `events_statements_ `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_summary_by_account_by_event_name; Table Create Table events_statements_summary_by_account_by_event_name CREATE TABLE `events_statements_summary_by_account_by_event_name` ( - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -493,7 +493,7 @@ events_statements_summary_by_account_by_event_name CREATE TABLE `events_statemen `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_statements_summary_global_by_event_name; Table Create Table events_statements_summary_global_by_event_name CREATE TABLE `events_statements_summary_global_by_event_name` ( @@ -522,7 +522,7 @@ events_statements_summary_global_by_event_name CREATE TABLE `events_statements_s `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_transactions_current; Table Create Table events_transactions_current CREATE TABLE `events_transactions_current` ( @@ -550,7 +550,7 @@ events_transactions_current CREATE TABLE `events_transactions_current` ( `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_transactions_history; Table Create Table events_transactions_history CREATE TABLE `events_transactions_history` ( @@ -578,7 +578,7 @@ events_transactions_history CREATE TABLE `events_transactions_history` ( `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_transactions_history_long; Table Create Table events_transactions_history_long CREATE TABLE `events_transactions_history_long` ( @@ -606,11 +606,11 @@ events_transactions_history_long CREATE TABLE `events_transactions_history_long` `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_transactions_summary_by_host_by_event_name; Table Create Table events_transactions_summary_by_host_by_event_name CREATE TABLE `events_transactions_summary_by_host_by_event_name` ( - `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -627,7 +627,7 @@ events_transactions_summary_by_host_by_event_name CREATE TABLE `events_transacti `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_transactions_summary_by_thread_by_event_name; Table Create Table events_transactions_summary_by_thread_by_event_name CREATE TABLE `events_transactions_summary_by_thread_by_event_name` ( @@ -648,11 +648,11 @@ events_transactions_summary_by_thread_by_event_name CREATE TABLE `events_transac `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_transactions_summary_by_user_by_event_name; Table Create Table events_transactions_summary_by_user_by_event_name CREATE TABLE `events_transactions_summary_by_user_by_event_name` ( - `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -669,12 +669,12 @@ events_transactions_summary_by_user_by_event_name CREATE TABLE `events_transacti `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_transactions_summary_by_account_by_event_name; Table Create Table events_transactions_summary_by_account_by_event_name CREATE TABLE `events_transactions_summary_by_account_by_event_name` ( - `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, + `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, @@ -691,7 +691,7 @@ events_transactions_summary_by_account_by_event_name CREATE TABLE `events_transa `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_transactions_summary_global_by_event_name; Table Create Table events_transactions_summary_global_by_event_name CREATE TABLE `events_transactions_summary_global_by_event_name` ( @@ -711,7 +711,7 @@ events_transactions_summary_global_by_event_name CREATE TABLE `events_transactio `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL, `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_current; Table Create Table events_waits_current CREATE TABLE `events_waits_current` ( @@ -734,7 +734,7 @@ events_waits_current CREATE TABLE `events_waits_current` ( `OPERATION` varchar(32) NOT NULL, `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, `FLAGS` int(10) unsigned DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_history; Table Create Table events_waits_history CREATE TABLE `events_waits_history` ( @@ -757,7 +757,7 @@ events_waits_history CREATE TABLE `events_waits_history` ( `OPERATION` varchar(32) NOT NULL, `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, `FLAGS` int(10) unsigned DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_history_long; Table Create Table events_waits_history_long CREATE TABLE `events_waits_history_long` ( @@ -780,18 +780,18 @@ events_waits_history_long CREATE TABLE `events_waits_history_long` ( `OPERATION` varchar(32) NOT NULL, `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, `FLAGS` int(10) unsigned DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_summary_by_host_by_event_name; Table Create Table events_waits_summary_by_host_by_event_name CREATE TABLE `events_waits_summary_by_host_by_event_name` ( - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_summary_by_instance; Table Create Table events_waits_summary_by_instance CREATE TABLE `events_waits_summary_by_instance` ( @@ -802,7 +802,7 @@ events_waits_summary_by_instance CREATE TABLE `events_waits_summary_by_instance` `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_summary_by_thread_by_event_name; Table Create Table events_waits_summary_by_thread_by_event_name CREATE TABLE `events_waits_summary_by_thread_by_event_name` ( @@ -813,30 +813,30 @@ events_waits_summary_by_thread_by_event_name CREATE TABLE `events_waits_summary_ `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_summary_by_user_by_event_name; Table Create Table events_waits_summary_by_user_by_event_name CREATE TABLE `events_waits_summary_by_user_by_event_name` ( - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_summary_by_account_by_event_name; Table Create Table events_waits_summary_by_account_by_event_name CREATE TABLE `events_waits_summary_by_account_by_event_name` ( - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_STAR` bigint(20) unsigned NOT NULL, `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table events_waits_summary_global_by_event_name; Table Create Table events_waits_summary_global_by_event_name CREATE TABLE `events_waits_summary_global_by_event_name` ( @@ -846,11 +846,11 @@ events_waits_summary_global_by_event_name CREATE TABLE `events_waits_summary_glo `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table memory_summary_by_host_by_event_name; Table Create Table memory_summary_by_host_by_event_name CREATE TABLE `memory_summary_by_host_by_event_name` ( - `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_ALLOC` bigint(20) unsigned NOT NULL, `COUNT_FREE` bigint(20) unsigned NOT NULL, @@ -862,7 +862,7 @@ memory_summary_by_host_by_event_name CREATE TABLE `memory_summary_by_host_by_eve `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table memory_summary_by_thread_by_event_name; Table Create Table memory_summary_by_thread_by_event_name CREATE TABLE `memory_summary_by_thread_by_event_name` ( @@ -878,11 +878,11 @@ memory_summary_by_thread_by_event_name CREATE TABLE `memory_summary_by_thread_by `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table memory_summary_by_user_by_event_name; Table Create Table memory_summary_by_user_by_event_name CREATE TABLE `memory_summary_by_user_by_event_name` ( - `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_ALLOC` bigint(20) unsigned NOT NULL, `COUNT_FREE` bigint(20) unsigned NOT NULL, @@ -894,12 +894,12 @@ memory_summary_by_user_by_event_name CREATE TABLE `memory_summary_by_user_by_eve `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table memory_summary_by_account_by_event_name; Table Create Table memory_summary_by_account_by_event_name CREATE TABLE `memory_summary_by_account_by_event_name` ( - `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, + `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `COUNT_ALLOC` bigint(20) unsigned NOT NULL, `COUNT_FREE` bigint(20) unsigned NOT NULL, @@ -911,7 +911,7 @@ memory_summary_by_account_by_event_name CREATE TABLE `memory_summary_by_account_ `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table memory_summary_global_by_event_name; Table Create Table memory_summary_global_by_event_name CREATE TABLE `memory_summary_global_by_event_name` ( @@ -926,7 +926,7 @@ memory_summary_global_by_event_name CREATE TABLE `memory_summary_global_by_event `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL, `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table metadata_locks; Table Create Table metadata_locks CREATE TABLE `metadata_locks` ( @@ -940,14 +940,14 @@ metadata_locks CREATE TABLE `metadata_locks` ( `SOURCE` varchar(64) DEFAULT NULL, `OWNER_THREAD_ID` bigint(20) unsigned DEFAULT NULL, `OWNER_EVENT_ID` bigint(20) unsigned DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table file_instances; Table Create Table file_instances CREATE TABLE `file_instances` ( `FILE_NAME` varchar(512) NOT NULL, `EVENT_NAME` varchar(128) NOT NULL, `OPEN_COUNT` int(10) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table file_summary_by_event_name; Table Create Table file_summary_by_event_name CREATE TABLE `file_summary_by_event_name` ( @@ -974,7 +974,7 @@ file_summary_by_event_name CREATE TABLE `file_summary_by_event_name` ( `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table file_summary_by_instance; Table Create Table file_summary_by_instance CREATE TABLE `file_summary_by_instance` ( @@ -1003,12 +1003,12 @@ file_summary_by_instance CREATE TABLE `file_summary_by_instance` ( `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table host_cache; Table Create Table host_cache CREATE TABLE `host_cache` ( `IP` varchar(64) NOT NULL, - `HOST` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `HOST_VALIDATED` enum('YES','NO') NOT NULL, `SUM_CONNECT_ERRORS` bigint(20) NOT NULL, `COUNT_HOST_BLOCKED_ERRORS` bigint(20) NOT NULL, @@ -1036,21 +1036,21 @@ host_cache CREATE TABLE `host_cache` ( `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `FIRST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00', `LAST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table hosts; Table Create Table hosts CREATE TABLE `hosts` ( - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `CURRENT_CONNECTIONS` bigint(20) NOT NULL, `TOTAL_CONNECTIONS` bigint(20) NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table mutex_instances; Table Create Table mutex_instances CREATE TABLE `mutex_instances` ( `NAME` varchar(128) NOT NULL, `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, `LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table objects_summary_global_by_type; Table Create Table objects_summary_global_by_type CREATE TABLE `objects_summary_global_by_type` ( @@ -1062,7 +1062,7 @@ objects_summary_global_by_type CREATE TABLE `objects_summary_global_by_type` ( `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table performance_timers; Table Create Table performance_timers CREATE TABLE `performance_timers` ( @@ -1070,7 +1070,7 @@ performance_timers CREATE TABLE `performance_timers` ( `TIMER_FREQUENCY` bigint(20) DEFAULT NULL, `TIMER_RESOLUTION` bigint(20) DEFAULT NULL, `TIMER_OVERHEAD` bigint(20) DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table rwlock_instances; Table Create Table rwlock_instances CREATE TABLE `rwlock_instances` ( @@ -1078,29 +1078,29 @@ rwlock_instances CREATE TABLE `rwlock_instances` ( `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, `WRITE_LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL, `READ_LOCKED_BY_COUNT` int(10) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table setup_actors; Table Create Table setup_actors CREATE TABLE `setup_actors` ( - `HOST` char(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', - `ROLE` char(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', + `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '%', + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '%', + `ROLE` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '%', `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES', `HISTORY` enum('YES','NO') NOT NULL DEFAULT 'YES' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table setup_consumers; Table Create Table setup_consumers CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table setup_instruments; Table Create Table setup_instruments CREATE TABLE `setup_instruments` ( `NAME` varchar(128) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL, `TIMED` enum('YES','NO') NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table setup_objects; Table Create Table setup_objects CREATE TABLE `setup_objects` ( @@ -1109,13 +1109,13 @@ setup_objects CREATE TABLE `setup_objects` ( `OBJECT_NAME` varchar(64) NOT NULL DEFAULT '%', `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES', `TIMED` enum('YES','NO') NOT NULL DEFAULT 'YES' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table setup_timers; Table Create Table setup_timers CREATE TABLE `setup_timers` ( `NAME` varchar(64) NOT NULL, `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table socket_instances; Table Create Table socket_instances CREATE TABLE `socket_instances` ( @@ -1126,7 +1126,7 @@ socket_instances CREATE TABLE `socket_instances` ( `IP` varchar(64) NOT NULL, `PORT` int(11) NOT NULL, `STATE` enum('IDLE','ACTIVE') NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table socket_summary_by_instance; Table Create Table socket_summary_by_instance CREATE TABLE `socket_summary_by_instance` ( @@ -1154,7 +1154,7 @@ socket_summary_by_instance CREATE TABLE `socket_summary_by_instance` ( `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table socket_summary_by_event_name; Table Create Table socket_summary_by_event_name CREATE TABLE `socket_summary_by_event_name` ( @@ -1181,7 +1181,7 @@ socket_summary_by_event_name CREATE TABLE `socket_summary_by_event_name` ( `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table table_handles; Table Create Table table_handles CREATE TABLE `table_handles` ( @@ -1193,7 +1193,7 @@ table_handles CREATE TABLE `table_handles` ( `OWNER_EVENT_ID` bigint(20) unsigned DEFAULT NULL, `INTERNAL_LOCK` varchar(64) DEFAULT NULL, `EXTERNAL_LOCK` varchar(64) DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table table_io_waits_summary_by_index_usage; Table Create Table table_io_waits_summary_by_index_usage CREATE TABLE `table_io_waits_summary_by_index_usage` ( @@ -1236,7 +1236,7 @@ table_io_waits_summary_by_index_usage CREATE TABLE `table_io_waits_summary_by_in `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL, `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL, `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table table_io_waits_summary_by_table; Table Create Table table_io_waits_summary_by_table CREATE TABLE `table_io_waits_summary_by_table` ( @@ -1278,7 +1278,7 @@ table_io_waits_summary_by_table CREATE TABLE `table_io_waits_summary_by_table` ( `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL, `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL, `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table table_lock_waits_summary_by_table; Table Create Table table_lock_waits_summary_by_table CREATE TABLE `table_lock_waits_summary_by_table` ( @@ -1355,7 +1355,7 @@ table_lock_waits_summary_by_table CREATE TABLE `table_lock_waits_summary_by_tabl `MIN_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL, `AVG_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL, `MAX_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table threads; Table Create Table threads CREATE TABLE `threads` ( @@ -1376,11 +1376,11 @@ threads CREATE TABLE `threads` ( `HISTORY` enum('YES','NO') NOT NULL, `CONNECTION_TYPE` varchar(16) DEFAULT NULL, `THREAD_OS_ID` bigint(20) unsigned DEFAULT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 show create table users; Table Create Table users CREATE TABLE `users` ( - `USER` char(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, + `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL, `CURRENT_CONNECTIONS` bigint(20) NOT NULL, `TOTAL_CONNECTIONS` bigint(20) NOT NULL -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 |