- 论坛徽章:
- 2
|
本帖最后由 badb0y 于 2012-05-02 16:30 编辑
1.Mysql支持的引擎有哪些?各有哪些特性?如何查看哪些引擎可用?
myisam 查询多的站点,官方新闻站用这个
innodb 支持事务,收费系统用这个
spider 可以像数据分区一样,可以把数据分布到后端的MYSQL上。
查看支持引擎
[root@akin ~]# mysql -uroot -pgoogle123 -e "show engines;"
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| SPIDER | YES | Spider storage engine | YES | YES | NO |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
|
|