MySql max_allowed_packet

[Todd Millecam]

Net buffer, probably not, max_packet, it'd be a good idea to tune it to
your hard-drive+cache speed, which is typically about 120MB, unless your
database is on NAS hardware, in which case it can be as high as 6.5GB.

On Thu, Dec 4, 2014 at 7:20 PM, Keith Smith <techlists at phpcoderusa.com>
wrote:

>
>
> Amit,
>
> Your commands seem to have worked - thank you!!
>
> Do I need to set :
> 1) global net_buffer_length=1000000;
> 2) global max_allowed_packet=10000000000000;
>
> to some lesser value?
>
> Any way it is detrimental to leave at these values as set?
>
> Thanks!!
> Keith
>
>
>
>
> On 2014-12-04 17:22, Amit Nepal wrote:
>
>> You can just change the value of max packet for that session and
>> import the file . This article might be helpful .
>>
>>
>> http://www.amitnepal.com/mysql-error-got-a-packet-
>> bigger-than-max_allowed_packet-bytes/
>> [2]
>>
>>
>>  Thanks
>>
>> Amit K Nepal
>>  Chief Information Officer
>>  (RHCE, CCENT, C|EH, C|HFI, GIAC ISO 27000 Specialist)
>>  omNovia Technologies Inc. On 12/4/2014 3:47 PM, Bryan O'Neal wrote:
>>
>>  1) Max allowed packet is usually a replication not an important
>>> error. It can be described as a "I can not find the information it
>>> is looking for inside my search window" error.
>>> 2) It is more often associated with corruption then a true packet
>>> size error. It also occasionally manifests when moving from 64 to 32
>>> bit.  But it is possible that it is just a max packet problem
>>> 3) using the client is more direct and less prone to error then
>>> using PHP my admin
>>> On Dec 4, 2014 2:34 PM, "Keith Smith" <techlists at phpcoderusa.com>
>>> wrote:
>>>
>>>  Hi,
>>>>
>>>> I'm trying to import a file into MySql on CentOS 6.6 and mysql
>>>> Server version: 5.1.73.
>>>>
>>>> Un compressed the file is 611,285,457b or about 610MB.  This is
>>>> a production server and I am concerned about setting PHP
>>>> upload_max_filesize that large.
>>>>
>>>> I tried to import via the command line and that failed.  Tried
>>>> uploading as a gz via PhpMyAdmin... that failed also.  And I
>>>> surely do not want to increase the memory allotted to PHP...
>>>>
>>>> I tried this:
>>>>
>>>> mysql --max_allowed_packet=650M -u root -p database < data.sql
>>>>
>>>> And received this error :  ERROR 1153 (08S01) at line 1370225:
>>>> Got a packet bigger than 'max_allowed_packet' bytes
>>>>
>>>> Thanks in advance!!  Any suggestions?
>>>>
>>>> Keith
>>>>
>>>> --
>>>> Keith Smith
>>>> ---------------------------------------------------
>>>> PLUG-discuss mailing list - PLUG-discuss at lists.phxlinux.org
>>>> To subscribe, unsubscribe, or to change your mail settings:
>>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [1]
>>>>
>>>
>>> ---------------------------------------------------
>>> PLUG-discuss mailing list - PLUG-discuss at lists.phxlinux.org
>>> To subscribe, unsubscribe, or to change your mail settings:
>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [1]
>>>
>>
>>
>>
>> Links:
>> ------
>> [1] http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>> [2]
>> http://www.amitnepal.com/mysql-error-got-a-packet-
>> bigger-than-max_allowed_packet-bytes/
>>
>> ---------------------------------------------------
>> PLUG-discuss mailing list - PLUG-discuss at lists.phxlinux.org
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>
>
> --
> Keith Smith
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>



-- 
Todd Millecam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20141204/19fe2a94/attachment.html>