Understanding MySQL Internals

Understanding MySQL Internals
Author :
Publisher : "O'Reilly Media, Inc."
Total Pages : 257
Release :
ISBN-10 : 9780596552800
ISBN-13 : 0596552807
Rating : 4/5 (807 Downloads)

Book Synopsis Understanding MySQL Internals by : Sasha Pachev

Download or read book Understanding MySQL Internals written by Sasha Pachev and published by "O'Reilly Media, Inc.". This book was released on 2007-04-10 with total page 257 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.


Understanding MySQL Internals Related Books

Understanding MySQL Internals
Language: en
Pages: 257
Authors: Sasha Pachev
Categories: Computers
Type: BOOK - Published: 2007-04-10 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

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 Pa
Understanding MySQL Internals
Language: en
Pages: 257
Authors: Alexander Pachev
Categories: Computers
Type: BOOK - Published: 2007-04-10 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

Like the bestselling "Understanding the Linux Kernel," this new guide goes to the heart of the MySQL database, another leading open source software project.
Database Internals
Language: en
Pages: 373
Authors: Alex Petrov
Categories: Computers
Type: BOOK - Published: 2019-09-13 - Publisher: O'Reilly Media

DOWNLOAD EBOOK

When it comes to choosing, using, and maintaining a database, understanding its internals is essential. But with so many distributed databases and tools availab
High Performance MySQL
Language: en
Pages: 389
Authors: Silvia Botros
Categories: Computers
Type: BOOK - Published: 2021-10-18 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to de
MySQL Troubleshooting
Language: en
Pages: 265
Authors: Sveta Smirnova
Categories: Computers
Type: BOOK - Published: 2012-02-08 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The