Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
1. MySQL Architecture and History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
MySQL’s Logical Architecture 1
Connection Management and Security 2
Optimization and Execution 3
Concurrency Control 3
Read/Write Locks 4
Lock Granularity 4
Transactions 6
Isolation Levels 7
Deadlocks 9
Transaction Logging 10
Transactions in MySQL 10
Multiversion Concurrency Control 12
MySQL’s Storage Engines 13
The InnoDB Engine 15
The MyISAM Engine
2021-06-18 15:04:09
6.33MB
mysql
1