高性能mysql英文版-第三版

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