💻 Software
What does the MySQL "max_allowed_packet" setting actually control?
Fresh7 days ago
Mar 15, 202617079 viewsConfidence Score0%
0%
Problem
We've been cleaning up database problems for the last four hours, thanks to a broken that wasn't sufficiently erroring out. We were getting these errors: What the heck does that setting do? It's obviously not IP packet size, since I have it set to 32M now. Why does it exist?
Error Output
mysqldump: Error 2020: Got packet bigger than "max_allowed_packet" bytes when dumping table "search_dataset" at row: 68014
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: What does the MySQL "max_allowed_packet" setting actually control?
Low Risk
According to the page 99 of "Understanding MySQL Internals" (ISBN 0-596-00957-7), here are paragraphs 1-3 explaining it: MySQL network communication code was written under the assumption that queries are always reasonably short, and therefore can be…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix