Mysql 知识点

Innodb 内存结构： https://dev.mysql.com/doc/refman/8.0/en/innodb-in-memory-structures.html

　　Buffer Pool：innodb-buffer-pool

　　　　The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed.

　　　　The buffer pool permits frequently used data to be accessed directly from memory, which speeds up processing.

　　　　On dedicated servers, up to 80% of physical memory is often assigned to the buffer pool.

　　Change Buffer：innodb-change-buffer

　　　　The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer pool.

　　Adaptive Hash Index：innodb-adaptive-hash

　　　　The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or reliability. 

　　Log Buffer：innodb-redo-log-buffer

　　　　The log buffer is the memory area that holds data to be written to the log files on disk. 

 

Innodb 锁：https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html

 

Innodb 事务隔离：https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html