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. 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 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
Les mer
Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. 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.
Les mer
* Part One - Getting Started with MySQL Development: MySQL and the Open Source Revolution * Part One: Getting Started with MySQL Development: The Anatomy of a Database System * Part One: Getting Started with MySQL Development: A Tour of the MySQL Source Code * Part One - Getting Started with MySQL Development: Test-Driven MySQL Development * Part Two - Extending MySQL: Debugging * Part Two - Extending MySQL: Embedded MySQL * Part Two - Extending MySQL: Adding Functions and Commands to MySQL * Part Two - Extending MySQL: Extending MySQL High Availability * Part Two - Extending MySQL: MySQL Pluggable Authentication * Part Two - Extending MySQL: Building Your Own Storage Engine * Part Three - Advanced Database Internals: Database Systems Internals * Part Three - Advanced Database Internals: Internal Query Representation * Part Three - Advanced Database Internals: Query Optimization * Part Three - Advanced Database Internals: Query Execution
Les mer
SQL provides the internals knowledge you need to troubleshoot performance problems, improve query performance, implement high-availability and replication, and to customize My. SQL at both the plug-in and the source-code level.
Les mer

Produktdetaljer

ISBN
9781430246596
Publisert
2012-12-24
Utgave
2. utgave
Utgiver
Vendor
Apress
Høyde
254 mm
Bredde
178 mm
Aldersnivå
Popular/general, G, 01
Språk
Product language
Engelsk
Format
Product format
Heftet

Forfatter

Biographical note

Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL Development team and is the team lead for the MySQL Utilities team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. Dr. Bell is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, software engineering, and sensor networks. He spends his limited free time as a practicing Maker focusing on microcontroller projects and refinement of three-dimensional printers. Dr. Bell maintains a blog on his research projects and many other interests. You can find his blog at http://drcharlesbell.blogspot.com/.