What is maximum query size for mysql?

mysql wamp
Hemal Kachhadiya picture Hemal Kachhadiya · May 2, 2013 · Viewed 79.4k times · Source

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

Answer

kiriloff picture kiriloff · May 2, 2013

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

Related questions

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

This might seem redundant but I was unable to find a correct solution. I was unable to login to mysql using the mysql console.It is asking for a password and I have no clue what I actually entered.(Is …

Read More
Fix Access denied for user 'root'@'localhost' for phpMyAdmin

I'm using WAMP Server 2.2 on a PC. In phpMyAdmin (version 5.5.24) I edited the 'root' user (with 'localhost' host) and gave it a password of 'root'. This turned out to be a big mistake that I'm trying to revert. Now when …

Read More
Windows: XAMPP vs WampServer vs EasyPHP vs alternative

There was a similar question asked here three years ago, but I want to open it up further to include all possible Windows/Apache/MySQL/PHP stacks. Which to do you think is best? XAMPP seems to be the most …

Read More