By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

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

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!