MySQL / Mariadb 간 버전별 information_schema DB의 테이블 정보 비교 표 입니다.
| MariaDB 10.1.48 |
MySQL 8.0.30 |
MySQL 5.7.37 |
Description |
| |
ADMINISTRABLE_ROLE_AUTHORIZATIONS |
|
|
| ALL_PLUGINS |
|
|
플러그인 설치여부 및 버전 정보 |
| APPLICABLE_ROLES |
APPLICABLE_ROLES |
|
|
| CHANGED_PAGE_BITMAPS |
|
|
|
| CHARACTER_SETS |
CHARACTER_SETS |
CHARACTER_SETS |
지원하는 캐릭터셋 목록 |
| |
CHECK_CONSTRAINTS |
|
|
| CLIENT_STATISTICS |
|
|
|
| COLLATIONS |
COLLATIONS |
COLLATIONS |
지원하는 Collations 목록 |
| COLLATION_CHARACTER_SET_APPLICABILITY |
COLLATION_CHARACTER_SET_APPLICABILITY |
COLLATION_CHARACTER_SET_APPLICABILITY |
캐릭터셋 과 Collation 맵핑 |
| COLUMN_PRIVILEGES |
COLUMN_PRIVILEGES |
COLUMN_PRIVILEGES |
|
| |
COLUMN_STATISTICS |
|
|
| COLUMNS |
COLUMNS |
COLUMNS |
DB별 컬럼 목록(정보) |
| |
COLUMNS_EXTENSIONS |
|
|
| ENABLED_ROLES |
ENABLED_ROLES |
|
|
| ENGINES |
ENGINES |
ENGINES |
|
| EVENTS |
EVENTS |
EVENTS |
|
| FILES |
FILES |
FILES |
|
| GEOMETRY_COLUMNS |
|
|
|
| GLOBAL_STATUS |
|
GLOBAL_STATUS |
|
| GLOBAL_VARIABLES |
|
GLOBAL_VARIABLES |
|
| INDEX_STATISTICS |
|
|
|
| INNODB_BUFFER_PAGE |
INNODB_BUFFER_PAGE |
INNODB_BUFFER_PAGE |
|
| INNODB_BUFFER_PAGE_LRU |
INNODB_BUFFER_PAGE_LRU |
INNODB_BUFFER_PAGE_LRU |
|
| INNODB_BUFFER_POOL_STATS |
INNODB_BUFFER_POOL_STATS |
INNODB_BUFFER_POOL_STATS |
|
| INNODB_CHANGED_PAGES |
|
|
|
| |
INNODB_CACHED_INDEXES |
|
|
| INNODB_CMP |
INNODB_CMP |
INNODB_CMP |
|
| INNODB_CMPMEM |
|
INNODB_CMPMEM |
|
| INNODB_CMPMEM_RESET |
|
INNODB_CMPMEM_RESET |
|
| INNODB_CMP_PER_INDEX |
INNODB_CMP_PER_INDEX |
INNODB_CMP_PER_INDEX |
|
| INNODB_CMP_PER_INDEX_RESET |
INNODB_CMP_PER_INDEX_RESET |
INNODB_CMP_PER_INDEX_RESET |
|
| INNODB_CMP_RESET |
INNODB_CMP_RESET |
INNODB_CMP_RESET |
|
| |
INNODB_CMPMEM |
|
|
| |
INNODB_CMPMEM_RESET |
|
|
| |
INNODB_COLUMNS |
|
|
| |
INNODB_DATAFILES |
|
|
| |
INNODB_FIELDS |
|
|
| |
INNODB_FOREIGN |
|
|
| |
INNODB_FOREIGN_COLS |
|
|
| INNODB_FT_BEING_DELETED |
INNODB_FT_BEING_DELETED |
INNODB_FT_BEING_DELETED |
|
| INNODB_FT_CONFIG |
INNODB_FT_CONFIG |
INNODB_FT_CONFIG |
|
| INNODB_FT_DEFAULT_STOPWORD |
INNODB_FT_DEFAULT_STOPWORD |
INNODB_FT_DEFAULT_STOPWORD |
|
| INNODB_FT_DELETED |
INNODB_FT_DELETED |
INNODB_FT_DELETED |
|
| INNODB_FT_INDEX_CACHE |
INNODB_FT_INDEX_CACHE |
INNODB_FT_INDEX_CACHE |
|
| INNODB_FT_INDEX_TABLE |
INNODB_FT_INDEX_TABLE |
INNODB_FT_INDEX_TABLE |
|
| |
INNODB_INDEXES |
|
|
| INNODB_LOCKS |
|
INNODB_LOCKS |
|
| INNODB_LOCK_WAITS |
|
INNODB_LOCK_WAITS |
|
| INNODB_METRICS |
INNODB_METRICS |
INNODB_METRICS |
|
| |
INNODB_SESSION_TEMP_TABLESPACES |
|
|
| |
INNODB_TABLES |
|
|
| |
INNODB_TABLESPACES |
|
|
| |
INNODB_TABLESPACES_BRIEF |
|
|
| |
INNODB_TABLESTATS |
|
|
| INNODB_MUTEXES |
|
|
|
| INNODB_SYS_COLUMNS |
|
INNODB_SYS_COLUMNS |
|
| INNODB_SYS_DATAFILES |
|
INNODB_SYS_DATAFILES |
|
| INNODB_SYS_FIELDS |
|
INNODB_SYS_FIELDS |
|
| INNODB_SYS_FOREIGN |
|
INNODB_SYS_FOREIGN |
|
| INNODB_SYS_FOREIGN_COLS |
|
INNODB_SYS_FOREIGN_COLS |
|
| INNODB_SYS_INDEXES |
|
INNODB_SYS_INDEXES |
|
| INNODB_SYS_SEMAPHORE_WAITS |
|
|
|
| INNODB_SYS_TABLES |
|
INNODB_SYS_TABLES |
|
| INNODB_SYS_TABLESPACES |
|
INNODB_SYS_TABLESPACES |
|
| INNODB_SYS_TABLESTATS |
|
INNODB_SYS_TABLESTATS |
|
| INNODB_TABLESPACES_ENCRYPTION |
|
|
|
| INNODB_TABLESPACES_SCRUBBING |
|
|
|
| |
|
INNODB_SYS_VIRTUAL |
|
| |
INNODB_TEMP_TABLE_INFO |
INNODB_TEMP_TABLE_INFO |
|
| INNODB_TRX |
INNODB_TRX |
INNODB_TRX |
|
| KEY_CACHES |
|
|
|
| |
INNODB_VIRTUAL |
|
|
| KEY_COLUMN_USAGE |
KEY_COLUMN_USAGE |
KEY_COLUMN_USAGE |
|
| |
KEYWORDS |
|
|
| |
OPTIMIZER_TRACE |
OPTIMIZER_TRACE |
|
| PARAMETERS |
PARAMETERS |
PARAMETERS |
|
| PARTITIONS |
PARTITIONS |
PARTITIONS |
|
| PLUGINS |
PLUGINS |
PLUGINS |
|
| PROCESSLIST |
PROCESSLIST |
PROCESSLIST |
|
| PROFILING |
PROFILING |
PROFILING |
|
| REFERENTIAL_CONSTRAINTS |
REFERENTIAL_CONSTRAINTS |
REFERENTIAL_CONSTRAINTS |
|
| |
RESOURCE_GROUPS |
|
|
| |
ROLE_COLUMN_GRANTS |
|
|
| |
ROLE_ROUTINE_GRANTS |
|
|
| |
ROLE_TABLE_GRANTS |
|
|
| ROUTINES |
ROUTINES |
ROUTINES |
|
| SCHEMATA |
SCHEMATA |
SCHEMATA |
|
| SCHEMA_PRIVILEGES |
SCHEMA_PRIVILEGES |
SCHEMA_PRIVILEGES |
|
| SESSION_STATUS |
|
SESSION_STATUS |
|
| SESSION_VARIABLES |
|
SESSION_VARIABLES |
|
| SPATIAL_REF_SYS |
|
|
|
| |
SCHEMATA_EXTENSIONS |
|
|
| |
ST_GEOMETRY_COLUMNS |
|
|
| |
ST_SPATIAL_REFERENCE_SYSTEMS |
|
|
| |
ST_UNITS_OF_MEASURE |
|
|
| STATISTICS |
STATISTICS |
STATISTICS |
|
| SYSTEM_VARIABLES |
|
|
|
| TABLES |
TABLES |
TABLES |
|
| |
TABLES_EXTENSIONS |
|
|
| TABLESPACES |
TABLESPACES |
TABLESPACES |
|
| TABLE_CONSTRAINTS |
TABLE_CONSTRAINTS |
TABLE_CONSTRAINTS |
|
| |
TABLE_CONSTRAINTS_EXTENSIONS |
|
|
| TABLE_PRIVILEGES |
TABLE_PRIVILEGES |
TABLE_PRIVILEGES |
|
| |
TABLESPACES_EXTENSIONS |
|
|
| TABLE_STATISTICS |
|
|
|
| TRIGGERS |
TRIGGERS |
TRIGGERS |
|
| |
USER_ATTRIBUTES |
|
|
| USER_PRIVILEGES |
USER_PRIVILEGES |
USER_PRIVILEGES |
|
| USER_STATISTICS |
|
|
|
| |
VIEW_ROUTINE_USAGE |
|
|
| |
VIEW_TABLE_USAGE |
|
|
| VIEWS |
VIEWS |
VIEWS |
|
| XTRADB_INTERNAL_HASH_TABLES |
|
|
|
| XTRADB_READ_VIEW |
|
|
|
| XTRADB_RSEG |
|
|
|