Translation of "Chapter 8. Large amount of data." of "Methods for searching errors in SQL application" just published
By Sveta Smirnova-Oracle on Jul 21, 2010
I started translation of Part 3 "Other cases". In this part I mostly describe how wrong settings can lead to misterious errors. First chapter in this part about large amount of data.
Part 3. Other cases.
Chapter 8. Large amount of data.
There are cases when query is just symptom of wrong behavior, but true reason is wrong settings.
One of the cases is too small max_allowed_packet for data sent. MySQL
server variable max_allowed_packet defines maximum possible amount of
data which MySQL server can receive or send. Amount of
max_allowed_packet is specified in bytes.
Error usually looks like: