时间:2021-07-01 10:21:17 帮助过:26人阅读
- mariadb> show engines;
- +--------------------+---------+----------------------------------------------------------------------------+--------------+-----+------------+
- | Engine | Support | Comment | Transactions | XA | Savepoints |
- +--------------------+---------+----------------------------------------------------------------------------+--------------+-----+------------+
- | CSV | YES | CSV storage engine | NO | NO | NO |
- | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
- | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
- | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
- | MyISAM | YES | MyISAM storage engine | NO | NO | NO |
- | InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
- | ARCHIVE | YES | Archive storage engine | NO | NO | NO |
- | FEDERATED | YES | FederatedX pluggable storage engine | YES | NO | YES |
- | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
- | Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO |
- +--------------------+---------+----------------------------------------------------------------------------+--------------+-----+------------+
- 10 rows in set
- #最常用的是innodb和MyISAM
- #可见,默认引擎是innodb
引擎是表级别的,在创建表的时候,可以设定engine=innodb或者其他引擎。如果不设定,就按服务的默认引擎来。
- mariadb> show create table history;
- +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | Table | Create Table |
- +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | history | CREATE TABLE `history` (
- `itemid` bigint(20) unsigned NOT NULL,
- `clock` int(11) NOT NULL DEFAULT ‘0‘,
- `value` double(16,4) NOT NULL DEFAULT ‘0.0000‘,
- `ns` int(11) NOT NULL DEFAULT ‘0‘,
- KEY `history_1` (`itemid`,`clock`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
- +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- 1 row in set
mysql存储引擎
标签:table port engine col ash innodb comment 引擎 points