Chinaunix首页 | 论坛 | 博客
  • 博客访问: 347593
  • 博文数量: 93
  • 博客积分: 2322
  • 博客等级: 大尉
  • 技术积分: 1600
  • 用 户 组: 普通用户
  • 注册时间: 2012-08-27 10:23
文章分类

全部博文(93)

文章存档

2018年(12)

2012年(81)

分类: Mysql/postgreSQL

2012-08-28 15:36:38

一般情况下,mysql会默认提供多种存储引擎,你可以通过下面的查看:

看你的mysql现在已提供什么存储引擎:

mysql> show engines;

看你的mysql当前默认的存储引擎:mysql> show variables like '%storage_engine%';

你要看某个表用了什么引擎(在显示结果里参数engine后面的就表示该表当前用的存储引擎):

mysql> show create table 表名;

mysql> show engines;

+------------+---------+----------------------------------------------------+

| Engine | Support | Comment |

+------------+---------+-----------------------------------------------------+

| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |

| HEAP | YES | Alias for MEMORY |

| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |

| MERGE | YES | Collection of identical MyISAM tables |

| MRG_MYISAM | YES | Alias for MERGE |

| ISAM | NO | Obsolete storage engine, now replaced by MyISAM |

| MRG_ISAM | NO | Obsolete storage engine, now replaced by MERGE |

| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |

| INNOBASE | YES | Alias for INNODB |

| BDB | NO | Supports transactions and page-level locking |

| BERKELEYDB | NO | Alias for BDB |

| NDBCLUSTER | NO | Clustered, fault-tolerant, memory-based tables |

| NDB | NO | Alias for NDBCLUSTER |

| EXAMPLE | NO | Example storage engine |

| ARCHIVE | NO | Archive storage engine |

| CSV | NO | CSV storage engine |

+------------+---------+-------------------------------------------------------+

阅读(1670) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~