728x90
반응형
SMALL
엔진 지원
| MariaDB [(none)]> show engines; +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | CSV | YES | Stores tables as CSV files | NO | NO | NO | | MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MyISAM | YES | Non-transactional engine with good performance and small data footprint | NO | NO | NO | | SEQUENCE | YES | Generated tables filled with sequential values | YES | NO | YES | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO | | InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ 8 rows in set (0.00 sec) |
디폴트 엔진
| MariaDB [(none)]> SELECT engine, support FROM information_schema.engines WHERE support='DEFAULT'; +--------+---------+ | engine | support | +--------+---------+ | InnoDB | DEFAULT | +--------+---------+ 1 row in set (0.00 sec) |
728x90
반응형
LIST
'Linux&Ubuntu > DB' 카테고리의 다른 글
| Ansible로 DB 설치, 리플리케이션 , 모니터링 구축하기 (0) | 2023.10.31 |
|---|---|
| mysql binlog 삭제 하기 (0) | 2023.10.11 |
| mysql 5.7 ubuntu 18.04 xtrabackup (0) | 2023.07.14 |
| db 용량 및 카운트 조회 (0) | 2023.04.04 |
| mysql 스토리지 엔진변경 (0) | 2023.03.30 |
