Skip to content

Release date: 2019-05-08

Compared to v2.0.3, ProxySQL 2.0.4 introduces the following new features, bugs fixes and enhancements:

Bug fixes:

  • Do not kill MySQL Sessions if a backend failed
  • Fixed bug in parsing time_zone #1967
  • Reset auto_increment token on disconnect #1943
  • Improved parsing of SET sql_mode #1904
  • Several bug fixes related to errorlog location and logrotate #1991
  • Fixed several bug in Monitor module that cause connections to be corrupted and checks to fail #1994 and #1978
  • Several improvement in the use of SQLite3 : removed locking, and incorrect assert
  • Fixed counters on stats_mysql_users #1935
  • Disable multiplexing for SET TIMESTAMP #2033
  • If max_replication_lag is changed to 0, immediately unshun the server
  • Fixed integer overflow in Query Cache size #2040
  • Fixed crash on startup when calling Get_Memory_Stats #2037

New features/enhancements:

  • Added support for more mysql system variables to keep mulitplexing enabled #1922
  • Removed various unnecessary compiler warnings
  • Several improvements in compiling/packaging scripts
  • Increased error log error log verbosity when a client connection is rejected due to max connections reached #1936
  • LDAP adds a comment with the real username after the first word in the query
  • Added support for select @@identity like LAST_INSERT_ID #2016
  • Track NO_BACKSLASH_ESCAPES #1738
  • Better parsing for SET statements #2008
  • Allow MariaDB ConnectorJ 2.4.1 to connect to Admin #2009
  • Adding table stats.stats_mysql_free_connections to allow to troubleshoot the connection pool
  • Added a lot of new internal metrics
  • Added support for JSON functions in Admin / SQLite3
  • Added new global variables mysql-show_processlist_extended . Possible values are:
    • 0 : default , legacy behavior
    • 1 : a lot of internal info are reported in stats_mysql_processlist.extended_info (a new column) in JSON format
    • 2 : like 1 , but in more human readable format
  • Added variable mysql-monitor_galera_healthcheck_max_timeout_count (default is 3) to avoid reconfigure MySQL servers in case of temporary checks timeout
  • Improved memory usage for large resultset in Prepared Statements
  • Upgraded jemalloc to 5.2.0 : on various workload it seems it uses way less memory
  • Upgraded openssl to 1.1.1b
  • Error messages from SQL commands executed on Admin now specify they are from Admin

This release also has a draft implementation for native support of AWS Aurora: the code for all modules is present, including tables in Admin, but the functionality is currently disabled until completely stable in a future version.

MD5s:

93fbbff9f7cf8305623167bd6237975b  proxysql-2.0.4-1-centos67.x86_64.rpm
7c8ee5287fa1f7d520184d0844d4b821  proxysql-2.0.4-1-centos7.x86_64.rpm
3bd869bbabd71063e21ae41ebefaac17  proxysql-2.0.4-1-clickhouse-centos7.x86_64.rpm
63ec096dd979d4cf3e2780f4dec0a821  proxysql-2.0.4-1-clickhouse-fedora24.x86_64.rpm
a49dbb8a827bb7950357f1897598559a  proxysql-2.0.4-1-clickhouse-fedora27.x86_64.rpm
36093d4df3ee65804069d672252abb25  proxysql-2.0.4-1-clickhouse-fedora28.x86_64.rpm
6b44d1ec8bcc1646c99acc45353431c2  proxysql-2.0.4-1-dbg-centos67.x86_64.rpm
4750405771a1c5746e7eb530a18d21d6  proxysql-2.0.4-1-dbg-centos7.x86_64.rpm
56debbf948630ea8463c83333d5a4a3d  proxysql-2.0.4-1-dbg-fedora24.x86_64.rpm
bcba833ae62ac8402770d51058d4b291  proxysql-2.0.4-1-dbg-fedora27.x86_64.rpm
50db63afb316bcd451d709c0083b179c  proxysql-2.0.4-1-dbg-fedora28.x86_64.rpm
9bbab935a77bfd65bd18eb688808101c  proxysql-2.0.4-1-fedora24.x86_64.rpm
397e68f0b7a0989db07b7cd141609994  proxysql-2.0.4-1-fedora27.x86_64.rpm
229e5b74e8f6034147a6af9969b9234a  proxysql-2.0.4-1-fedora28.x86_64.rpm
a65ddfdd14a6187ed860f449808dff2c  proxysql_2.0.4-clickhouse-debian9_amd64.deb
f43c98b4693e284c735f14d639964ebd  proxysql_2.0.4-clickhouse-ubuntu16_amd64.deb
6acdd6924fe3a1845027a6cbfd2d63a4  proxysql_2.0.4-clickhouse-ubuntu18_amd64.deb
d11ca22042c2fbe4b06c2a9a09379e30  proxysql_2.0.4-dbg-debian8_amd64.deb
59dad355cf2918fee58cf800e944f80e  proxysql_2.0.4-dbg-debian9_amd64.deb
7069d96a2ca271302e151268a94ede58  proxysql_2.0.4-dbg-ubuntu14_amd64.deb
0737b6e385f0580d52f1b5ea5da20a48  proxysql_2.0.4-dbg-ubuntu16_amd64.deb
2c2031ed274acbc6b4fa39793e5ee2e6  proxysql_2.0.4-dbg-ubuntu18_amd64.deb
ce132dad638a3c7230d025cff09e43b3  proxysql_2.0.4-debian8_amd64.deb
75547181150ca2b51f06ee8e8f1a91c0  proxysql_2.0.4-debian9_amd64.deb
ea36b5cdc2b91591d1d29509e157a14e  proxysql_2.0.4-ubuntu14_amd64.deb
70805e9b0d07e661df4e7cc89fbd19ed  proxysql_2.0.4-ubuntu16_amd64.deb
a2cff65fb66452f573d1e9333b3d5a98  proxysql_2.0.4-ubuntu18_amd64.deb

