Bug #77621 Wrong default size for max_allowed_packet
Submitted: 5 Jul 2015 19:21 Modified: 7 Jul 2015 15:19
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any

[5 Jul 2015 19:21] Daniël van Eeden 
Description:
Page: https://dev.mysql.com/doc/refman/5.6/en/gone-away.html
"If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB."

https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_max_allowed_pa... says it's 4MB as of 5.6.6.

How to repeat:
Read docs and try to insert >1M and >4M rows.

Suggested fix:
Update docs
[6 Jul 2015 3:58] MySQL Verification Team 
Hello Daniël,

Thank you for the report.

Thanks,
Umesh
[7 Jul 2015 15:19] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

Changed to 4MB in 5.7, and to "4MB (1MB before MySQL 5.6.6)" in 5.6.