I dont know if this is a bug or by design, but even though max_allowed_packet is configured to 32MB on my.cnf file, when you check the setting on the database its only set to 10MB

I was able to setup a larger amount by running a query on phpmyadmin, but it only lasted until I restarted the process.

Query used to configure 128MB :

set global max_allowed_packet=1024 * 1024 * 128

Query to check current configuration :

SHOW variables like 'max_allowed_packet'

Anyone has any idea on how to set this up so it wont reset with the process restart?


Some reference i've found on the net that has confused me more than help

http://stackoverflow.com/questions/9922894/set-global-max-allowed-packet-doesnt-work

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_allowed_packet

http://www.techmajha.com/2011/03/15/installation-of-otrs-itsm-give-me-error-message-got-a-packet-bigger-than-max_allowed_packet-bytes-sql-insert-into-web_upload/