Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Książki \ Bazy danych \ MySQL

Understanding MySQL Internals Język: 2


Cena Brutto: 221.24

Cena netto: 210.70

Wersja: Drukowana
Autor Sasha Pachev
Liczba_stron 256
Wydawnictwo OReilly Media
Data_Wydania 2007-04-10
Poziom All Levels

Informacje podstawowe:

  • Wydawnictwo: O'Reilly Media
  • Data wydania: 10 kwietnia 2007
  • Liczba stron: 256
  • Autor/autorzy:
    • Sasha Pachev


Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev - a former member of the MySQL Development Team - provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.

The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:

  • Core server classes, structures, and API
  • The communication protocol between the client and the server
  • Configuration variables, the controls of the server; includes a tutorial on how to add your own
  • Thread-based request handling - understanding threads and how they are used in MySQL
  • An overview of MySQL storage engines
  • The storage engine interface for integrating third-party storage engines
  • The table lock manager
  • The parser and optimizer for improving MySQL's performance
  • Integrating a transactional storage engine into MySQL
  • The internals of replication

Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.

O autorze/autorach:

Sasha Pachev

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 bookMySQL Enterprise Solutions. He currently lives in Provo, Utah with his wife Sarah and his five children working as an independent consultant with the emphasis onMySQL.

In spite of his great interest in computers, Sasha is equallypassionate 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 sitehttp://FastRunningBlog.Comdedicated to that purpose.

View Sasha Pachev's full profile page.

Zawartość (spis treści):

  1. Chapter 1 MySQL History and Architecturel

    1. MySQL History
    2. MySQL Architecture
  2. Chapter 2 Nuts and Bolts of Working with the MySQL Source Code

    1. Unix Shell
    2. BitKeeper
    3. Preparing the System to Build MySQL from BitKeeper Tree
    4. Building MySQL from BitKeeper Tree
    5. Building from Source Distribution
    6. Installing MySQL into a System Directory
    7. Source Code Directory Layout
    8. Preparing the System to Run MySQL in a Debugger
    9. Debugger-Guided Source Tour
    10. Basics of Working with gdb
    11. Finding Things in the Source
    12. Interesting Breakpoints and Variables
    13. Making a Source Modification
    14. Coding Guidelines
    15. Keeping Your BitKeeper Repository Up to Date
    16. Submitting a Patch
  3. Chapter 3 Core Classes, Structures, Variables, and APIs

    1. THD
    2. NET
    3. TABLE
    4. Field
    5. Utility API Calls
    6. Preprocessor Macros
    7. Global Variables
  4. Chapter 4 Client/Server Communication

    1. Protocol Overview
    2. Packet Format
    3. Relationship Between MySQL Protocol and OS Layer
    4. Authenticating Handshake
    5. Command Packet
    6. Server Responses
  5. Chapter 5 Configuration Variables

    1. Configuration Variables Tutorial
    2. Interesting Aspects of Specific Configuration Variables
  6. Chapter 6 Thread-Based Request Handling

    1. Threads Versus Processes
    2. Implementation of Request Handling
    3. Thread Programming Issues
  7. Chapter 7 The Storage Engine Interface

    1. The handler Class
    2. Adding a Custom Storage Engine to MySQL
  8. Chapter 8 Concurrent Access and Locking

    1. Table Lock Manager
  9. Chapter 9 Parser and Optimizer

    1. Parser
    2. Optimizer
  10. Chapter 10 Storage Engines

    1. Shared Aspects of Architecture
    2. InnoDB
    3. Memory (Heap)
    4. MyISAM Merge
    5. NDB
    6. Archive
    7. Federated
  11. Chapter 11 Transactions

    1. Overview of Transactional Storage Engine Implementation
    2. Implementing the handler Subclass
    3. Defining the handlerton
    4. Working with the Query Cache
    5. Working with the Replication Binary Log
    6. Avoiding Deadlocks
  12. Chapter 12 Replication

    1. Overview
    2. Statement-Based Versus Row-Based Replication
    3. Two-Threaded Slave
    4. Multi-Master
    5. SQL Commands to Help Understand Replication
    6. Binary Log Format
    7. Creating a Custom Replication Utility
  1. Colophon

Produkty Podobne
PHP, MySQL i JavaScript. Wprowadzenie. Wydanie V
PHP i MySQL. Dynamiczne strony WWW. Szybki start. Wydanie V
PHP i MySQL. Tworzenie stron WWW. Vademecum profesjonalisty. Wydanie V
PHP i MySQL. Dla każdego. Wydanie III
PHP and MySQL Web Development, 5th Edition
The Language of SQL, 2nd Edition
Getting Started with SQL
PHP, MySQL i JavaScript. Wprowadzenie. Wydanie IV
Learning MySQL and MariaDB
Learning PHP, MySQL & JavaScript, 4th Edition
Więcej produktów