Maximum MySQL query size

1150260 pts.
Tags:
MySQL
Hi experts, Does anyone know what the maximum size is for a MySQL query? I noticed that when it's too long on our server, it takes forever. Thanks!
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

That is defined by the max size of a packet that can be sent or received by the engine, and it is configurable.

You can check your current value with this command:

SHOW VARIABLES LIKE 'max_allowed_packet';

However, a too big query would not cause it to take forever.  You would get a Packet Too Large error.

If your session is hanging, there must be something else going on.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: