|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'mysql\' AND `innodb_index_stats`.`table_name` = \'gtid_slave_pos\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
|
mysql |
gtid_slave_pos |
PRIMARY |
2019-10-21 19:17:49 |
n_diff_pfx01 |
0 |
1 |
domain_id |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'mysql\' AND `innodb_index_stats`.`table_name` = \'gtid_slave_pos\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx02\'
|
mysql |
gtid_slave_pos |
PRIMARY |
2019-10-21 19:17:49 |
n_diff_pfx02 |
0 |
1 |
domain_id,sub_id |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'mysql\' AND `innodb_index_stats`.`table_name` = \'gtid_slave_pos\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
|
mysql |
gtid_slave_pos |
PRIMARY |
2019-10-21 19:17:49 |
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_slave_pos\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
|
mysql |
gtid_slave_pos |
PRIMARY |
2019-10-21 19:17:49 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pamsimasgv\' AND `innodb_index_stats`.`table_name` = \'customer\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
|
pamsimasgv |
customer |
PRIMARY |
2024-02-02 11:36:45 |
n_diff_pfx01 |
91 |
1 |
sno |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pamsimasgv\' AND `innodb_index_stats`.`table_name` = \'customer\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
|
pamsimasgv |
customer |
PRIMARY |
2024-02-02 11:36:45 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pamsimasgv\' AND `innodb_index_stats`.`table_name` = \'customer\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
|
pamsimasgv |
customer |
PRIMARY |
2024-02-02 11:36:45 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pamsimasgv\' AND `innodb_index_stats`.`table_name` = \'tran\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
|
pamsimasgv |
tran |
PRIMARY |
2024-02-02 11:36:35 |
n_diff_pfx01 |
92 |
1 |
sno |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pamsimasgv\' AND `innodb_index_stats`.`table_name` = \'tran\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
|
pamsimasgv |
tran |
PRIMARY |
2024-02-02 11:36:35 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pamsimasgv\' AND `innodb_index_stats`.`table_name` = \'tran\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
|
pamsimasgv |
tran |
PRIMARY |
2024-02-02 11:36:35 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'bobot_kriteria\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
|
pegawai_demak_moora |
bobot_kriteria |
PRIMARY |
2024-01-13 09:02:03 |
n_diff_pfx01 |
0 |
1 |
id_bobot |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'bobot_kriteria\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
|
pegawai_demak_moora |
bobot_kriteria |
PRIMARY |
2024-01-13 09:02:03 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'bobot_kriteria\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
|
pegawai_demak_moora |
bobot_kriteria |
PRIMARY |
2024-01-13 09:02:03 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
|
pegawai_demak_moora |
kriteria |
PRIMARY |
2024-01-13 09:02:04 |
n_diff_pfx01 |
9 |
1 |
id_kriteria |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
|
pegawai_demak_moora |
kriteria |
PRIMARY |
2024-01-13 09:02:04 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'size\'
|
pegawai_demak_moora |
kriteria |
PRIMARY |
2024-01-13 09:02:04 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'nis\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
|
pegawai_demak_moora |
kriteria |
nis |
2024-01-13 09:02:04 |
n_diff_pfx01 |
9 |
1 |
nik |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'nis\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx02\'
|
pegawai_demak_moora |
kriteria |
nis |
2024-01-13 09:02:04 |
n_diff_pfx02 |
9 |
1 |
nik,id_kriteria |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'nis\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
|
pegawai_demak_moora |
kriteria |
nis |
2024-01-13 09:02:04 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'nis\' AND `innodb_index_stats`.`stat_name` = \'size\'
|
pegawai_demak_moora |
kriteria |
nis |
2024-01-13 09:02:04 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'nis_2\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
|
pegawai_demak_moora |
kriteria |
nis_2 |
2024-01-13 09:02:04 |
n_diff_pfx01 |
9 |
1 |
nik |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'nis_2\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx02\'
|
pegawai_demak_moora |
kriteria |
nis_2 |
2024-01-13 09:02:04 |
n_diff_pfx02 |
9 |
1 |
nik,id_kriteria |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'nis_2\' AND `innodb_index_stats`.`stat_name` = \'n_leaf_pages\'
|
pegawai_demak_moora |
kriteria |
nis_2 |
2024-01-13 09:02:04 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'kriteria\' AND `innodb_index_stats`.`index_name` = \'nis_2\' AND `innodb_index_stats`.`stat_name` = \'size\'
|
pegawai_demak_moora |
kriteria |
nis_2 |
2024-01-13 09:02:04 |
size |
1 |
NULL
|
Number of pages in the index |
|
编辑
|
复制
|
删除
DELETE FROM `innodb_index_stats` WHERE `innodb_index_stats`.`database_name` = \'pegawai_demak_moora\' AND `innodb_index_stats`.`table_name` = \'pegawai\' AND `innodb_index_stats`.`index_name` = \'PRIMARY\' AND `innodb_index_stats`.`stat_name` = \'n_diff_pfx01\'
|
pegawai_demak_moora |
pegawai |
PRIMARY |
2024-01-13 09:02:03 |
n_diff_pfx01 |
16 |
1 |
nik |