MySQL tutorials the difference between-myisam and InnoDB

MySQL the table type MyISAM and the InnoDB The biggest difference is that InnoDB of support transactions. Brother Lian Education (www.lampbrother.net

To give you a comparison:

InnoDB support for some new features: trading, row-level locks, foreign keys

InnoDB is high-capacity, high-performance

Most people use MyISAM table, if they need speed and InnoDB the integrity of the data. You can use more than one or any combination of these table types in your database. Keep in mind that the donkey is in the building before your application needs it. Even if MyISAM is faster than in the InnoDB Worldof MySQL ,InnoDB is faster than any of the databases engine. Trading with InnoDB , speed and integrity three features are usually not used in the same sentence.

InnoDB The maximum performance that has been designed to handle large amounts of data. Any other disk-based relational database engine, its CPU efficiency may not match.

fully integrated, InnoDB Storage Engine and MySQL The server caches the data and indexes in the main memory to maintain its own buffer pool. InnoDB tables and indexes are stored in a tablespace, which may include several files (or raw disk partitions). This is different, for example,theMyISAM table, where each table is stored in a separate file. the InnoDB table can be any size, even if the file size is limited to 2GB on the operating system.

MySQL tutorials the difference between-myisam and InnoDB