Expert MySQL / Charles A. Bell.

Format:

Book

Author/Creator:

Bell, Charles A. (Charles Andrew), 1962-

Series:

Expert's voice in databases Expert MySQL

Language:

English

Subjects (All):

Relational databases.

SQL (Computer program language).

MySQL (Electronic resource).

Physical Description:

1 online resource (625 p.)

Edition:

2nd ed.

Place of Publication:

[Berkeley, CA ] : APress ; New York : Springer [distributor], c2012.

Language Note:

English

System Details:

text file

Summary:

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.

Contents:

Title Page; Copyright Page; Dedication Page; Contents at a Glance; Table of Contents; About the Author; About the Technical Reviewers; Acknowledgments; Introduction; Whom This Book Is For; How This Book Is Structured; Part One; Part Two; Part Three; Appendix; Using the Book for Teaching Database-Systems Internals; Conventions; Downloading the Code; Contacting the Author; Part 1 Getting Started with MySQL Development; CHAPTER 1 MySQL and The Open Source Revolution; What Is Open Source Software?; Why Use Open Source Software?; Myth 1: Commercial Proprietary Software Fosters Greater Creativity

Myth 2: Commercial Proprietary Software Is More Secure Than Open Source SoftwareMyth 3: Commercial Proprietary Software Is Tested More Than Open Source Software; Myth 4: Commercial Proprietary Systems Have More Complex Capabilities and More Complete Feature Sets Than Open Source Systems; Myth 5: Commercial Proprietary Software Vendors Are More Responsive Because They Have a Dedicated Staff; What If They Want Proof?; Is Open Source Really a Threat to Commercial Software?; Legal Issues and the GNU Manifesto; Property; The Ethical Side; Let the Revolution Continue!; Developing with MySQL

Why Modify MySQL?What Can You Modify in MySQL? Are There Limits?; MySQL's Dual License; So, Can You Modify MySQL or Not?; Guidelines for Modifying MySQL; A Real-World Example: TiVo; Summary; CHAPTER 2 The Anatomy of a Database System; Types of Database Systems; Object-Oriented Database Systems; Object-Relational Database Systems; Relational Database Systems; Relational Database System Architecture; Client Applications; Query Interface; Query Processing; Query Optimizer; Internal Representation of Queries; Query Execution; File Access; Query Results; Relational Database Architecture Summary

The MySQL Database SystemMySQL System Architecture; SQL Interface; Parser; Query Optimizer; Query Execution; Query Cache; Cache and Buffers; Table Cache; Buffer Pool; Record Cache; Key Cache; Privilege Cache; Hostname Cache; Miscellaneous; File Access via Pluggable Storage Engines; InnoDB; MyISAM; Memory; Merge; Archive; Federated; Cluster/NDB; CSV; Blackhole; Custom; Summary; CHAPTER 3 A Tour of the MySQL Source Code; Getting Started; Understanding the Licensing Options; Getting the Source Code; The MySQL Source Code; Getting Started; The mysqld_main() Function

Handling Connections and Creating ThreadsParsing the Query; Preparing the Query for Optimization; Optimizing the Query; Executing the Query; Supporting Libraries; Important Classes and Structures; The ITEM_ Class; The LEX Structure; The NET Structure; The THD Class; The READ_RECORD structure; MySQL Plugins; Installing and Uninstalling Plugins; Discovering Status of Available Plugins; Coding Guidelines; General Guidelines; Documentation; Functions and Parameters; Naming Conventions; Spacing and Indenting; Documentation Utilities; Keeping an Engineering Logbook; Tracking Your Changes

Building the System for the First Time

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

9781430246602

143024660X

OCLC:

831115705