Enough different that it's impossible (at least not easy) to support both.
The biggest differences between MySQL and mSQL:
- A message buffer may contain many result rows.
- On the server side the message buffers are dynamically enlarged as necessary for big questions from the client.
- All packages are numbered to catch out of sync packages.
- All columns are sent in ASCII, the length of columns and length of rows are sent in packed binary coding (1,2 or 3 bytes).
- MySQL can read in the result unbuffered.
- If a single write/read takes more than 30 seconds then the server closes the connection.
- If nothing has happened on a connection for 8 hours the server closes the connection.
I don't think it makes sense to give a full spec, as we have plans to optimize this in the near future |