Proxysql: Large queries smaller than max_allowed_packet don't seem to work

[geotro]

Hello,

I have a large update query that is about 5MB in total size. I'm consistently getting "ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes" when running it via proxysql, no issues at all when running it directly on the MySQL server.

Using proxysql 1.3.1.

Please let me know if you require any more details to reproduce/fix

[renecannao]

Hi @geotro .
You should increase mysql-max_allowed_packet in ProxySQL, otherwise ProxySQL won't allow a large query. You should run something like this in the Admin interface:

SET mysql-max_allowed_packet=64*1024*1024;
LOAD MYSQL VARIABLES TO RUNTIME;
SAVE MYSQL VARIABLES TO DISK;

I also noticed that is not documented: I will fix that!

[geotro]

Thanks. Yeah I looked it up in the docs first and when I couldn't find anything I figured it might be a bug. Should have used the source :)

[renecannao]

Documentation updated.

Thanks