MySQL 表分区（四）
• LIST表分区：列表表分区，按照一个一个确定的值来确定每个分区包含的数据
• 通过 PARTITION BY LIST(expr) 分区函数表达式必须返回整数，取值范围通过 VALUES IN (value_list) 定义
mysql> CREATE TABLE employees (id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), -> hired DATE NOT NULL DEFAULT '1970-01-01', -> separated DATE NOT NULL DEFAULT '9999-12-31', -> job_code INT, store_id INT ) -> PARTITION BY LIST(store_id) -> ( PARTITION pNorth VALUES IN (3,5,6,9,17), -> PARTITION pEast VALUES IN (1,2,10,11,19,20), -> PARTITION pWest VALUES IN (4,12,13,14,18), -> PARTITION pCentral VALUES IN (7,8,15,16) ); Query OK, 0 rows affected (0.09 sec) mysql> show create table employees; +-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | employees | CREATE TABLE `employees` ( `id` int(11) NOT NULL, `fname` varchar(30) DEFAULT NULL, `lname` varchar(30) DEFAULT NULL, `hired` date NOT NULL DEFAULT '1970-01-01', `separated` date NOT NULL DEFAULT '9999-12-31', `job_code` int(11) DEFAULT NULL, `store_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY LIST (`store_id`) (PARTITION pNorth VALUES IN (3,5,6,9,17) ENGINE = InnoDB, PARTITION pEast VALUES IN (1,2,10,11,19,20) ENGINE = InnoDB, PARTITION pWest VALUES IN (4,12,13,14,18) ENGINE = InnoDB, PARTITION pCentral VALUES IN (7,8,15,16) ENGINE = InnoDB) */ | +-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec) mysql> insert into employees values(1,'a','a',now(),now(),1,5); Query OK, 1 row affected, 2 warnings (0.10 sec) mysql> insert into employees values(1,'a','a',now(),now(),1,13); Query OK, 1 row affected, 2 warnings (0.07 sec) mysql> select * from employees; +----+-------+-------+------------+------------+----------+----------+ | id | fname | lname | hired | separated | job_code | store_id | +----+-------+-------+------------+------------+----------+----------+ | 1 | a | a | 2020-05-07 | 2020-05-07 | 1 | 5 | | 1 | a | a | 2020-05-07 | 2020-05-07 | 1 | 13 | +----+-------+-------+------------+------------+----------+----------+ 2 rows in set (0.00 sec) mysql> select * from employees partition(pNorth); +----+-------+-------+------------+------------+----------+----------+ | id | fname | lname | hired | separated | job_code | store_id | +----+-------+-------+------------+------------+----------+----------+ | 1 | a | a | 2020-05-07 | 2020-05-07 | 1 | 5 | +----+-------+-------+------------+------------+----------+----------+ 1 row in set (0.00 sec) mysql> select * from employees partition(pWest); +----+-------+-------+------------+------------+----------+----------+ | id | fname | lname | hired | separated | job_code | store_id | +----+-------+-------+------------+------------+----------+----------+ | 1 | a | a | 2020-05-07 | 2020-05-07 | 1 | 13 | +----+-------+-------+------------+------------+----------+----------+ 1 row in set (0.00 sec) mysql> drop table employees; Query OK, 0 rows affected (0.08 sec) mysql> CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), -> hired DATE NOT NULL DEFAULT '1970-01-01', -> separated DATE NOT NULL DEFAULT '9999-12-31', -> job_code INT, store_name varchar(20) ) -> PARTITION BY LIST(store_name) -> ( PARTITION pNorth VALUES IN ('a','b'), -> PARTITION pEast VALUES IN ('c','d')); ERROR 1697 (HY000): VALUES value for partition 'pNorth' must have type INT mysql> CREATE TABLE h2 (c1 INT, c2 INT ) -> PARTITION BY LIST(c1) -> (PARTITION p0 VALUES IN (1, 4, 7), -> PARTITION p1 VALUES IN (2, 5, 8)); Query OK, 0 rows affected (0.14 sec) mysql> show create table h2; +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | h2 | CREATE TABLE `h2` ( `c1` int(11) DEFAULT NULL, `c2` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY LIST (`c1`) (PARTITION p0 VALUES IN (1,4,7) ENGINE = InnoDB, PARTITION p1 VALUES IN (2,5,8) ENGINE = InnoDB) */ | +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> INSERT INTO h2 VALUES (3, 5); ERROR 1526 (HY000): Table has no partition for value 3
mysql> create table customer -> (id int, -> province varchar(20)) -> partition by list(province) -> (partition pNorthwest values in ('xinjiang','xizhang','qinghai','ningxia','shanxi'), -> partition pNorthest values in ('heilongjiang','jilin','liaoning'), -> partition pSouthwest values in ('sichuan','yunnan','guangxi') -> ); ERROR 1697 (HY000): VALUES value for partition 'pNorthwest' must have type INT mysql> create table customer -> (id int, -> province varchar(20)) -> partition by list columns(province) -> (partition pNorthwest values in ('xinjiang','xizhang','qinghai','ningxia','shanxi'), -> partition pNorthest values in ('heilongjiang','jilin','liaoning'), -> partition pSouthwest values in ('sichuan','yunnan','guangxi') -> ); Query OK, 0 rows affected (0.15 sec)
mysql> CREATE TABLE rcx (a INT, b INT, -> c CHAR(3), d INT) -> PARTITION BY RANGE COLUMNS(a,b,c) -> (PARTITION p0 VALUES LESS THAN (5,10,'ggg'), -> PARTITION p1 VALUES LESS THAN (10,20,'mmm'), -> PARTITION p2 VALUES LESS THAN (15,30,'sss'), -> PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE)); Query OK, 0 rows affected (0.27 sec) mysql> show create table rcx; +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | rcx | CREATE TABLE `rcx` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` char(3) DEFAULT NULL, `d` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50500 PARTITION BY RANGE COLUMNS(a,b,c) (PARTITION p0 VALUES LESS THAN (5,10,'ggg') ENGINE = InnoDB, PARTITION p1 VALUES LESS THAN (10,20,'mmm') ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (15,30,'sss') ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE) ENGINE = InnoDB) */ | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec) mysql> insert into rcx values(4,5,'abc',1),(5,9,'abc',1),(4,11,'ggg',1),(5,11,'abc',1),(6,2, 'abc',1); Query OK, 5 rows affected (0.06 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> select * from rcx; +------+------+------+------+ | a | b | c | d | +------+------+------+------+ | 4 | 5 | abc | 1 | | 5 | 9 | abc | 1 | | 4 | 11 | ggg | 1 | | 5 | 11 | abc | 1 | | 6 | 2 | abc | 1 | +------+------+------+------+ 5 rows in set (0.00 sec) mysql> select * from rcx partition(p0); +------+------+------+------+ | a | b | c | d | +------+------+------+------+ | 4 | 5 | abc | 1 | | 5 | 9 | abc | 1 | | 4 | 11 | ggg | 1 | +------+------+------+------+ 3 rows in set (0.00 sec) mysql> select * from rcx partition(p1); +------+------+------+------+ | a | b | c | d | +------+------+------+------+ | 5 | 11 | abc | 1 | | 6 | 2 | abc | 1 | +------+------+------+------+ 2 rows in set (0.00 sec)
mysql> select * from information_schema.partitions; +---------------+--------------------+------------------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+---------------------------------------------------+------------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+------------+----------+-------------------+-----------+-----------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME | +---------------+--------------------+------------------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+---------------------------------------------------+------------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+------------+----------+-------------------+-----------+-----------------+ | def | mysql | innodb_table_stats | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 40 | 409 | 16384 | 0 | 0 | 4194304 | 2020-04-06 11:21:27 | 2020-05-07 20:13:51 | NULL | NULL | | | NULL | | def | mysql | innodb_index_stats | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 146 | 112 | 16384 | 0 | 0 | 4194304 | 2020-04-06 11:21:27 | 2020-05-07 20:13:51 | NULL | NULL | | | NULL | | def | information_schema | CHARACTER_SETS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | COLLATIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | COLUMN_STATISTICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | EVENTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | FILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_DATAFILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FOREIGN | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FOREIGN_COLS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FIELDS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_TABLESPACES_BRIEF | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | KEY_COLUMN_USAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | KEYWORDS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | PARAMETERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | PARTITIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | REFERENTIAL_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | RESOURCE_GROUPS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | ROUTINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | SCHEMATA | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | ST_SPATIAL_REFERENCE_SYSTEMS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | ST_GEOMETRY_COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | STATISTICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | TABLE_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | TABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | TRIGGERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | VIEW_ROUTINE_USAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | VIEW_TABLE_USAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | VIEWS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | COLUMN_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | ENGINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | OPTIMIZER_TRACE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | PLUGINS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | PROCESSLIST | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | PROFILING | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | SCHEMA_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | TABLESPACES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | TABLE_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | information_schema | USER_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | cond_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_current | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1536 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2560 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_summary_by_host_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 70912 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_summary_by_instance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8704 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 141824 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_summary_by_user_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 70912 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_summary_by_account_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 70912 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_waits_summary_global_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 554 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | file_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4096 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | file_summary_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 80 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | file_summary_by_instance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4096 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | host_cache | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 279 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | mutex_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3072 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | objects_summary_global_by_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5120 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | performance_timers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | rwlock_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2048 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | setup_actors | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 128 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | setup_consumers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 15 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | setup_instruments | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1393 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | setup_objects | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 128 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | setup_threads | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 100 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | table_io_waits_summary_by_index_usage | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8192 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | table_io_waits_summary_by_table | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4096 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | table_lock_waits_summary_by_table | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4096 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | threads | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_stages_current | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_stages_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2560 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_stages_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_stages_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 44800 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_stages_summary_by_account_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 22400 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_stages_summary_by_user_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 22400 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_stages_summary_by_host_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 22400 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_stages_summary_global_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 175 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_current | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2560 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2560 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 54272 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_summary_by_account_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 27136 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_summary_by_user_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 27136 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_summary_by_host_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 27136 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_summary_global_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 212 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_summary_by_digest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_summary_by_program | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1024 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_histogram_global | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 450 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_statements_histogram_by_digest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_transactions_current | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_transactions_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2560 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_transactions_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_transactions_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_transactions_summary_by_account_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 128 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_transactions_summary_by_user_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 128 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_transactions_summary_by_host_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 128 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_transactions_summary_global_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_errors_summary_by_user_by_error | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 571904 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_errors_summary_by_host_by_error | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 571904 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_errors_summary_by_account_by_error | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 571904 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_errors_summary_by_thread_by_error | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1143808 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | events_errors_summary_global_by_error | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4468 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | users | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 128 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | accounts | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 128 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | hosts | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 128 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | socket_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | socket_summary_by_instance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | socket_summary_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | session_connect_attrs | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 131072 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | session_account_connect_attrs | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 131072 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | memory_summary_global_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 450 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | memory_summary_by_account_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 57600 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | memory_summary_by_host_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 57600 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | memory_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 115200 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | memory_summary_by_user_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 57600 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | table_handles | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1024 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | metadata_locks | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1024 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | data_locks | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 99999 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | data_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 99999 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_connection_configuration | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_group_members | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_connection_status | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_applier_configuration | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_applier_status | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_applier_status_by_coordinator | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 256 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_applier_status_by_worker | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8192 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_group_member_stats | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_applier_filters | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | replication_applier_global_filters | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | log_status | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | prepared_statements_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | user_variables_by_thread | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2560 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | status_by_account | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 28800 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | status_by_host | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 28800 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | status_by_thread | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 57600 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | status_by_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 28800 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | global_status | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 225 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | session_status | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 225 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | variables_by_thread | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 144640 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | global_variables | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 565 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | session_variables | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 565 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | variables_info | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 565 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | persisted_variables | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | performance_schema | user_defined_functions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:34 | NULL | NULL | NULL | | | NULL | | def | mysql | db | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | 0 | 16384 | 4194304 | 2020-04-06 19:21:36 | 2020-05-06 17:22:00 | NULL | NULL | | | NULL | | def | mysql | user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 17 | 963 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | 2020-05-06 17:21:25 | NULL | NULL | | | NULL | | def | mysql | default_roles | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | role_edges | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | global_grants | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 15 | 1092 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | password_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | func | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | plugin | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | servers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | tables_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | 0 | 16384 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | columns_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | help_topic | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 741 | 2144 | 1589248 | 0 | 81920 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | help_category | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 40 | 409 | 16384 | 0 | 16384 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | help_relation | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 993 | 82 | 81920 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | help_keyword | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 871 | 112 | 98304 | 0 | 81920 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | time_zone_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | time_zone | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | time_zone_transition | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | time_zone_transition_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | time_zone_leap_second | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | procs_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 16384 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | general_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | slow_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | component | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | slave_relay_log_info | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | slave_master_info | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | slave_worker_info | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | gtid_executed | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | server_cost | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 6 | 2730 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | engine_cost | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | mysql | proxies_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | 0 | 16384 | 4194304 | 2020-04-06 19:21:36 | NULL | NULL | NULL | | | NULL | | def | sys | version | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | sys_config | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 6 | 2730 | 16384 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | innodb_buffer_stats_by_schema | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | x$innodb_buffer_stats_by_schema | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | innodb_buffer_stats_by_table | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | x$innodb_buffer_stats_by_table | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | schema_object_overview | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | schema_auto_increment_columns | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | x$schema_flattened_keys | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | schema_redundant_indexes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | ps_check_lost_instrumentation | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | latest_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | x$latest_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:37 | NULL | NULL | NULL | | | NULL | | def | sys | io_by_thread_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$io_by_thread_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | io_global_by_file_by_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$io_global_by_file_by_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | io_global_by_file_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$io_global_by_file_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | io_global_by_wait_by_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$io_global_by_wait_by_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | io_global_by_wait_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$io_global_by_wait_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | innodb_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$innodb_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | memory_by_user_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$memory_by_user_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | memory_by_host_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$memory_by_host_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | memory_by_thread_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$memory_by_thread_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | memory_global_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$memory_global_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | memory_global_total | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$memory_global_total | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | schema_index_statistics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$schema_index_statistics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$ps_schema_table_statistics_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | schema_table_statistics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$schema_table_statistics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | schema_table_statistics_with_buffer | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$schema_table_statistics_with_buffer | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | schema_tables_with_full_table_scans | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$schema_tables_with_full_table_scans | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | schema_unused_indexes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | schema_table_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$schema_table_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | statement_analysis | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$statement_analysis | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | statements_with_errors_or_warnings | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$statements_with_errors_or_warnings | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | statements_with_full_table_scans | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$statements_with_full_table_scans | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$ps_digest_avg_latency_distribution | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$ps_digest_95th_percentile_by_avg_us | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | statements_with_runtimes_in_95th_percentile | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$statements_with_runtimes_in_95th_percentile | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | statements_with_sorting | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$statements_with_sorting | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | statements_with_temp_tables | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$statements_with_temp_tables | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | user_summary_by_file_io_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$user_summary_by_file_io_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | user_summary_by_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$user_summary_by_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | user_summary_by_statement_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$user_summary_by_statement_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | user_summary_by_statement_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$user_summary_by_statement_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | user_summary_by_stages | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$user_summary_by_stages | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | user_summary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$user_summary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | host_summary_by_file_io_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$host_summary_by_file_io_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | host_summary_by_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$host_summary_by_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | host_summary_by_statement_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$host_summary_by_statement_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | host_summary_by_statement_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$host_summary_by_statement_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | host_summary_by_stages | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$host_summary_by_stages | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | host_summary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$host_summary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | wait_classes_global_by_avg_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$wait_classes_global_by_avg_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | wait_classes_global_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$wait_classes_global_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | waits_by_user_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$waits_by_user_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | waits_by_host_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$waits_by_host_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | waits_global_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$waits_global_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | metrics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | processlist | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$processlist | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | x$session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | sys | session_ssl_status | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:21:38 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_SESSION_TEMP_TABLESPACES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_VIRTUAL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_BUFFER_POOL_STATS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_BUFFER_PAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_CMPMEM_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_CMPMEM | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_TRX | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_CMP_PER_INDEX_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_CMP_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FT_DEFAULT_STOPWORD | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_CMP | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_TABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FT_BEING_DELETED | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_METRICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_TEMP_TABLE_INFO | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FT_DELETED | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_CACHED_INDEXES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FT_INDEX_TABLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_TABLESTATS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_BUFFER_PAGE_LRU | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_CMP_PER_INDEX | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FT_CONFIG | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_FT_INDEX_CACHE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_INDEXES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | information_schema | INNODB_TABLESPACES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2020-04-06 19:22:14 | NULL | NULL | NULL | | | NULL | | def | course | dept | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | 0 | 0 | 0 | 2020-04-18 19:58:44 | NULL | NULL | NULL | | | NULL | | def | course | score | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 27 | 606 | 16384 | 0 | 0 | 0 | 2020-04-18 19:59:25 | NULL | NULL | NULL | | | NULL | | def | course | students | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 16384 | 0 | 2020-04-20 17:53:20 | NULL | NULL | NULL | | | NULL | | def | course | teacher_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | 0 | 0 | 0 | 2020-04-21 11:07:58 | NULL | NULL | NULL | | | NULL | | def | course | score_avg | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 0 | 2020-04-21 11:41:45 | NULL | NULL | NULL | | | NULL | | def | course | temp3 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-04-21 20:42:39 | NULL | NULL | NULL | | | NULL | | def | course | temp5 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-04-21 22:12:58 | NULL | NULL | NULL | | | NULL | | def | course | shirts | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | 0 | 0 | 0 | 2020-04-22 14:31:31 | NULL | NULL | NULL | | | NULL | | def | course | myset | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | 0 | 0 | 0 | 2020-04-22 14:45:40 | NULL | NULL | NULL | | | NULL | | def | course | test | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 0 | 0 | 0 | 0 | 0 | 2020-04-22 18:38:05 | NULL | NULL | NULL | | | NULL | | def | course | course | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 16384 | 0 | 2020-04-22 21:14:54 | NULL | NULL | NULL | | | NULL | | def | course | A | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 0 | 2020-04-23 14:46:50 | NULL | NULL | NULL | | | NULL | | def | course | B | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-04-23 14:46:57 | NULL | NULL | NULL | | | NULL | | def | course | C | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | 0 | 0 | 0 | 2020-04-23 14:47:03 | NULL | NULL | NULL | | | NULL | | def | course | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 9 | 1820 | 16384 | 0 | 0 | 0 | 2020-04-23 14:47:12 | NULL | NULL | NULL | | | NULL | | def | course | Course | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 16384 | 0 | 2020-04-23 17:54:08 | NULL | NULL | NULL | | | NULL | | def | course | teacher | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 6 | 2730 | 16384 | 0 | 16384 | 0 | 2020-04-23 21:40:58 | NULL | NULL | NULL | | | NULL | | def | course | temp_123 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 58720256 | 2020-04-28 11:26:06 | NULL | NULL | NULL | | | NULL | | def | course | temp_234 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 58720256 | 2020-04-28 11:34:09 | NULL | NULL | NULL | | | NULL | | def | course | temp2 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-05 21:13:15 | NULL | NULL | NULL | | | NULL | | def | course5 | temp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-05 21:33:43 | NULL | NULL | NULL | | | NULL | | def | course4 | temp2 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-05 21:36:08 | NULL | NULL | NULL | | | NULL | | def | course4 | temp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-05 21:38:49 | NULL | NULL | NULL | | | NULL | | def | course | temp122 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-06 16:44:07 | NULL | NULL | NULL | | | NULL | | def | course6 | temp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-06 20:10:52 | NULL | NULL | NULL | | | NULL | | def | course | temp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2020-05-06 20:49:40 | 2020-05-06 20:52:03 | NULL | NULL | | | NULL | | def | course | tnp | p0 | NULL | 1 | NULL | RANGE | NULL | `ref` | NULL | 6 | 0 | 0 | 16384 | 0 | 16384 | 0 | 2020-05-07 11:06:56 | NULL | NULL | NULL | | default | NULL | | def | course | tnp | p1 | NULL | 2 | NULL | RANGE | NULL | `ref` | NULL | 11 | 0 | 0 | 16384 | 0 | 16384 | 0 | 2020-05-07 11:06:56 | NULL | NULL | NULL | | default | NULL | | def | course | h2 | p0 | NULL | 1 | NULL | LIST | NULL | `c1` | NULL | 1,4,7 | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-07 19:48:20 | NULL | NULL | NULL | | default | NULL | | def | course | h2 | p1 | NULL | 2 | NULL | LIST | NULL | `c1` | NULL | 2,5,8 | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-07 19:48:20 | NULL | NULL | NULL | | default | NULL | | def | course | customer | pNorthest | NULL | 2 | NULL | LIST COLUMNS | NULL | `province` | NULL | 'heilongjiang','jilin','liaoning' | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-07 20:07:05 | NULL | NULL | NULL | | default | NULL | | def | course | customer | pNorthwest | NULL | 1 | NULL | LIST COLUMNS | NULL | `province` | NULL | 'xinjiang','xizhang','qinghai','ningxia','shanxi' | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-07 20:07:05 | NULL | NULL | NULL | | default | NULL | | def | course | customer | pSouthwest | NULL | 3 | NULL | LIST COLUMNS | NULL | `province` | NULL | 'sichuan','yunnan','guangxi' | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-07 20:07:05 | NULL | NULL | NULL | | default | NULL | | def | course | rcx | p0 | NULL | 1 | NULL | RANGE COLUMNS | NULL | `a`,`b`,`c` | NULL | 5,10,'ggg' | 3 | 5461 | 16384 | 0 | 0 | 0 | 2020-05-07 20:10:54 | 2020-05-07 20:13:41 | NULL | NULL | | default | NULL | | def | course | rcx | p1 | NULL | 2 | NULL | RANGE COLUMNS | NULL | `a`,`b`,`c` | NULL | 10,20,'mmm' | 2 | 8192 | 16384 | 0 | 0 | 0 | 2020-05-07 20:10:54 | 2020-05-07 20:13:41 | NULL | NULL | | default | NULL | | def | course | rcx | p2 | NULL | 3 | NULL | RANGE COLUMNS | NULL | `a`,`b`,`c` | NULL | 15,30,'sss' | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-07 20:10:54 | NULL | NULL | NULL | | default | NULL | | def | course | rcx | p3 | NULL | 4 | NULL | RANGE COLUMNS | NULL | `a`,`b`,`c` | NULL | MAXVALUE,MAXVALUE,MAXVALUE | 0 | 0 | 16384 | 0 | 0 | 0 | 2020-05-07 20:10:54 | NULL | NULL | NULL | | default | NULL | +---------------+--------------------+------------------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+---------------------------------------------------+------------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+------------+----------+-------------------+-----------+-----------------+ 338 rows in set (0.82 sec)
mysql> CREATE TABLE rcf (a INT, b INT, c INT) -> PARTITION BY RANGE COLUMNS(a,b,c) ( -> PARTITION p0 VALUES LESS THAN (0,25,50), -> PARTITION p1 VALUES LESS THAN (20,20,100), -> PARTITION p2 VALUES LESS THAN (10,30,50), -> PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE)); ERROR 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition mysql> mysql> CREATE TABLE employees_by_lname ( id INT NOT NULL, fname VARCHAR(30), -> lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', -> separated DATE NOT NULL DEFAULT '9999-12-31', -> job_code INT NOT NULL, store_id INT NOT NULL ) -> PARTITION BY RANGE COLUMNS (hired) -> ( PARTITION p0 VALUES LESS THAN ('1970-01-01'), -> PARTITION p1 VALUES LESS THAN ('1980-01-01'), -> PARTITION p2 VALUES LESS THAN ('1990-01-01'), -> PARTITION p3 VALUES LESS THAN ('2000-01-01'), -> PARTITION p4 VALUES LESS THAN ('2010-01-01'), -> PARTITION p5 VALUES LESS THAN (MAXVALUE) ); Query OK, 0 rows affected (0.22 sec)
浙公网安备 33010602011771号