{"product_id":"understanding-mysql-internals-discovering-and-improving-a-great-database-paperback-1","title":"Understanding MySQL Internals: Discovering and Improving a Great Database - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eSasha Pachev\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eAlthough 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 figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.\u003c\/p\u003e\u003cbr\u003e \u003cbr\u003e \u003cp\u003eThe core of \u003cem\u003eUnderstanding MySQL Internals\u003c\/em\u003e begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover: \u003cbr\u003e \u003cbr\u003e \u003c\/p\u003e\u003cul\u003e\n\u003cbr\u003e \u003cbr\u003e \u003cli\u003eCore server classes, structures, and API\u003c\/li\u003e \u003cli\u003eThe communication protocol between the client and the server\u003c\/li\u003e \u003cli\u003eConfiguration variables, the controls of the server; includes a tutorial on how to add your own\u003c\/li\u003e \u003cli\u003eThread-based request handling -- understanding threads and how they are used in MySQL\u003c\/li\u003e \u003cli\u003eAn overview of MySQL storage engines\u003c\/li\u003e \u003cli\u003eThe storage engine interface for integrating third-party storage engines\u003c\/li\u003e \u003cli\u003eThe table lock manager\u003c\/li\u003e \u003cli\u003eThe parser and optimizer for improving MySQL's performance\u003c\/li\u003e \u003cli\u003eIntegrating a transactional storage engine into MySQL\u003c\/li\u003e \u003cli\u003eThe internals of replication\u003c\/li\u003e\n\u003cbr\u003e \u003cbr\u003e \u003c\/ul\u003e \u003cbr\u003e \u003cbr\u003e \u003cp\u003e\u003cem\u003eUnderstanding MySQL Internals\u003c\/em\u003e provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 254\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.61 x 9.16 x 7.1 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e May 15, 2007\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":52491614814515,"sku":"9780596009571","price":56.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0300\/5595\/6612\/files\/S0FTUFlPZGJhRnA0bTdEWnIybWh6Zz09_faf4f58b-c1f1-4d0e-b87e-1b7edbbbca59.webp?v=1759921111","url":"https:\/\/www.vysn.com\/products\/understanding-mysql-internals-discovering-and-improving-a-great-database-paperback-1","provider":"VYSN","version":"1.0","type":"link"}