Expert MySQL
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...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, CA ] : New York :
APress ; Springer [distributor]
c2012.
|
| Edición: | 2nd ed |
| Colección: | Expert's voice in databases Expert MySQL
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629660506719 |
Tabla de Contenidos:
- 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
