1.15 MySQL Connector

1. What Is the Connector - Responsible for handling client connections 2. Connector Functions 2.1. Manage Connections - If the client makes no request for longer than wait_timeout, it is automatically disconnected - Long connections are used by default, meaning that after the client establishes a connection, multiple queries use the same connection - To avoid OOM, long connections can be disconnected periodically 2.2. Permission Verification - Verify username and password 3. Connection Protocol

DatabasesCreated 06/07/2021Updated 07/17/20211 min readhistorical

This is a historical learning note and may contain outdated or incomplete understanding.

1. What Is the Connector

Responsible for handling client connections

2. Connector Functions

2.1. Manage Connections

If the client makes no request for longer than wait_timeout, it is automatically disconnected.
Long connections are used by default, meaning that after the client establishes a connection, multiple queries use the same connection.
- To avoid OOM, long connections can be disconnected periodically.

2.2. Permission Verification

Verify username and password

3. Connection Protocol

Windows on the same host: communication between the client process and server process can use named pipes or shared memory.
Unix-like systems on the same host: Unix domain socket files can be used for inter-process communication.
Different hosts: use TCP/IP.