4.4 二进制协议 (Prepared Statements)

4.4.1 Supported

• COM_STMT_CLOSE
  Closes a previously prepared statement.

• COM_STMT_EXECUTE
  Executes a previously prepared statement.

• COM_STMT_RESET
  Resets a prepared statement on client and server to state after preparing.

• COM_STMT_SEND_LONG_DATA
  When data for a specific column is big, it can be sent separately.

4.4.2 Faked

• COM_STMT_PREPARE
  Prepares a statement on the server
  COM_STMT_PREPARE response is faked. Parameters and numbers are faked.

4.4.3 Not Supported

• COM_STMT_FETCH
  Fetches rows from a prepared statement

4.4.4 MySQL Flow

注意点：

• 可通过url方式指定useCursorFetch=true，开启分批从server查询数据。
• 但是jdbc中默认fetchSize为0，jdbc中必须fetchSize > 0才会发送fetch包分批查询数据，否则和普通prepareStatement没有区别。

4.4.5 Dble Flow