Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- max sql query size
December 25, 2004, 1:23 am
rate this thread
and have run into a bit of a snag. i get Error 1153: Got a packet
bigger than 'max_allowed_packet' with the following SQL query when
trying to run some queries.
the max_allowed_packet is set at 1MB. my script checks to make sure
that the string that is passed to mysql_query is no more than 1MB long,
but that doesn't do the trick. does php pad sql queries before it
sends 'em off? does mysql measure the size of an extended query by
adding up the size of ea. of the fields in the table in question?
any help would be appreciated - thanks! :)
Re: max sql query size
The TCP driver most likely makes the datapacket up and does what it
needs to do to send it off to the MySQL daemon. You have no control
over this at the user-level. I'd chop up the query to fit in the
standard MTU for your network adapter. You could contact your sysadmin
to make the MTU larger but that might affect network traffic to the
machine and I doubt they'd do it.
Fix your application.
DeeDee, don't press that button! DeeDee! NO! Dee...