Compared to v1.1.0:
Enhancements:
- improves performance reducing the calls to poll() : #459
- includes better support for Galera : #380
- compiles on FreeBSD
- compiles with clang
- has new variable client_found_rows : #445
- implements compression on backend : #363
- handles more gracefully a complete failure of backends : #461
- improves performance reducing the number of tasks performed on every MySQL_Thread loop : 97b3f3d
- upgrade SQLite3 from 3.8.4 to 3.9.2 : 6b05743
- COMMITs and ROLLBACKs are forwarded to backend only of a transaction is active : 439087d
- added several counters in mysql status : ab3b737
- in case of crash it signals again itself to generate a core dump : 57b4512
- added admin-version in global variables
- reduced number of calls to memory allocator
- shrink mysql net buffer when possible
- reduced memory footprint for system with low memory : 912a03c and 8c92912
- keep multiplexing enabled for @@Version and @@tx_isolation : 488f44b
- Admin Module now supports SHOW SCHEMAS : 08b18bd
- Admin Module supports "SELECT @@Version" : 995fe51
- in case of errors while retrieving replication lag, servers are now not shunned : #479
- Added CHECKSUM command for tables in Admin Module : 26235f9
- Improved memory utilization and performance for the buffering of resultset : #486
- Added table runtime_mysql_servers in Admin Module : #488
- Added table runtime_mysql_replication_hostgroups in Admin Module : #488
- Added table runtime_mysql_query_rules in Admin Module : #489
- Several improvements for MySQL_Monitor : #490
- Add MySQL-like SET syntax in Admin Module : #498
- Several code cleanup
Enhancement that are also incompatible changes:
- cache_ttl in Query Cache is now in milliseconds : #452
- table stats_mysql_query_digest stores also hostgroup : #446
- removed custom memory allocator #487
Bug fixes:
- Query Cache now supports distinct entries based on user/schema : 5eff88f
- fixed a small typo that prevented query rules to be loaded from config file : 87dbb9b
- signals handlers were installed on the parent process and not on the child process : b519c94
- fix length for parsing and filtering
SET AUTOCOMMIT: 3497160 - allows empty password for mysql-monitor_password
- fixed init script : #425
- Fixed accounting of Server_Connections_connected : 2ea4149
- some failure could cause connections leak : 15195d1
- patch for bug in mariadb client library : e004b54
- improved reliability in case of graceful shutdown of mysqld : #476
- replication lag caused to duplicate entries in mysql_servers : #475
- incorrect parsing of comments in queries could lead to crash : 4b93a74
- implemented variable enforce_autocommit_on_reads to solve transactions opened on slaves : #485
- fixed a connection leak when restarting proxysql via
PROXYSQL RESTART: #473
Incompatible change:
- digest_text is limited to 65000 bytes
Unfinished features.
These are features available in ProxySQL but yet not enabled as incomplete.
- MySQL_Logger now logs in a new format that is similar to MySQL protocol. This removes any reference to protobuf