77Views3Replies

Author Options:

mysql server does not want to get some packages because of error 'Packet Too Large'. How to fix? Answered

For some reason i unable to receive a packet sent on MySQL 4.5 server. Trying to get it MySQL just shows me an error "Packet too large" and closes the connection. Namely this situation is not so bad, i can receive the packet partially, after all. But to prevent such issues i want to know what should i do to increase the receiving option. I suppose there are some kind of limitation, it would be logical. I have not seen such error just because i used to handle small-sized packets. Is it possible? And if it is, how can i change my client settings or use some commands or what? =)

Discussions

0
None
Ecgwald

Best Answer 4 years ago

The server has its own max_allowed_packet variable, so if
you want to handle big packets, you must increase this variable.

shell> mysqld --max_allowed_packet=??? ->set the
variable

or

[mysqld]

max_allowed_packet=??? ->set the variable

Also read
this thread, it might help: http://www.filerepairforum.com/forum/databases/databases-aa/mysql/1818-corrupt-myisam-tables-in-mysql-4-5

You can also get strange problems with large
packets if you are using large BLOB values but have not given mysqld access to
enough memory to handle the query. If you suspect this is the case, try adding
ulimit -d 256000 to the beginning of the mysqld_safe script and restarting
mysqld

0
None
seandogue

4 years ago

Reduce your packet request size? When I pull data from the server, I pull what I need to use, not the entire database in one fell swoop.

If you're not sure how to do any of this, it sounds like you need to take at least a short course in the subject. BTW, 4.5? that's kidna old.

0
None
iceng

4 years ago

Look for downloading software that essentially can stitch oddball packets back together on the fly.