Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

Ajouter à une liste

Librairie Eyrolles - Paris 5e



Discovering and Improving a Great Database

Sasha Pachev

254 pages, parution le 01/04/2007


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.

L'auteur - Sasha Pachev

Alexander "Sasha" Pachev has worked extensively with Linux since 1997 on corporate web servers, database servers, and desktops. Around that time he started working with the MySQL database, which led him to joining the MySQL Development Team in 2000. He wrote and maintained the MySQL replication module up until 2002 and authored "MySQL Enterprise Solutions" (Wiley). Sasha is also an elite marathon runner and has developed several software tools of interest to runners.


  • MySQL History and Architecture
  • Nuts and Bolts with the MySQL Source Code
  • Core Classes, Structures, Variables, and APIs
  • Client/Server Communication
  • Configuration Variables
  • Thread-Based Request Handling
  • The Storage Engine Interface
  • Concurrent Access and Locking
  • Parser and Optimizer
  • Storage Engines
  • Transactions
  • Replication
Voir tout

Caractéristiques techniques

Éditeur(s) O'Reilly
Auteur(s) Sasha Pachev
Parution 01/04/2007
Nb. de pages 254
Couverture Broché
Poids 423g
Intérieur Noir et Blanc
EAN13 9780596009571
ISBN13 978-0-593-00957-1


Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients 0 321 79 56 75
librairie française
Librairie française depuis 1925