mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
f691d9865b
This feature adds the functionality of ignorability for indexes. Indexes are not ignored be default. To control index ignorability explicitly for a new index, use IGNORE or NOT IGNORE as part of the index definition for CREATE TABLE, CREATE INDEX, or ALTER TABLE. Primary keys (explicit or implicit) cannot be made ignorable. The table INFORMATION_SCHEMA.STATISTICS get a new column named IGNORED that would store whether an index needs to be ignored or not.
94 lines
7 KiB
Text
94 lines
7 KiB
Text
DROP DATABASE IF EXISTS db_datadict;
|
|
CREATE DATABASE db_datadict;
|
|
DROP USER testuser1@localhost;
|
|
CREATE USER testuser1@localhost;
|
|
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
|
|
SELECT * FROM information_schema.statistics
|
|
WHERE table_schema = 'mysql'
|
|
ORDER BY table_schema, table_name, index_name, seq_in_index, column_name;
|
|
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IGNORED
|
|
def mysql columns_priv 0 mysql PRIMARY 1 Host A #CARD# NULL NULL BTREE NO
|
|
def mysql columns_priv 0 mysql PRIMARY 2 Db A #CARD# NULL NULL BTREE NO
|
|
def mysql columns_priv 0 mysql PRIMARY 3 User A #CARD# NULL NULL BTREE NO
|
|
def mysql columns_priv 0 mysql PRIMARY 4 Table_name A #CARD# NULL NULL BTREE NO
|
|
def mysql columns_priv 0 mysql PRIMARY 5 Column_name A #CARD# NULL NULL BTREE NO
|
|
def mysql column_stats 0 mysql PRIMARY 1 db_name A #CARD# NULL NULL BTREE NO
|
|
def mysql column_stats 0 mysql PRIMARY 2 table_name A #CARD# NULL NULL BTREE NO
|
|
def mysql column_stats 0 mysql PRIMARY 3 column_name A #CARD# NULL NULL BTREE NO
|
|
def mysql db 0 mysql PRIMARY 1 Host A #CARD# NULL NULL BTREE NO
|
|
def mysql db 0 mysql PRIMARY 2 Db A #CARD# NULL NULL BTREE NO
|
|
def mysql db 0 mysql PRIMARY 3 User A #CARD# NULL NULL BTREE NO
|
|
def mysql db 1 mysql User 1 User A #CARD# NULL NULL BTREE NO
|
|
def mysql event 0 mysql PRIMARY 1 db A #CARD# NULL NULL BTREE NO
|
|
def mysql event 0 mysql PRIMARY 2 name A #CARD# NULL NULL BTREE NO
|
|
def mysql func 0 mysql PRIMARY 1 name A #CARD# NULL NULL BTREE NO
|
|
def mysql global_priv 0 mysql PRIMARY 1 Host A #CARD# NULL NULL BTREE NO
|
|
def mysql global_priv 0 mysql PRIMARY 2 User A #CARD# NULL NULL BTREE NO
|
|
def mysql gtid_slave_pos 0 mysql PRIMARY 1 domain_id A #CARD# NULL NULL BTREE NO
|
|
def mysql gtid_slave_pos 0 mysql PRIMARY 2 sub_id A #CARD# NULL NULL BTREE NO
|
|
def mysql help_category 0 mysql name 1 name A #CARD# NULL NULL BTREE NO
|
|
def mysql help_category 0 mysql PRIMARY 1 help_category_id A #CARD# NULL NULL BTREE NO
|
|
def mysql help_keyword 0 mysql name 1 name A #CARD# NULL NULL BTREE NO
|
|
def mysql help_keyword 0 mysql PRIMARY 1 help_keyword_id A #CARD# NULL NULL BTREE NO
|
|
def mysql help_relation 1 mysql help_topic_id 1 help_topic_id A #CARD# NULL NULL BTREE NO
|
|
def mysql help_relation 0 mysql PRIMARY 1 help_keyword_id A #CARD# NULL NULL BTREE NO
|
|
def mysql help_relation 0 mysql PRIMARY 2 help_topic_id A #CARD# NULL NULL BTREE NO
|
|
def mysql help_topic 0 mysql name 1 name A #CARD# NULL NULL BTREE NO
|
|
def mysql help_topic 0 mysql PRIMARY 1 help_topic_id A #CARD# NULL NULL BTREE NO
|
|
def mysql index_stats 0 mysql PRIMARY 1 db_name A #CARD# NULL NULL BTREE NO
|
|
def mysql index_stats 0 mysql PRIMARY 2 table_name A #CARD# NULL NULL BTREE NO
|
|
def mysql index_stats 0 mysql PRIMARY 3 index_name A #CARD# NULL NULL BTREE NO
|
|
def mysql index_stats 0 mysql PRIMARY 4 prefix_arity A #CARD# NULL NULL BTREE NO
|
|
def mysql innodb_index_stats 0 mysql PRIMARY 1 database_name A #CARD# NULL NULL BTREE NO
|
|
def mysql innodb_index_stats 0 mysql PRIMARY 2 table_name A #CARD# NULL NULL BTREE NO
|
|
def mysql innodb_index_stats 0 mysql PRIMARY 3 index_name A #CARD# NULL NULL BTREE NO
|
|
def mysql innodb_index_stats 0 mysql PRIMARY 4 stat_name A #CARD# NULL NULL BTREE NO
|
|
def mysql innodb_table_stats 0 mysql PRIMARY 1 database_name A #CARD# NULL NULL BTREE NO
|
|
def mysql innodb_table_stats 0 mysql PRIMARY 2 table_name A #CARD# NULL NULL BTREE NO
|
|
def mysql plugin 0 mysql PRIMARY 1 name A #CARD# NULL NULL BTREE NO
|
|
def mysql proc 0 mysql PRIMARY 1 db A #CARD# NULL NULL BTREE NO
|
|
def mysql proc 0 mysql PRIMARY 2 name A #CARD# NULL NULL BTREE NO
|
|
def mysql proc 0 mysql PRIMARY 3 type A #CARD# NULL NULL BTREE NO
|
|
def mysql procs_priv 1 mysql Grantor 1 Grantor A #CARD# NULL NULL BTREE NO
|
|
def mysql procs_priv 0 mysql PRIMARY 1 Host A #CARD# NULL NULL BTREE NO
|
|
def mysql procs_priv 0 mysql PRIMARY 2 Db A #CARD# NULL NULL BTREE NO
|
|
def mysql procs_priv 0 mysql PRIMARY 3 User A #CARD# NULL NULL BTREE NO
|
|
def mysql procs_priv 0 mysql PRIMARY 4 Routine_name A #CARD# NULL NULL BTREE NO
|
|
def mysql procs_priv 0 mysql PRIMARY 5 Routine_type A #CARD# NULL NULL BTREE NO
|
|
def mysql proxies_priv 1 mysql Grantor 1 Grantor A #CARD# NULL NULL BTREE NO
|
|
def mysql proxies_priv 0 mysql PRIMARY 1 Host A #CARD# NULL NULL BTREE NO
|
|
def mysql proxies_priv 0 mysql PRIMARY 2 User A #CARD# NULL NULL BTREE NO
|
|
def mysql proxies_priv 0 mysql PRIMARY 3 Proxied_host A #CARD# NULL NULL BTREE NO
|
|
def mysql proxies_priv 0 mysql PRIMARY 4 Proxied_user A #CARD# NULL NULL BTREE NO
|
|
def mysql roles_mapping 0 mysql Host 1 Host A #CARD# NULL NULL BTREE NO
|
|
def mysql roles_mapping 0 mysql Host 2 User A #CARD# NULL NULL BTREE NO
|
|
def mysql roles_mapping 0 mysql Host 3 Role A #CARD# NULL NULL BTREE NO
|
|
def mysql servers 0 mysql PRIMARY 1 Server_name A #CARD# NULL NULL BTREE NO
|
|
def mysql tables_priv 1 mysql Grantor 1 Grantor A #CARD# NULL NULL BTREE NO
|
|
def mysql tables_priv 0 mysql PRIMARY 1 Host A #CARD# NULL NULL BTREE NO
|
|
def mysql tables_priv 0 mysql PRIMARY 2 Db A #CARD# NULL NULL BTREE NO
|
|
def mysql tables_priv 0 mysql PRIMARY 3 User A #CARD# NULL NULL BTREE NO
|
|
def mysql tables_priv 0 mysql PRIMARY 4 Table_name A #CARD# NULL NULL BTREE NO
|
|
def mysql table_stats 0 mysql PRIMARY 1 db_name A #CARD# NULL NULL BTREE NO
|
|
def mysql table_stats 0 mysql PRIMARY 2 table_name A #CARD# NULL NULL BTREE NO
|
|
def mysql time_zone 0 mysql PRIMARY 1 Time_zone_id A #CARD# NULL NULL BTREE NO
|
|
def mysql time_zone_leap_second 0 mysql PRIMARY 1 Transition_time A #CARD# NULL NULL BTREE NO
|
|
def mysql time_zone_name 0 mysql PRIMARY 1 Name A #CARD# NULL NULL BTREE NO
|
|
def mysql time_zone_transition 0 mysql PRIMARY 1 Time_zone_id A #CARD# NULL NULL BTREE NO
|
|
def mysql time_zone_transition 0 mysql PRIMARY 2 Transition_time A #CARD# NULL NULL BTREE NO
|
|
def mysql time_zone_transition_type 0 mysql PRIMARY 1 Time_zone_id A #CARD# NULL NULL BTREE NO
|
|
def mysql time_zone_transition_type 0 mysql PRIMARY 2 Transition_type_id A #CARD# NULL NULL BTREE NO
|
|
def mysql transaction_registry 1 mysql begin_timestamp 1 begin_timestamp A #CARD# NULL NULL BTREE NO
|
|
def mysql transaction_registry 0 mysql commit_id 1 commit_id A #CARD# NULL NULL BTREE NO
|
|
def mysql transaction_registry 1 mysql commit_timestamp 1 commit_timestamp A #CARD# NULL NULL BTREE NO
|
|
def mysql transaction_registry 1 mysql commit_timestamp 2 transaction_id A #CARD# NULL NULL BTREE NO
|
|
def mysql transaction_registry 0 mysql PRIMARY 1 transaction_id A #CARD# NULL NULL BTREE NO
|
|
connect testuser1,localhost,testuser1,,db_datadict;
|
|
SELECT * FROM information_schema.statistics
|
|
WHERE table_schema = 'mysql'
|
|
ORDER BY table_schema, table_name, index_name, seq_in_index, column_name;
|
|
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IGNORED
|
|
connection default;
|
|
disconnect testuser1;
|
|
DROP USER testuser1@localhost;
|
|
DROP DATABASE db_datadict;
|