Hướng dẫn understanding mysql internals pdf

Abstract

This is the MySQL Internals Manual.

For legal information, see the Legal Notice.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2022-04-27 (revision: 582)

Book description

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.

Running a transactional Database on top of RamCloud

• Computer Science

• 2012

This thesis presents a relational and transactional database system which uses a key-value store instead of a hard drive disk as storage which provides better elasticity and scalability than traditional disk based architecures without making any compromises in the consistency guarantees.

Database replication in large scale systems

• Miguel Araujo

• Computer Science

• 2011

The proposed solution extends the MySQL Proxy tool with plugins combined with the Spread group communication system offering, transparently, active and passive replication, and uses the reference workload defined by the TPC-C benchmark, widely used to measure the performance of commercial databases.

The big data ecosystem at LinkedIn

• Roshan SumbalyJay KrepsSam Shah

• Computer Science

  SIGMOD '13

• 2013

LinkedIn's Hadoop-based analytics stack is presented, which allows data scientists and machine learning researchers to extract insights and build product features from massive amounts of data, and solutions to the ``last mile'' issues in providing a rich developer ecosystem are presented.

Approach for analysis of Streaming Data

• M. Gupta

• Computer Science

• 2014

The performance estimates presented in this paper would help in understanding what to expect from two widely used open source RDBMS, MySQL and PostgreSQL, in terms of data insertion rates, indexing time, data sizes, index sizes and query performance.

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.