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 |