반응형
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 |
반응형
'Database & Data > MYSQL' 카테고리의 다른 글
| [MySQL][8.0.26] Global Variables 설명 (0) | 2023.02.17 |
|---|---|
| [MySQL][8.0.26] Global Status 설명 (0) | 2023.02.03 |
| MariaDB / MySQL 5.7 / MySQL 8.0 performance_schema 환경변수 비교 (2) | 2022.09.24 |
| MariaDB / MySQL 5.7 / MySQL 8.0 performance_schema 비교 (0) | 2022.09.24 |
| [MySQL] str_to_date 함수 설명(오류 내용) (0) | 2022.07.04 |