MySQL表类型MyISAM和InnoDB的区别


mysql表类型myisam和innodb的区别
查找相关文章:myisam innodb mysql

The big  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.


谷歌翻译了一下


MySQL的表类型MyISAM和InnoDB之间的最大区别是,InnoDB的支持事务

InnoDB支持一些新的功能:交易,行级锁,外键

InnoDB是高容量,高性能的

大多数人使用MyISAM表,如果他们需要速度和InnoDB数据的完整性。您可以使用超过一个或任意组合这些在你的数据库中的表类型。请记住,驴在建设之前,您的应用程序的需求。即使MyISAM是速度比在MySQL的InnoDB的世界,InnoDB是比较快的任何的数据库engine.With InnoDB的交易,速度和完整性三个功能通常不会在同一个句子中使用。


InnoDB的已被设计为处理大数据量时的最大性能。任何其他基于磁盘的关系数据库引擎,它的CPU效率可能不匹配。


完全整合,InnoDB存储引擎与MySQL服务器在主内存中缓存数据和索引维护自己的缓冲池。 InnoDB的表和索引存储在表空间中,这可能包括几个文件(或原始磁盘分区)。这是不同的,例如,MyISAM表,其中每个表存储使用单独的文件中。 InnoDB表可以是任何尺寸,即使文件大小限制为2GB的操作系统上。