Expert MySQL 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. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code. Expert MySQL is also a wealth of information on key aspects of MySQL internals. If youave ever needed to somehow make a query go faster, or diagnose a poorly performing application, then the information in this book is invaluable. Youall 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. High-availability and replication are also covered, making Expert MySQL a must-have book for anyone doing high-end work involving MySQL. Shows how to customize MySQL and its storage and authentication engines Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting Covers high-end features such as high-availability and replication What youall learn Learn the internal workings of MySQL Diagnose and improve poorly performing queries Implement high-availablity solutions and replication Modify and debug the server code Build your own pluggable storage engines and authentication modules Implement new SQL functions and syntax Who this book is for Expert MySQL 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.Unireg, a format created by a founder of MySQL, was once used for writing TTY applications. ... Fortunately, there are efforts under way to decipher the FRM files via a Python utility that is part of the MySQL Utilities plugin for MySQL Workbench . ... InnoDB installation, consult the aquot;InnoDB Performance Tuning and Troubleshootingaquot; section in the online reference manual for InnoDB tuning best practices.
|Publisher||:||Apress - 2012-12-19|