Mysqlinnodb and MyISAM Two types of storage we can make it in the options when MySQL creates the table, as shown in:
Here's the difference between the two types of storage:
1. Two kinds of data storage transaction mechanism are different
InnoDB support transactions, MyISAM not supported, but MyISAM performance in terms of queries notch above
2, the mechanism of the lock is different
InnoDB is a row-level lock, which can support concurrent operation more; MyISAM is a table-level lock
3, data operation aspects
Modify, add, delete data use InnoDB performance higher, large data volume query using MYISAM performance higher
InnoDB does not save the number of data in the table when querying the number of database bars, it is recalculated each time, MyISAM saves the total number of bars per table, and does not need to be recalculated each time it is queried
At the time of query InnoDB will load a lot of things than MyISAM, for example: InnoDB will cache data block, MyISAM only cache index block; InnoDB addressing is through mapping, MyISAM is via offset
4, Storage aspects
InnoDB resources are based on tablespace data files and log files, and size is limited to the operating system file size
MyISAM stored on disk as a file:. frm storage table definition;. myd data file;. myi index file
MySQL Learning--innodb and MyISAM