CREATE TABLE CLUSTER_SLOW_QUERY
(
INSTANCE
varchar(64) DEFAULT NULL,
Time
timestamp(6) NOT NULL,
Txn_start_ts
bigint(20) unsigned DEFAULT NULL,
User
varchar(64) DEFAULT NULL,
Host
varchar(64) DEFAULT NULL,
Conn_ID
bigint(20) unsigned DEFAULT NULL,
Exec_retry_count
bigint(20) unsigned DEFAULT NULL,
Exec_retry_time
double DEFAULT NULL,
Query_time
double DEFAULT NULL,
Parse_time
double DEFAULT NULL,
Compile_time
double DEFAULT NULL,
Rewrite_time
double DEFAULT NULL,
Preproc_subqueries
bigint(20) unsigned DEFAULT NULL,
Preproc_subqueries_time
double DEFAULT NULL,
Optimize_time
double DEFAULT NULL,
Wait_TS
double DEFAULT NULL,
Prewrite_time
double DEFAULT NULL,
Wait_prewrite_binlog_time
double DEFAULT NULL,
Commit_time
double DEFAULT NULL,
Get_commit_ts_time
double DEFAULT NULL,
Commit_backoff_time
double DEFAULT NULL,
Backoff_types
varchar(64) DEFAULT NULL,
Resolve_lock_time
double DEFAULT NULL,
Local_latch_wait_time
double DEFAULT NULL,
Write_keys
bigint(22) DEFAULT NULL,
Write_size
bigint(22) DEFAULT NULL,
Prewrite_region
bigint(22) DEFAULT NULL,
Txn_retry
bigint(22) DEFAULT NULL,
Cop_time
double DEFAULT NULL,
Process_time
double DEFAULT NULL,
Wait_time
double DEFAULT NULL,
Backoff_time
double DEFAULT NULL,
LockKeys_time
double DEFAULT NULL,
Request_count
bigint(20) unsigned DEFAULT NULL,
Total_keys
bigint(20) unsigned DEFAULT NULL,
Process_keys
bigint(20) unsigned DEFAULT NULL,
Rocksdb_delete_skipped_count
bigint(20) unsigned DEFAULT NULL,
Rocksdb_key_skipped_count
bigint(20) unsigned DEFAULT NULL,
Rocksdb_block_cache_hit_count
bigint(20) unsigned DEFAULT NULL,
Rocksdb_block_read_count
bigint(20) unsigned DEFAULT NULL,
Rocksdb_block_read_byte
bigint(20) unsigned DEFAULT NULL,
DB
varchar(64) DEFAULT NULL,
Index_names
varchar(100) DEFAULT NULL,
Is_internal
tinyint(1) DEFAULT NULL,
Digest
varchar(64) DEFAULT NULL,
Stats
varchar(512) DEFAULT NULL,
Cop_proc_avg
double DEFAULT NULL,
Cop_proc_p90
double DEFAULT NULL,
Cop_proc_max
double DEFAULT NULL,
Cop_proc_addr
varchar(64) DEFAULT NULL,
Cop_wait_avg
double DEFAULT NULL,
Cop_wait_p90
double DEFAULT NULL,
Cop_wait_max
double DEFAULT NULL,
Cop_wait_addr
varchar(64) DEFAULT NULL,
Mem_max
bigint(20) DEFAULT NULL,
Disk_max
bigint(20) DEFAULT NULL,
KV_total
double DEFAULT NULL,
PD_total
double DEFAULT NULL,
Backoff_total
double DEFAULT NULL,
Write_sql_response_total
double DEFAULT NULL,
Backoff_Detail
varchar(4096) DEFAULT NULL,
Prepared
tinyint(1) DEFAULT NULL,
Succ
tinyint(1) DEFAULT NULL,
Plan_from_cache
tinyint(1) DEFAULT NULL,
Plan_from_binding
tinyint(1) DEFAULT NULL,
Plan
longtext DEFAULT NULL,
Plan_digest
varchar(128) DEFAULT NULL,
Prev_stmt
longtext DEFAULT NULL,
Query
longtext DEFAULT NULL,
PRIMARY KEY (Time
) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
这是5.1.1版本的表结构