High Performance MySQL
https://gyazo.com/074dc0b9981fef517d8686db3c37650d
ebiken.icon2022出版予定がアーリーリリースで少し読めた
Architecture
https://gyazo.com/a6bc8b47a59597b8283e47e48a8e27de
Concurrency Control
Read/Write Locks
Lock Granularity
table, row
Transactions
AUTOCOMMIT mode
single insert/update/delete statement is implicity wrapped in a transaction by default
Replications
pull model
replicas periodically query the source host for the latest binary logs (binlog) as neeed
Storage Engine
handles persistence of data
MVCC (multiversion concurrency control) keep a snapshot of the data as it existed at some point in time
OS, Hardware Optimization
Optimize Server Settings
Optimize Schema and Data Types