
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.
Download link:
http://depositfiles.com/files/2458327
http://www.filefactory.com/file/242d5d/
SQL Clearly Explained, Second Edition
Malware Forensics: Investigating and Analyzing Malicious Code
Oracle PL/SQL by Example, 4th Edition
Refactoring SQL Applications
Cody's Data Cleaning Techniques Using SAS, Second Edition
SAS 9.2 SQL Procedure User's Guide
Jeremy D. Zawodny, Derek J. Balling, «High Performance MySQL»
Pro SQL Server 2008 Relational Database Design and Implementation
OCA Oracle Database 11g: Administration I Exam Guide
Oracle SQL by Example
Malware Forensics: Investigating and Ana(09-19)
Oracle PL/SQL by Example, 4th Edition(09-19)
Refactoring SQL Applications(09-19)
Cody's Data Cleaning Techniques Using SA(09-17)
SAS 9.2 SQL Procedure User's Guide(09-17)
Jeremy D. Zawodny, Derek J. Balling, &la(08-28)
Pro SQL Server 2008 Relational Database (08-28)
OCA Oracle Database 11g: Administration (08-28)
Oracle SQL by Example(08-23)
Microsoft Access 2007 Data Analysis(08-12)
Sams Teach Yourself SQL in 24 Hours (4th(08-09)
Microsoft Sql Server 2005 Changing The P(08-06)
Database Management Systems(2010)
Microsoft SQL Server 2005, The Complete (1530)
Sams Teach Yourself SQL in 24 Hours (4th(1474)
Oracle Database 10g Performance Tuning T(1403)
Database Management Systems(1301)
SQL Server 2005 Management and Administr(1157)
Oracle PL/SQL by Example, 4th Edition(1129)
OCA Oracle Database 11g: Administration (1028)
Microsoft Access 2007 Data Analysis(989)
Accelerated SQL Server 2008 (Accelerated(984)
Access 2007 VBA Programmer's Reference(965)
Practical Business Intelligence with SQL(890)