SHA1s:

2e2254abcc6e0a7fe0368bc91b6d806413b868bb  proxysql-2.0.4-1-centos67.x86_64.rpm
7aa032155857a8f7c157a7464d190b0fd979916d  proxysql-2.0.4-1-centos7.x86_64.rpm
a653bec44715f4b95a782c3c057a56f6eac418f2  proxysql-2.0.4-1-clickhouse-centos7.x86_64.rpm
4f2da5df563b7731aa8580219f2620ced4b4556d  proxysql-2.0.4-1-clickhouse-fedora24.x86_64.rpm
ae3256fb1982fa39d5bee8fbf10c5aa5e05484cb  proxysql-2.0.4-1-clickhouse-fedora27.x86_64.rpm
3c28c35f39f27d39827cb511a87328c5180734a5  proxysql-2.0.4-1-clickhouse-fedora28.x86_64.rpm
f563af5992064981bd1fbef694cc048002cf3479  proxysql-2.0.4-1-dbg-centos67.x86_64.rpm
4bb3ee1f1749de2d60c65e7bef382beefee15d0a  proxysql-2.0.4-1-dbg-centos7.x86_64.rpm
06b258ed6d29ed669c4c83f5df638d1471a7b863  proxysql-2.0.4-1-dbg-fedora24.x86_64.rpm
bb4bdeb25c3f9112638341504427bdd5b32b0122  proxysql-2.0.4-1-dbg-fedora27.x86_64.rpm
5133d2934736f0e6bf74d0ee7db9b7891335f3e4  proxysql-2.0.4-1-dbg-fedora28.x86_64.rpm
a1f7307931550d46214651ea6074c8badb7a591b  proxysql-2.0.4-1-fedora24.x86_64.rpm
4d770e8d741afb61282e95be5e54208cd5a3b105  proxysql-2.0.4-1-fedora27.x86_64.rpm
d8d5d3a5f9d6622192537cd81bbbffd513b78f0a  proxysql-2.0.4-1-fedora28.x86_64.rpm
f0e497116b5ea7a9622e80096c084e058fc68137  proxysql_2.0.4-clickhouse-debian9_amd64.deb
a5d95a38bc07564c65fc2786f5660a863a77a883  proxysql_2.0.4-clickhouse-ubuntu16_amd64.deb
e34dddf18b9dd93bd4e888257cd899ad4ea553c8  proxysql_2.0.4-clickhouse-ubuntu18_amd64.deb
1c252830dfc2c7150fb50802a38746aebbb45ad1  proxysql_2.0.4-dbg-debian8_amd64.deb
2cca9be35aa6f63b953e449c06b6cd67fc704fd9  proxysql_2.0.4-dbg-debian9_amd64.deb
8ff1983316eb53a8c0290599931fbbdf7c5ba2ce  proxysql_2.0.4-dbg-ubuntu14_amd64.deb
fdf7485080ac3fe44b7fc71d7c9c098ad77bf927  proxysql_2.0.4-dbg-ubuntu16_amd64.deb
66540392ef25bc0cc227d02fe547165d73df04c2  proxysql_2.0.4-dbg-ubuntu18_amd64.deb
14d9eb1756aafe70be9f56df43689c261c7232fe  proxysql_2.0.4-debian8_amd64.deb
07c71c4573bc25fcdfef2566a83008e17cb987e2  proxysql_2.0.4-debian9_amd64.deb
7af391ee9bee8ca7c1e7f6d600235061d8e17130  proxysql_2.0.4-ubuntu14_amd64.deb
4b69e216965f3a102b8a8e807ddad86d6ddafd96  proxysql_2.0.4-ubuntu16_amd64.deb
397e7244663d8e15134d788e918d9d75c0802b5a  proxysql_2.0.4-ubuntu18_amd64.deb
Assets 29
You can’t perform that action at this time.