{"product_id":"understanding-mysql-internals-9780596009571","title":"Understanding MySQL Internals","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eProvides a tour of MySQL 5 that shows you its inner workings. This work helps you learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and more. It also gives an Architecture Overview that provides an introduction of how the different components of MySQL work together.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003ePreface    1. MySQL History and Architecture     MySQL History     MySQL Architecture    2. 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 Debugger     Debugger-Guided Source Tour     Basics of Working with gdb     Finding Things in the Source     Interesting Breakpoints and Variables     Making a Source Modification     Coding Guidelines     Keeping Your BitKeeper Repository Up to Date     Submitting a Patch    3. Core Classes, Structures, Variables, and APIs     THD     NET     TABLE     Field     Utility API Calls     Preprocessor Macros     Global Variables     4. Client\/Server Communication     Protocol Overview     Packet Format     Relationship Between MySQL Protocol and OS Layer     Authenticating Handshake     Command Packet     Server Responses     5. Configuration Variables     Configuration Variables Tutorial     Interesting Aspects of Specific Configuration Variables    6. Thread-Based Request Handling     Threads Versus Processes     Implementation of Request Handling     Thread Programming Issues     7. The Storage Engine Interface     The handler Class     Adding a Custom Storage Engine to MySQL  8. Concurrent Access and Locking     Table Lock Manager  9. Parser and Optimizer     Parser     Optimizer    10. Storage Engines     Shared Aspects of Architecture     InnoDB     Memory (Heap)     MyISAM Merge     NDB     Archive     Federated  11. Transactions     Overview of Transactional Storage Engine Implementation     Implementing the handler Subclass     Defining the handlerton     Working with the Query Cache     Working with the Replication Binary Log     Avoiding Deadlocks    12. Replication     Overview     Statement-Based Versus Row-Based Replication     Two-Threaded Slave     Multi-Master     SQL Commands to Help Understand Replication     Binary Log Format     Creating a Custom Replication Utility    Index","brand":"O'Reilly","offers":[{"title":"Default Title","offer_id":49917752246615,"sku":"9780596009571","price":29.99,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780596009571.jpg?v=1738449061","url":"https:\/\/bookcurl.com\/products\/understanding-mysql-internals-9780596009571","provider":"Book Curl","version":"1.0","type":"link"}