Netty
Database: a set of physics operation system file or other types file.
Instance: MySQL database is composed of backstage threads and a area of share memory.
InnoDB
Backstage Threads:
- Master Thread: flush data in buffer pool into disk.
- IO Thread: process AIO’s callback. include 4 write threads, 4 read threads, 1 insert buffer thread, adn 1 log IO thread.
- Purge Thread: collect undo log.
- Page Cleaner Thread: flush dirty page.
Memory:
- buffer pool: data page, index page, insert buffer, adaptive hash index, lock info, data dictionary.
- LRU List, Free List, and Flush List.
- redo log buffer
- additional memory pool
Checkpoint