CODEWITHSUNDEEP
mysqlwamp
Hemal Kachhadiya
Hemal Kachhadiya

Reputation: 1676

What is maximum query size for mysql?

What is maximum query size for mysql? Some times the server stops working when I fire a too long query.

Upvotes: 165

Views: 122237

Answers (2)

kiriloff
kiriloff

Reputation: 26333

You can check your current server setting with:

SHOW VARIABLES LIKE 'max_allowed_packet';

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

Upvotes: 230

user2045846
user2045846

Reputation:

To increase the max_allowed_packet, open

my.ini/my.cnf under [mysqld] section.

Once the change is done you would have to restart the server.

Upvotes: 39

Related Questions