diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/schema.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/schema.result | 132 |
1 files changed, 66 insertions, 66 deletions
diff --git a/mysql-test/suite/perfschema/r/schema.result b/mysql-test/suite/perfschema/r/schema.result index 76af311c564..b9e8f2a48e1 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 utf8mb3 */ +performance_schema CREATE DATABASE `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci */ use performance_schema; show tables; Tables_in_performance_schema @@ -95,13 +95,13 @@ accounts CREATE TABLE `accounts` ( `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'The connection client''s host name, or NULL if an internal thread.', `CURRENT_CONNECTIONS` bigint(20) NOT NULL COMMENT 'Current connections for the account.', `TOTAL_CONNECTIONS` bigint(20) NOT NULL COMMENT 'Total connections for the account.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table cond_instances; Table Create Table cond_instances CREATE TABLE `cond_instances` ( `NAME` varchar(128) NOT NULL COMMENT 'Client user name for the connection, or NULL if an internal thread.', `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL COMMENT 'Address in memory of the instrumented condition.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'The number of work units expected for the stage. NULL if the stage event progress is not instrumented.', `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'EVENT_ID of event within which this event nests.', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'Nesting event type. Either transaction, statement, stage or wait.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'The number of work units expected for the stage. NULL if the stage event progress is not instrumented.', `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'EVENT_ID of event within which this event nests.', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'Nesting event type. Either transaction, statement, stage or wait.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table events_stages_history_long; Table Create Table events_stages_history_long CREATE TABLE `events_stages_history_long` ( @@ -149,7 +149,7 @@ events_stages_history_long CREATE TABLE `events_stages_history_long` ( `WORK_ESTIMATED` bigint(20) unsigned DEFAULT NULL COMMENT 'The number of work units expected for the stage. NULL if the stage event progress is not instrumented.', `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'EVENT_ID of event within which this event nests.', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'Nesting event type. Either transaction, statement, stage or wait.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -160,7 +160,7 @@ events_stages_summary_by_host_by_event_name CREATE TABLE `events_stages_summary_ `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the timed summarized events.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the timed summarized events.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the timed summarized events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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,7 +171,7 @@ events_stages_summary_by_thread_by_event_name CREATE TABLE `events_stages_summar `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the timed summarized events.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the timed summarized events.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the timed summarized events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -182,7 +182,7 @@ events_stages_summary_by_user_by_event_name CREATE TABLE `events_stages_summary_ `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the timed summarized events.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the timed summarized events.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the timed summarized events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -194,7 +194,7 @@ events_stages_summary_by_account_by_event_name CREATE TABLE `events_stages_summa `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the timed summarized events.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the timed summarized events.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the timed summarized events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of the timed summarized events.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the timed summarized events.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the timed summarized events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'NULL for top level statements. The parent statement event id for nested statements (stored programs).', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'NULL for top level statements. The parent statement event type for nested statements (stored programs).', `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL COMMENT '0 for top level statements. The parent statement level plus 1 for nested statements (stored programs).' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'NULL for top level statements. The parent statement event id for nested statements (stored programs).', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'NULL for top level statements. The parent statement event type for nested statements (stored programs).', `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL COMMENT '0 for top level statements. The parent statement level plus 1 for nested statements (stored programs).' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'NULL for top level statements. The parent statement event id for nested statements (stored programs).', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'NULL for top level statements. The parent statement event type for nested statements (stored programs).', `NESTING_EVENT_LEVEL` int(11) DEFAULT NULL COMMENT '0 for top level statements. The parent statement level plus 1 for nested statements (stored programs).' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table events_statements_summary_by_digest; Table Create Table events_statements_summary_by_digest CREATE TABLE `events_statements_summary_by_digest` ( @@ -372,7 +372,7 @@ events_statements_summary_by_digest CREATE TABLE `events_statements_summary_by_d `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.', `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Time at which the digest was first seen.', `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Time at which the digest was most recently seen.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -402,7 +402,7 @@ events_statements_summary_by_host_by_event_name CREATE TABLE `events_statements_ `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL COMMENT 'Sum of the SORT_SCAN column in the events_statements_current table.', `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_INDEX_USED column in the events_statements_current table.', `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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,7 +432,7 @@ events_statements_summary_by_thread_by_event_name CREATE TABLE `events_statement `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL COMMENT 'Sum of the SORT_SCAN column in the events_statements_current table.', `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_INDEX_USED column in the events_statements_current table.', `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -462,7 +462,7 @@ events_statements_summary_by_user_by_event_name CREATE TABLE `events_statements_ `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL COMMENT 'Sum of the SORT_SCAN column in the events_statements_current table.', `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_INDEX_USED column in the events_statements_current table.', `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -493,7 +493,7 @@ events_statements_summary_by_account_by_event_name CREATE TABLE `events_statemen `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL COMMENT 'Sum of the SORT_SCAN column in the events_statements_current table.', `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_INDEX_USED column in the events_statements_current table.', `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Sum of the SORT_SCAN column in the events_statements_current table.', `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_INDEX_USED column in the events_statements_current table.', `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL COMMENT 'Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Unused.', `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The EVENT_ID value of the event within which this event is nested.', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'The nesting event type.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Unused.', `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The EVENT_ID value of the event within which this event is nested.', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'The nesting event type.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table events_transactions_history_long; Table Create Table events_transactions_history_long CREATE TABLE `events_transactions_history_long` ( @@ -606,7 +606,7 @@ events_transactions_history_long CREATE TABLE `events_transactions_history_long` `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL COMMENT 'Unused.', `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The EVENT_ID value of the event within which this event is nested.', `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL COMMENT 'The nesting event type.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -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 COMMENT 'The minimum wait time of only READ ONLY transaction events.', `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The average wait time of only READ ONLY transaction events.', `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The maximum wait time of only READ ONLY transaction events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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,7 +648,7 @@ events_transactions_summary_by_thread_by_event_name CREATE TABLE `events_transac `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The minimum wait time of only READ ONLY transaction events.', `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The average wait time of only READ ONLY transaction events.', `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The maximum wait time of only READ ONLY transaction events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -669,7 +669,7 @@ events_transactions_summary_by_user_by_event_name CREATE TABLE `events_transacti `MIN_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The minimum wait time of only READ ONLY transaction events.', `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The average wait time of only READ ONLY transaction events.', `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The maximum wait time of only READ ONLY transaction events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -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 COMMENT 'The minimum wait time of only READ ONLY transaction events.', `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The average wait time of only READ ONLY transaction events.', `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The maximum wait time of only READ ONLY transaction events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'The minimum wait time of only READ ONLY transaction events.', `AVG_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The average wait time of only READ ONLY transaction events.', `MAX_TIMER_READ_ONLY` bigint(20) unsigned NOT NULL COMMENT 'The maximum wait time of only READ ONLY transaction events.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Operation type, for example read, write or lock', `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL COMMENT 'Number of bytes that the operation read or wrote, or NULL for table I/O waits.', `FLAGS` int(10) unsigned DEFAULT NULL COMMENT 'Reserved for use in the future.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Operation type, for example read, write or lock', `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL COMMENT 'Number of bytes that the operation read or wrote, or NULL for table I/O waits.', `FLAGS` int(10) unsigned DEFAULT NULL COMMENT 'Reserved for use in the future.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table events_waits_history_long; Table Create Table events_waits_history_long CREATE TABLE `events_waits_history_long` ( @@ -780,7 +780,7 @@ events_waits_history_long CREATE TABLE `events_waits_history_long` ( `OPERATION` varchar(32) NOT NULL COMMENT 'Operation type, for example read, write or lock', `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL COMMENT 'Number of bytes that the operation read or wrote, or NULL for table I/O waits.', `FLAGS` int(10) unsigned DEFAULT NULL COMMENT 'Reserved for use in the future.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -791,7 +791,7 @@ events_waits_summary_by_host_by_event_name CREATE TABLE `events_waits_summary_by `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the summarized events that are timed.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the summarized events that are timed.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the summarized events that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of the summarized events that are timed.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the summarized events that are timed.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the summarized events that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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,7 +813,7 @@ events_waits_summary_by_thread_by_event_name CREATE TABLE `events_waits_summary_ `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the summarized events that are timed.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the summarized events that are timed.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the summarized events that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -824,7 +824,7 @@ events_waits_summary_by_user_by_event_name CREATE TABLE `events_waits_summary_by `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the summarized events that are timed.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the summarized events that are timed.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the summarized events that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -836,7 +836,7 @@ events_waits_summary_by_account_by_event_name CREATE TABLE `events_waits_summary `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the summarized events that are timed.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the summarized events that are timed.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the summarized events that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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,7 +846,7 @@ events_waits_summary_global_by_event_name CREATE TABLE `events_waits_summary_glo `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of the summarized events that are timed.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the summarized events that are timed.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the summarized events that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -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 COMMENT 'Lowest number of bytes used.', `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Current number of bytes used (total allocated minus total freed).', `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Highest number of bytes used.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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,7 +878,7 @@ memory_summary_by_thread_by_event_name CREATE TABLE `memory_summary_by_thread_by `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Lowest number of bytes used.', `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Current number of bytes used (total allocated minus total freed).', `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Highest number of bytes used.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -894,7 +894,7 @@ memory_summary_by_user_by_event_name CREATE TABLE `memory_summary_by_user_by_eve `LOW_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Lowest number of bytes used.', `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Current number of bytes used (total allocated minus total freed).', `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Highest number of bytes used.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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` ( @@ -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 COMMENT 'Lowest number of bytes used.', `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Current number of bytes used (total allocated minus total freed).', `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Highest number of bytes used.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Lowest number of bytes used.', `CURRENT_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Current number of bytes used (total allocated minus total freed).', `HIGH_NUMBER_OF_BYTES_USED` bigint(20) NOT NULL COMMENT 'Highest number of bytes used.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Source file containing the instrumented code that produced the event, as well as the line number where the instrumentation occurred. This allows one to examine the source code involved.', `OWNER_THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'Thread that requested the lock.', `OWNER_EVENT_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'Event that requested the lock.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table file_instances; Table Create Table file_instances CREATE TABLE `file_instances` ( `FILE_NAME` varchar(512) NOT NULL COMMENT 'File name.', `EVENT_NAME` varchar(128) NOT NULL COMMENT 'Instrument name associated with the file.', `OPEN_COUNT` int(10) unsigned NOT NULL COMMENT 'Open handles on the file. A value of greater than zero means that the file is currently open.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of all miscellaneous operations that are timed.', `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of all miscellaneous operations that are timed.', `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of all miscellaneous operations that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table file_summary_by_instance; Table Create Table file_summary_by_instance CREATE TABLE `file_summary_by_instance` ( @@ -1003,7 +1003,7 @@ file_summary_by_instance CREATE TABLE `file_summary_by_instance` ( `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Minimum wait time of all miscellaneous operations that are timed.', `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of all miscellaneous operations that are timed.', `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of all miscellaneous operations that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table host_cache; Table Create Table host_cache CREATE TABLE `host_cache` ( @@ -1036,21 +1036,21 @@ host_cache CREATE TABLE `host_cache` ( `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Timestamp of the most recent connection attempt by the IP.', `FIRST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Timestamp of the first error seen from the IP.', `LAST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Timestamp of the most recent error seen from the IP.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table hosts; Table Create Table hosts CREATE TABLE `hosts` ( `HOST` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Host name used by the client to connect, NULL for internal threads or user sessions that failed to authenticate.', `CURRENT_CONNECTIONS` bigint(20) NOT NULL COMMENT 'Current number of the host''s connections.', `TOTAL_CONNECTIONS` bigint(20) NOT NULL COMMENT 'Total number of the host''s connections' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table mutex_instances; Table Create Table mutex_instances CREATE TABLE `mutex_instances` ( `NAME` varchar(128) NOT NULL COMMENT 'Instrument name associated with the mutex.', `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL COMMENT 'Memory address of the instrumented mutex.', `LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The THREAD_ID of the locking thread if a thread has a mutex locked, otherwise NULL.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of the summarized events that are timed.', `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of the summarized events that are timed.', `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of the summarized events that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Number of timer units per second. Dependent on the processor speed.', `TIMER_RESOLUTION` bigint(20) DEFAULT NULL COMMENT 'Number of timer units by which timed values increase each time.', `TIMER_OVERHEAD` bigint(20) DEFAULT NULL COMMENT 'Minimum timer overhead, determined during initialization by calling the timer 20 times and selecting the smallest value. Total overhead will be at least double this, as the timer is called at the beginning and end of each timed event.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table rwlock_instances; Table Create Table rwlock_instances CREATE TABLE `rwlock_instances` ( @@ -1078,7 +1078,7 @@ rwlock_instances CREATE TABLE `rwlock_instances` ( `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL COMMENT 'Address in memory of the instrumented lock', `WRITE_LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'THREAD_ID of the locking thread if locked in write (exclusive) mode, otherwise NULL.', `READ_LOCKED_BY_COUNT` int(10) unsigned NOT NULL COMMENT 'Count of current read locks held' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table setup_actors; Table Create Table setup_actors CREATE TABLE `setup_actors` ( @@ -1087,20 +1087,20 @@ setup_actors CREATE TABLE `setup_actors` ( `ROLE` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '%' COMMENT 'Unused', `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES' COMMENT 'Whether to enable instrumentation for foreground threads matched by the row.', `HISTORY` enum('YES','NO') NOT NULL DEFAULT 'YES' COMMENT 'Whether to log historical events for foreground threads matched by the row.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table setup_consumers; Table Create Table setup_consumers CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL COMMENT 'Consumer name', `ENABLED` enum('YES','NO') NOT NULL COMMENT 'YES or NO for whether or not the consumer is enabled. You can modify this column to ensure that event information is added, or is not added.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table setup_instruments; Table Create Table setup_instruments CREATE TABLE `setup_instruments` ( `NAME` varchar(128) NOT NULL COMMENT 'Instrument name', `ENABLED` enum('YES','NO') NOT NULL COMMENT 'Whether or not the instrument is enabled. It can be disabled, and the instrument will produce no events.', `TIMED` enum('YES','NO') NOT NULL COMMENT 'Whether or not the instrument is timed. It can be set, but if disabled, events produced by the instrument will have NULL values for the corresponding TIMER_START, TIMER_END, and TIMER_WAIT values.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 '%' COMMENT 'Name of the instrumented object, either the literal or % for any object.', `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES' COMMENT 'Whether the object''s events are instrumented or not. Can be disabled, in which case monitoring is not enabled for those objects.', `TIMED` enum('YES','NO') NOT NULL DEFAULT 'YES' COMMENT 'Whether the object''s events are timed or not. Can be modified.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table setup_timers; Table Create Table setup_timers CREATE TABLE `setup_timers` ( `NAME` varchar(64) NOT NULL COMMENT 'Type of instrument the timer is used for.', `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') NOT NULL COMMENT 'Timer applying to the instrument type. Can be modified.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Client IP address. Blank for Unix socket file, otherwise an IPv4 or IPv6 address. Together with the PORT identifies the connection.', `PORT` int(11) NOT NULL COMMENT 'TCP/IP port number, from 0 to 65535. Together with the IP identifies the connection.', `STATE` enum('IDLE','ACTIVE') NOT NULL COMMENT 'Socket status, either IDLE if waiting to receive a request from a client, or ACTIVE' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of all miscellaneous operations that are timed.', `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of all miscellaneous operations that are timed.', `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of all miscellaneous operations that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of all miscellaneous operations that are timed.', `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of all miscellaneous operations that are timed.', `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of all miscellaneous operations that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'The event which caused the table handle to be opened.', `INTERNAL_LOCK` varchar(64) DEFAULT NULL COMMENT 'The table lock used at the SQL level.', `EXTERNAL_LOCK` varchar(64) DEFAULT NULL COMMENT 'The table lock used at the storage engine level.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of all delete operations that are timed.', `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of all delete operations that are timed.', `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of all delete operations that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of all delete operations that are timed.', `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of all delete operations that are timed.', `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of all delete operations that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Minimum wait time of all external write locks that are timed.', `AVG_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL COMMENT 'Average wait time of all external write locks that are timed.', `MAX_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL COMMENT 'Maximum wait time of all external write locks that are timed.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 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 COMMENT 'Whether to log historical events for the thread.', `CONNECTION_TYPE` varchar(16) DEFAULT NULL COMMENT 'The protocol used to establish the connection, or NULL for background threads.', `THREAD_OS_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'The thread or task identifier as defined by the underlying operating system, if there is one.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci show create table users; Table Create Table users CREATE TABLE `users` ( `USER` char(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'The connection''s client user name for the connection, or NULL if an internal thread.', `CURRENT_CONNECTIONS` bigint(20) NOT NULL COMMENT 'Current connections for the user.', `TOTAL_CONNECTIONS` bigint(20) NOT NULL COMMENT 'Total connections for the user.' -) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 +) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci |