Skip navigation links
The world's most popular open source database
Login
|
Register
Developer Zone
Downloads
Documentation
MySQL Server
MySQL Enterprise
MySQL Workbench
MySQL Cluster
MySQL Connectors
Topic Guides
Expert Guides
Other Docs
Archives
About
Documentation Library
Table of Contents
Search manual:
MySQL Internals Manual
:: 15 MySQL Client/Server Protocol
« 14.3 Item_singlerow_subselect
15.1 Overview »
Section Navigation
[
Toggle
]
Preface and Legal Notice
1 A Guided Tour Of The MySQL Source Code
2 Coding Guidelines
3 Reusable Classes and Templates
4 How to Build MySQL Server with CMake
5 Autotools to CMake Transition Guide
6 Plugins
7 Transaction Handling in the Server
8 The Optimizer
9 Tracing the Optimizer
10 Memory Allocation
11 Important Algorithms and Structures
12 File Formats
13 How MySQL Performs Different Selects
14 How MySQL Transforms Subqueries
15 MySQL Client/Server Protocol
15.1 Overview
15.2 Connection Phase
15.3 Authentication Method
15.4 Compression
15.5 SSL
15.6 Text Protocol
15.7 Prepared Statements
15.8 Stored Procedures
15.9 Replication Protocol
15.10 Row Based Replication
15.11 Semi-Sync Replication
15.12 Protocol Examples
15.13 Source Code Locations
16 Stored Programs
17 Prepared Statement and Stored Routine Re-Execution
18 Writing a Procedure
19 Replication
20 The Binary Log
21 MySQL Backup
22 MyISAM Storage Engine
23 InnoDB Storage Engine
24 Writing a Custom Storage Engine
25 Test Synchronization
26 Injecting Test Faults
27 How to Create Good Test Cases
28 Porting to Other Systems
29 Error Messages
A MySQL Source Code Distribution
B InnoDB Source Code Distribution
Index
Chapter 15. MySQL Client/Server Protocol
Table of Contents
[
+/-
]
15.1.1. Basic Types
15.1.2. MySQL Packet
15.1.3. Generic Response Packets
15.1.4. Character Set
15.1.5. Connection Lifecycle
15.1.6. Command Phase
15.2. Connection Phase
[
+/-
]
15.2.1. Initial Handshake
15.2.2. Auth Phase Fast Path
15.2.3. Authentication Method Mismatch
15.2.4. Authentication after COM_CHANGE_USER command
15.2.5. Connection Phase Packets
15.2.6. Capability Flags
15.3. Authentication Method
[
+/-
]
15.3.1. Limitations
15.3.2. Old Password Authentication
15.3.3. Secure Password Authentication
15.3.4. Clear Text Authentication
15.3.5. Windows Native Authentication
15.3.6. SHA256
15.4. Compression
[
+/-
]
15.4.1. Compressed Packet
15.4.2. Compressed Packet header
15.4.3. Compressed Payload
15.4.4. Uncompressed payload
15.5. SSL
15.6. Text Protocol
[
+/-
]
15.6.1. COM_SLEEP
15.6.2. COM_QUIT
15.6.3. COM_INIT_DB
15.6.4. COM_QUERY
15.6.5. COM_FIELD_LIST
15.6.6. COM_CREATE_DB
15.6.7. COM_DROP_DB
15.6.8. COM_REFRESH
15.6.9. COM_SHUTDOWN
15.6.10. COM_STATISTICS
15.6.11. COM_PROCESS_INFO
15.6.12. COM_CONNECT
15.6.13. COM_PROCESS_KILL
15.6.14. COM_DEBUG
15.6.15. COM_PING
15.6.16. COM_TIME
15.6.17. COM_DELAYED_INSERT
15.6.18. COM_CHANGE_USER
15.6.19. COM_DAEMON
15.7. Prepared Statements
[
+/-
]
15.7.1. Binary Protocol Resultset
15.7.2. Binary Protocol Resultset Row
15.7.3. Binary Protocol Value
15.7.4. COM_STMT_PREPARE
15.7.5. COM_STMT_SEND_LONG_DATA
15.7.6. COM_STMT_EXECUTE
15.7.7. COM_STMT_CLOSE
15.7.8. COM_STMT_RESET
15.8. Stored Procedures
[
+/-
]
15.8.1. Multi-resultset
15.8.2. Multi-statement
15.8.3. COM_SET_OPTION
15.8.4. COM_STMT_FETCH
15.9. Replication Protocol
[
+/-
]
15.9.1. Binlog File
15.9.2. Binlog Network Stream
15.9.3. Binlog Version
15.9.4. Binlog Event
15.9.5. COM_BINLOG_DUMP
15.9.6. COM_BINLOG_DUMP_GTID
15.9.7. COM_TABLE_DUMP
15.9.8. COM_CONNECT_OUT
15.9.9. COM_REGISTER_SLAVE
15.10. Row Based Replication
[
+/-
]
15.10.1. TABLE_MAP_EVENT
15.10.2. ROWS_EVENT
15.10.3. ROWS_QUERY_EVENT
15.11. Semi-Sync Replication
[
+/-
]
15.11.1. Semi Sync Binlog Event
15.11.2. Semi Sync ACK packet
15.12. Protocol Examples
[
+/-
]
15.12.1. A mysql client logs in
15.12.2. ProtocolText::Resultset
15.12.3. Auth Method Switch
15.12.4. SHA256 Example
15.13. Source Code Locations
[
+/-
]
15.13.1. MySQL Server
15.13.2. Binary Protocol Type Implementation
Top
/
Previous
/
Next
/
Up
/
Table of Contents
© 2013, Oracle Corporation and/or its affiliates