首页 > 数据库 > mysql教程 > Difference Between InnoDB and MyISAM

Difference Between InnoDB and MyISAM

WBOY
发布: 2016-06-07 16:37:18
原创
943 人浏览过

The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction InnoDB supports some newer features: Transactions, row-level locking, foreign keys InnoDB is for high volume, high performance Most people us

  • The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction
  • InnoDB supports some newer features: Transactions, row-level locking, foreign keys
  • InnoDB is for high volume, high performance

Most people use MyISAM if they need speed and InnoDB for data integrity. You can use more than one or any combination of these table types in your database. Remember to asses the needs of your application before building it. Even though MyISAM is faster than InnoDB in the MySQL world, InnoDB is fast compared to any database engine.With InnoDB you get transactions, speed and integrity three features not usually used in the same sentence.

InnoDB?has been designed for maximum performance when processing large data volumes. Its CPU efficiency is probably not matched by any other disk-based relational database engine.

Fully integrated with MySQL Server, the?InnoDB?storage engine maintains its own buffer pool for caching data and indexes in main memory.?InnoDB?stores its tables and indexes in a tablespace, which may consist of several files (or raw disk partitions). This is different from, for example,?MyISAM?tables where each table is stored using separate files.?InnoDB?tables can be of any size even on operating systems where file size is limited to 2GB.

So, what do you think about those engines?? Please feel free to discuss it.

For more information visit?http://dev.mysql.com/

相关标签:
来源:php.cn
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板