Recommended max_allowed_packet value (for attachments)

Hello

I am using Mysql 4.1 / RT 3.6.5.

on mysql , max_allowed_packet is set to 1048576 , which causes
attachements greater than 1M to fail (see in apache log):

Attachment insert failed - Got a packet bigger than 'max_allowed_packet’
bytes (/usr/lib/perl5/vendor_perl/5.8.8/RT/Attachment_Overlay.pm:195)

I would like to know if there are any max_allowed_packet value
recommendation , because I would not like to have my database size
grow , and because I might then have performance problems…

so what value are you using / recommending for max_allowed_packet ?

Oleg Sladkoff
KELKOO - Service Architect
oleg.sladkoff@yahoo-inc.com
Yahoo messenger : Kelkoooleg
tel : +33 (0)476848147
gsm : +33(0)675768532

Hello

I am using Mysql 4.1 / RT 3.6.5.

on mysql , max_allowed_packet is set to 1048576 , which causes
attachements greater than 1M to fail (see in apache log):

Attachment insert failed - Got a packet bigger than 'max_allowed_packet’
bytes (/usr/lib/perl5/vendor_perl/5.8.8/RT/Attachment_Overlay.pm:195)

I would like to know if there are any max_allowed_packet value
recommendation , because I would not like to have my database size
grow , and because I might then have performance problems…

so what value are you using / recommending for max_allowed_packet ?

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Drew Barnes wrote:

On mine I have max_allowed_packet=16M

It is probably overkill, but I got sick of trying to figure out exactly
how big I needed to make it without losing attachments.

I also have max_allowed_packet = 16M. Works fine for us.

– ============================
Tom Lahti
BIT Statement LLC

(425)251-0833 x 117
http://www.bitstatement.net/
– ============================