{"product_id":"9781430246602","title":"Expert MySQL","description":"\u003cp\u003e    \u003cem\u003eExpert MySQL\u003c\/em\u003e is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. \u003cem\u003eExpert MySQL\u003c\/em\u003e is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code.\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  \u003cem\u003eExpert MySQL\u003c\/em\u003e is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You'll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making \u003cem\u003eExpert MySQL\u003c\/em\u003e a must-have book for anyone doing high-end work involving MySQL.  \u003c\/p\u003e\u003cul\u003e   \u003cli\u003eShows how to customize MySQL and its storage and authentication engines \u003c\/li\u003e   \u003cli\u003eProvides in-depth knowledge of internals for use in query tuning and performance troubleshooting \u003c\/li\u003e   \u003cli\u003eCovers high-end features such as high-availability and replication \u003c\/li\u003e  \u003c\/ul\u003e           What you’ll learn\u003cul\u003e   \u003cli\u003eLearn the inner workings of MySQL \u003c\/li\u003e   \u003cli\u003eDiagnose and improve poorly performing queries \u003c\/li\u003e   \u003cli\u003eImplement high-availablity solutions and replication \u003c\/li\u003e   \u003cli\u003eModify and debug the server code \u003c\/li\u003e   \u003cli\u003eBuild your own pluggable storage engines and authentication modules \u003c\/li\u003e   \u003cli\u003eImplement new SQL functions and syntax \u003c\/li\u003e   \u003cli\u003eBuild your own query optimizer \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003eExpert MySQL\u003c\/em\u003e is written for systems integrators, software developers, and database administrators who are using MySQL and desire a deeper knowledge of MySQL internals in support of high-end work such as performance troubleshooting, customization of the engine and its plugins, query optimizaion, building of high-availability environments, replication of data, and so forth.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003ePart One - Getting Started with MySQL Development: MySQL and the Open Source Revolution \u003c\/li\u003e   \u003cli\u003ePart One: Getting Started with MySQL Development: The Anatomy of a Database System \u003c\/li\u003e   \u003cli\u003ePart One: Getting Started with MySQL Development: A Tour of the MySQL Source Code \u003c\/li\u003e   \u003cli\u003ePart One - Getting Started with MySQL Development: Test-Driven MySQL Development \u003c\/li\u003e   \u003cli\u003ePart Two - Extending MySQL: Debugging \u003c\/li\u003e   \u003cli\u003ePart Two - Extending MySQL: Embedded MySQL \u003c\/li\u003e   \u003cli\u003ePart Two - Extending MySQL: Adding Functions and Commands to MySQL \u003c\/li\u003e   \u003cli\u003ePart Two - Extending MySQL: Extending MySQL High Availability \u003c\/li\u003e   \u003cli\u003ePart Two - Extending MySQL: MySQL Pluggable Authentication \u003c\/li\u003e   \u003cli\u003ePart Two - Extending MySQL: Building Your Own Storage Engine \u003c\/li\u003e   \u003cli\u003ePart Three - Advanced Database Internals: Database Systems Internals \u003c\/li\u003e   \u003cli\u003ePart Three - Advanced Database Internals: Internal Query Representation \u003c\/li\u003e   \u003cli\u003ePart Three - Advanced Database Internals: Query Optimization \u003c\/li\u003e   \u003cli\u003ePart Three - Advanced Database Internals: Query Execution \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47134112022768,"sku":"9781430246602","price":47.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430246602_p0.jpg?v=1763751921","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430246602","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}