information_schema详解

information_schema详解

1、information_schema使用说明

2、information_schema表描述

2.1. server层数据字典表

2.1.1. CHARACTER_SETS

2.1.2. COLLATIONS

2.1.3. COLLATION_CHARACTER_SET_APPLICABILITY

2.1.4. COLUMNS

2.1.5. COLUMN_PRIVILEGES

2.1.6. ENGINES

2.1.7. EVENTS

2.1.8. FILES

2.1.9. GLOBAL_STATUS、GLOBAL_VARIABLES、SESSION_STATUS、SESSION_VARIABLES

2.1.10. KEY_COLUMN_USAGE

2.1.11. OPTIMIZER_TRACE

2.1.12. PARAMETERS

2.1.13. PARTITIONS

2.1.14. PLUGINS

2.1.15. PROCESSLIST

2.1.16. PROFILING

2.1.17. REFERENTIAL_CONSTRAINTS

2.1.18. ROUTINES

2.1.19. SCHEMATA

2.1.20. SCHEMA_PRIVILEGES

2.1.21. STATISTICS

2.1.22. TABLES

2.1.23. TABLESPACES

2.1.24. TABLE_CONSTRAINTS

2.1.25. TABLE_PRIVILEGES

2.1.26. TRIGGERS

2.1.27. USER_PRIVILEGES

2.1.28. VIEWS

2.2. innodb层数据字典表

2.2.1. INNODB_LOCKS

2.2.2. INNODB_TRX

2.2.3. INNODB_SYS_DATAFILES

2.2.4. INNODB_FT_CONFIG

2.2.5. INNODB_SYS_VIRTUAL

2.2.6. INNODB_CMP和INNODB_CMP_RESET

2.2.7. INNODB_FT_BEING_DELETED

2.2.8. INNODB_CMP_PER_INDEX和INNODB_CMP_PER_INDEX_RESET

2.2.10. INNODB_FT_DELETED

2.2.11. INNODB_BUFFER_PAGE_LRU

2.2.12. INNODB_LOCK_WAITS

2.2.13. INNODB_TEMP_TABLE_INFO

2.2.14. INNODB_SYS_INDEXES

2.2.15. INNODB_SYS_TABLES

2.2.16. INNODB_SYS_FIELDS

2.2.18. INNODB_BUFFER_PAGE

2.2.19. INNODB_FT_DEFAULT_STOPWORD

2.2.20. INNODB_FT_INDEX_TABLE

2.2.21. INNODB_FT_INDEX_CACHE

2.2.22. INNODB_SYS_TABLESPACES

2.2.23. INNODB_METRICS

2.2.24. INNODB_SYS_FOREIGN_COLS

2.2.25. INNODB_CMPMEM和INNODB_CMPMEM_RESET

2.2.26. INNODB_BUFFER_POOL_STATS

2.2.27. INNODB_SYS_COLUMNS

2.2.28. INNODB_SYS_FOREIGN

2.2.29. INNODB_SYS_TABLESTATS

2.3. MySQL企业版线程池统计表

2.3.1. TP_THREAD_GROUP_STATE

2.3.2. TP_THREAD_GROUP_STATS

2.3.3. TP_THREAD_STATE

2.4. 其他表

2.4.1. CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS

3、附录