What is the maximum query size for mysql?

Question

What is the maximum query size for mysql? Several times the server stops working when I run a request that is too long.

Answer 1

You can check your current server using

SHOW VARIABLES LIKE 'max_allowed_packet'; 

This gives you the answer in bytes. e.g. max_allowed_packet=1048576 or 1mb

Answer 2

To increase max_allowed_packet , open

my.ini/my.cnf in the [mysqld] section.

Once the change is complete, you will have to restart the server.