สำรองข้อมูลได้ 2345 ตาราง
max_allowed_packet = 5G เราต้องเช็ตเป็น mb หรือเปล่าวครับ
ผมว่าลองอ่านดูน่าจะแก้ได้นะครับ
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_allowed_packetCommand-Line Format --max_allowed_packet=#
Option-File Format max_allowed_packet
Option Sets Variable Yes, max_allowed_packet
Variable Name max_allowed_packet
Variable Scope Global
Dynamic Variable Yes
Permitted Values
Type numeric
Default 1048576
Range 1024 .. 1073741824
The maximum size of one packet or any generated/intermediate string.
The packet message buffer is initialized to net_buffer_length bytes, but can grow up to max_allowed_packet bytes when needed. This value by default is small, to catch large (possibly incorrect) packets.
You must increase this value if you are using large BLOB columns or long strings. It should be as big as the largest BLOB you want to use. The protocol limit for max_allowed_packet is 1GB. The value should be a multiple of 1024; nonmultiples are rounded down to the nearest multiple.
When you change the message buffer size by changing the value of the max_allowed_packet variable, you should also change the buffer size on the client side if your client program permits it. On the client side, max_allowed_packet has a default of 1GB. Some programs such as mysql and mysqldump enable you to change the client-side value by setting max_allowed_packet on the command line or in an option file.
The session value of this variable is read only.
หัวข้อ: Daily build - 3.55.2.19 (อ่าน 30201 ครั้ง)