Now Australia's Biggest Toy Store

We won't be beaten by anyone. Guaranteed

Understanding MySQL Internals
By

Rating

Product Description
Product Details

Table of Contents

Preface 1. MySQL History and Architecture MySQL History MySQL Architecture 2. Nuts and Bolts of Working with the MySQL Source Code Unix Shell BitKeeper Preparing the System to Build MySQL from BitKeeper Tree Building MySQL from BitKeeper Tree Building from Source Distribution Installing MySQL into a System Directory Source Code Directory Layout Preparing the System to Run MySQL in a Debugger Debugger-Guided Source Tour Basics of Working with gdb Finding Things in the Source Interesting Breakpoints and Variables Making a Source Modification Coding Guidelines Keeping Your BitKeeper Repository Up to Date Submitting a Patch 3. Core Classes, Structures, Variables, and APIs THD NET TABLE Field Utility API Calls Preprocessor Macros Global Variables 4. Client/Server Communication Protocol Overview Packet Format Relationship Between MySQL Protocol and OS Layer Authenticating Handshake Command Packet Server Responses 5. Configuration Variables Configuration Variables Tutorial Interesting Aspects of Specific Configuration Variables 6. Thread-Based Request Handling Threads Versus Processes Implementation of Request Handling Thread Programming Issues 7. The Storage Engine Interface The handler Class Adding a Custom Storage Engine to MySQL 8. Concurrent Access and Locking Table Lock Manager 9. Parser and Optimizer Parser Optimizer 10. Storage Engines Shared Aspects of Architecture InnoDB Memory (Heap) MyISAM Merge NDB Archive Federated 11. Transactions Overview of Transactional Storage Engine Implementation Implementing the handler Subclass Defining the handlerton Working with the Query Cache Working with the Replication Binary Log Avoiding Deadlocks 12. Replication Overview Statement-Based Versus Row-Based Replication Two-Threaded Slave Multi-Master SQL Commands to Help Understand Replication Binary Log Format Creating a Custom Replication Utility Index

About the Author

Sasha Pachev graduated from the Brigham Young University in 1998 with a degree in Computer Science, worked on the MySQL development team in 2000-2002, and was the original developer of replication in MySQL. In 2003 he wrote his first book MySQL Enterprise Solutions. He currently lives in Provo, Utah with his wife Sarah and his five children working as an independent consultant with the emphasis on MySQL.

In spite of his great interest in computers, Sasha is equally passionate about distance running. He has won a number of marathons, has a personal best of 2:24:47, and is attempting to qualify for the US Olympic Trials. He feels it is important to help other runners reach their potential, and operates a web site http: //FastRunningBlog.Com dedicated to that purpose.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Understanding MySQL Internals on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond.com, Inc.
Back to top