search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.06k stars 983 forks source link

Request for ProxySQL to handle SELECT LAST_INSERT_ID() FROM DUAL if mysql-auto_increment_delay_multiplex=0 #4493

Closed gvasileiou closed 7 months ago

gvasileiou commented 8 months ago

As per documentation https://proxysql.com/documentation/global-variables/mysql-variables/#mysql-auto_increment_delay_multiplex there a list of queries that ProxySQL is able to handle correctly even if mysql-auto_increment_delay_multiplex is set to 0:

- SELECT LAST_INSERT_ID()
- SELECT LAST_INSERT_ID() LIMIT 1
- SELECT @@IDENTITY

However there is a corner case that some ORMs are issuing SELECT LAST_INSERT_ID() FROM DUAL.