21.1.2 En quooi les protocoles de communications de mSQL et MySQL diffèrent?

There are enough differences that it is impossible (or at least not easy) to support both.

The most significant ways in which the MySQL protocol differs from the mSQL protocol are listed below:

  • A message buffer may contain many result rows.
  • The message buffers are dynamically enlarged if the query or the result is bigger than the current buffer, up to a configurable server and client limit.
  • All packets are numbered to catch duplicated or missing packets.
  • All column values are sent in ASCII. The lengths of columns and rows are sent in packed binary coding (1, 2 or 3 bytes).
  • MySQL can read in the result unbuffered (without having to store the full set in the client).
  • If a single write/read takes more than 30 seconds, the server closes the connection.
  • If a connection is idle for 8 hours, the server closes the connection.