:: DEVELOPER ZONE

Login / Register

MySQL Internals Manual

MySQL Internals Manual

MySQL Internals Manual

Previous / Next / Up / Table of Contents

MySQL Internals Manual

Table of Contents

1. A Guided Tour Of The MySQL Source Code

2. Coding Guidelines

3. The Optimizer

3.1. The Index Merge Join Type

3.1.1. Overview
3.1.2. Index Merge Optimizer
3.1.3. Row Retrieval Algorithm

4. Important Algorithms and Structures

4.1. The Item class
4.2. How MySQL Does Sorting (filesort)
4.3. Bulk Insert
4.4. How MySQL Does Caching
4.5. How MySQL Uses the Join Buffer Cache
4.6. How MySQL Handles FLUSH TABLES
4.7. Full-text Search
4.8. FLOAT and DOUBLE data types and their representation.
4.9. Functions in the mysys Library

5. The different column types in MySQL

5.1. VARCHAR type

6. How MySQL Performs Different Selects

6.1. Steps of Select Execution
6.2. select_result Class
6.3. SIMPLE or PRIMARY SELECT
6.4. Structure Of Complex Select
6.5. Non-Subquery UNION Execution
6.6. Derived Table Execution
6.7. Subqueries
6.8. Single Select Engine
6.9. Union Engine
6.10. Special Engines
6.11. Explain Execution

7. How MySQL Transforms Subqueries

7.1. Item_in_subselect::select_transformer

7.1.1. Scalar IN Subquery
7.1.2. Row IN Subquery

7.2. Item_allany_subselect

7.3. Item_singlerow_subselect

8. MySQL Client/Server Protocol

8.1. Raw Packet Without Compression

8.2. Raw Packet With Compression

8.3. Basic Packets

8.3.1. OK Packet
8.3.2. Error Packet

8.4. Communication

8.5. Fieldtype Codes

8.6. Functions Used to Implement the Protocol

8.7. Another Description of the Protocol

8.8. Changes to 4.0 Protocol in 4.1

8.9. 4.1 Field Description Packet

8.10. 4.1 Field Description Result Set

8.11. 4.1 OK Packet

8.12. 4.1 End Packet

8.13. 4.1 Error Packet

8.14. 4.1 Prepared Statement Init Packet

8.15. 4.1 Long Data Handling

8.16. 4.1 Execute

8.17. 4.1 Binary Result Set

9. Replication

9.1. Main Code Files

9.2. The Binary Log

9.3. Replication Threads

9.3.1. The Slave I/O Thread
9.3.2. The Slave SQL Thread
9.3.3. Why 2 Threads?
9.3.4. The Binlog Dump Thread

9.4. How Replication Deals With...

9.4.1. auto_increment Columns, LAST_INSERT_ID()
9.4.2. User Variables (Since 4.1)
9.4.3. System Variables
9.4.4. Some Functions
9.4.5. Non-repeatable UDF Functions
9.4.6. Prepared Statements
9.4.7. Temporary Tables
9.4.8. LOAD DATA [LOCAL] INFILE (Since 4.0)

9.5. How a Slave Asks Its Master to Send Its Binary Log

9.6. Network Packets in Detail

9.7. Replication Event Format in Detail

9.7.1. The Common Header
9.7.2. The “Post-headers” (Event-specific Headers)

9.8. Plans for MySQL 5.0

10. MyISAM Record Structure

10.1. Introduction
10.2. Physical Attributes of Columns
10.3. Where to Look For More Information

11. The .MYI file

11.1. MyISAM Files

12. MyISAM Compressed Data File Layout

12.1. Huffman compression
12.2. The myisampack Program
12.3. Record and Blob Length Encoding
12.4. Code Tree Representation
12.5. Usage of the Index File
12.6. myisampack Tricks
12.7. Detailed Specification of the Decoding:

13. InnoDB Record Structure

13.1. High-Altitude Picture

13.1.1. FIELD START OFFSETS
13.1.2. EXTRA BYTES
13.1.3. FIELD CONTENTS

13.2. Where to Look For More Information

14. InnoDB Page Structure

14.1. High-Altitude View

14.1.1. Fil Header
14.1.2. Page Header
14.1.3. The Infimum and Supremum Records
14.1.4. User Records
14.1.5. Free Space
14.1.6. Page Directory
14.1.7. Fil Trailer

14.2. Example

14.3. Where to Look For More Information

15. Adding New Error Messages to MySQL

16. Annotated List of Files in the MySQL Source Code Distribution

16.1. Directory Listing

16.1.1. The BDB Directory
16.1.2. The BitKeeper Directory
16.1.3. The BUILD Directory
16.1.4. The Build-tools Directory
16.1.5. The client Directory
16.1.6. The cmd-line-utils Directory
16.1.7. The dbug Directory
16.1.8. The Docs Directory
16.1.9. The extra Directory
16.1.10. The heap Directory
16.1.11. The include Directory
16.1.12. The innobase Directory
16.1.13. The libmysql Directory
16.1.14. The libmysql_r Directory
16.1.15. The libmysqld Directory
16.1.16. The man Directory
16.1.17. The myisam Directory
16.1.18. The myisammrg Directory
16.1.19. The mysql-test Directory
16.1.20. The mysys Directory
16.1.21. The netware Directory
16.1.22. The NEW-RPMS Directory
16.1.23. The os2 Directory
16.1.24. The pstack Directory
16.1.25. The regex Directory
16.1.26. The SCCS Directory
16.1.27. The scripts Directory
16.1.28. The sql Directory
16.1.29. The sql-bench Directory
16.1.30. The SSL Directory
16.1.31. The strings Directory
16.1.32. The support-files Directory
16.1.33. The tests Directory
16.1.34. The tools Directory
16.1.35. The VC++Files Directory
16.1.36. The vio Directory
16.1.37. The zlib Directory

17. Annotated List of Files in the InnoDB Source Code Distribution

Top / Previous / Next / Up / Table of Contents