|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'component' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
mysql |
component |
PRIMARY |
2019-10-30 15:09:29 |
n_diff_pfx01 |
0 |
1 |
component_id |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'component' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
mysql |
component |
PRIMARY |
2019-10-30 15:09:29 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'component' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
mysql |
component |
PRIMARY |
2019-10-30 15:09:29 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'gtid_executed' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
mysql |
gtid_executed |
PRIMARY |
2019-10-30 15:09:29 |
n_diff_pfx01 |
0 |
1 |
source_uuid |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'gtid_executed' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
|
mysql |
gtid_executed |
PRIMARY |
2019-10-30 15:09:29 |
n_diff_pfx02 |
0 |
1 |
source_uuid,interval_start |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'gtid_executed' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
mysql |
gtid_executed |
PRIMARY |
2019-10-30 15:09:29 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'gtid_executed' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
mysql |
gtid_executed |
PRIMARY |
2019-10-30 15:09:29 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'sys' AND `innodb_index_stats`.`table_name` = 'sys_config' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
sys |
sys_config |
PRIMARY |
2019-10-30 15:09:30 |
n_diff_pfx01 |
2 |
1 |
variable |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'sys' AND `innodb_index_stats`.`table_name` = 'sys_config' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
sys |
sys_config |
PRIMARY |
2019-10-30 15:09:30 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'sys' AND `innodb_index_stats`.`table_name` = 'sys_config' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
sys |
sys_config |
PRIMARY |
2019-10-30 15:09:30 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'umesh' AND `innodb_index_stats`.`table_name` = 'register' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
umesh |
register |
GEN_CLUST_INDEX |
2024-09-26 19:54:20 |
n_diff_pfx01 |
0 |
1 |
DB_ROW_ID |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'umesh' AND `innodb_index_stats`.`table_name` = 'register' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
umesh |
register |
GEN_CLUST_INDEX |
2024-09-26 19:54:20 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'umesh' AND `innodb_index_stats`.`table_name` = 'register' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'size'
|
umesh |
register |
GEN_CLUST_INDEX |
2024-09-26 19:54:20 |
size |
1 |
NULL
|
Number of pages in the index |