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

results matching ""

    No results matching ""