Re: MySql max_allowed_packet

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Keith Smith
Date:  
To: Main PLUG discussion list
Subject: Re: MySql max_allowed_packet

Thank you Bryan O'Neal, Amit Nepal, and Todd Millecam!! I was able to
import the data and the app is running!!







On 2014-12-04 20:46, Todd Millecam wrote:
> 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
> <> 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/
>> [1]
>> [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" <>
>> 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 -
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2] [1]
>>
>> ---------------------------------------------------
>> PLUG-discuss mailing list -
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2] [1]
>
> Links:
> ------
> [1] http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2]
> [2]
>
> http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/
> [1]
>
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2]
>
> --
> Keith Smith
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2]
>
> --
>
> Todd Millecam
>
> Links:
> ------
> [1]
> http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/
> [2] http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss


--
Keith Smith
---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss