MySQL can store data in files (memory) in different technologies, a technique known as the storage engine. Each storage engine uses different storage mechanisms, indexing techniques, and locking levels to provide the widest range of features. MySQL-supported storage engine: Concurrent processing concurrency control of MyISAM, Inodb, Memory, CSV, Archive related knowledge ensure data consistency and integrity when multiple connections modify records. Note: Understanding of concurrency Control: If two users access the same record at the same time, a delete, a read, this time will be an error. Concurrency control is used at this time. When processing concurrent reads or concurrent writes, the system takes a lock system to resolve. Shared lock (read lock): During the same time period, multiple users can read the same resource without any changes to the data during the read. Exclusive (write-lock): Only one user can write to a resource at any time, while a write lock will block other read or write lock operations. Lock particle: Table lock, which is a locking strategy with minimal overhead. Row locks, which is the most expensive lock policy. Things: Things are used to ensure the integrity of the database. The nature of Things: atomicity (atomicity) Consistency (consistency) isolation (isolation) persistence (durability) index index is a structure that sorts the values of one or more columns in a data table. Storage Engine Knowledge Point summary: MyISAM: storage limit up to 256TB, support index, table level lock, data compression. INNODB: Storage limit is 64TB, things and indexes are supported, lock grain is row lock.
The MySQL-based storage engine