zero-mysql

zero-mysql is a high-performance MySQL library.

• zero_mysql::protocol: implements sans I/O for MySQL protocol.
• zero_mysql::sync: implements a synchronous Conn.
• zero_mysql::tokio: implements an asynchronous Conn.

The test, benchmark and feature development is driven by the need of pyro-mysql.

Features

• zero-copy whenever possible
• zero-allocation in hot paths
• customizable de/serialization
  • user can process a row and throw it away without collecting into Vec
  • user can deserialize bytes to PyString without intermediate objects
  • user can even choose not to parse the packets
  • for performance-critical query, you can define #[repr(C)] struct Row and transmute network packets into it

Perf Notes

• Prefer MariaDB to MySQL
• Prefer UnixSocket to TCP
• Set Opts.upgrade_to_unix_socket=false and manually set the socket path
• Use Conn.exec_bulk to group 2~1000 INSERTs or UPDATEs