Cargando…
Understanding MySQL internals /
Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figur...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Farnham :
O'Reilly,
2006.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Table of Contents; Preface; How This Book Is Organized; Who This Book Is For; Conventions Used in This Book; Using Code Examples; Comments and Questions; Safari® Enabled; Acknowledgments; MySQL History and Architecture; MySQL History; MySQL Architecture; Core Modules; Interaction of the Core Modules; Detailed Look at the Core Modules; Server Initialization Module; Connection Manager; Thread Manager; Connection Thread; User Authentication Module; Access Control Module; Parser; Command Dispatcher; Query Cache Module; Optimizer; Table Manager; Table Modification Modules; Table Maintenance Module
- Status Reporting ModuleAbstracted Storage Engine Interface (Table Handler); Storage Engine Implementations (MyISAM, InnoDB, MEMORY, Berkeley DB); Logging Module; Replication Master Module; Replication Slave Module; Client/Server Protocol API; Low-Level Network I/O API; Core API; Nuts and Bolts of Working with the MySQL Source Code; Unix Shell; BitKeeper; Preparing the System to Build MySQL from BitKeeper Tree; Building MySQL from BitKeeper Tree; Building from Source Distribution; Installing MySQL into a System Directory; Source Code Directory Layout
- Preparing the System to Run MySQL in a DebuggerDebugger-Guided Source Tour; Basics of Working with gdb; Finding Things in the Source; Interesting Breakpoints and Variables; Making a Source Modification; Coding Guidelines; Stability; Portability; Performance; Style and Ease of Integration; Keeping Your BitKeeper Repository Up to Date; Submitting a Patch; Core Classes, Structures, Variables, and APIs; THD; NET; TABLE; Field; Utility API Calls; Preprocessor Macros; Global Variables; Client/Server Communication; Protocol Overview; Packet Format; Relationship Between MySQL Protocol and OS Layer
- Authenticating HandshakeAuthentication Protocol Security; Protocol Capabilities Bit Mask; Command Packet; Server Responses; Data Field; OK Packet; Error Packet; EOF Packet; Result Set Packets; Configuration Variables; Configuration Variables Tutorial; Configuration File and Command-Line Options; Internals of the Configuration Option Parsing; Example of Adding a New Configuration Option; Interesting Aspects of Specific Configuration Variables; big-tables; concurrent-insert; core-file; default-storage-engine; delay-key-write; ft_stopword_file; innodb_buffer_pool_size
- Innodb_flush_log_at_trx_commitinnodb_file_per_table; innodb_lock_wait_timeout; innodb_force_recovery; init-file; key_buffer_size; language; log; log-bin; log-isam; log-slow-queries; max_allowed_packet; max_connections; max_heap_table_size; max_join_size; max_sort_length; myisam-recover; query_cache_type; read_buffer_size; relay-log; server-id; skip-grant-tables; skip-stack-trace; slave-skip-errors; sort_buffer_size; sql-mode; table_cache; temp-pool; transaction-isolation; Thread-Based Request Handling; Threads Versus Processes; Advantages of Using Threads; Disadvantages of Using Threads