Translation of "Chapter 8. Large amount of data." of "Methods for searching errors in SQL application" just published

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:





$mysql51 test <phpconf2009_1.sql

ERROR 1153 (08S01) at line 33: Got a packet bigger than 'max_allowed_packet' bytes


...


Rest of the chapter is here


Comments:

Hi Sveta,
I have yet read none of this series of posts of translations.
I just wanted to appreciate this obviously great effort in translating such a large amount of text. So, keep up the good work!

Posted by Shlomi Noach on July 21, 2010 at 10:31 AM MSD #

Shlomi,

thank you for the comment. But this is how to write English text for not native English speakers anyway :) In this case people just can see original Russian text.

Posted by Svetlana Smirnova on July 22, 2010 at 03:50 AM MSD #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Working blog of Sveta Smirnova - MySQL Senior Principal Support Engineer working in Bugs Analysis Support Group

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today