[mythtv-users] MySQL server has gone away

[Michael T. Dean]

On 11/05/2009 02:50 PM, Yeechang Lee wrote:
> Andy Colson says:
>   
>> [mysqld]
>> max_allowed_packet=16M
>>     
> What is the default, and any potential negative side effects from
> this? My frontend/backend has 2GB of RAM and the mythconverg database
> is about 1.5GB in size.

Default is 1MiB and should be at least 10x larger than any of the MythTV 
data requires.  However, if a system is configured with a size of 1024 
bytes (the smallest you can set), it could have problems post 0.21-fixes 
due to the fact that our data can now be potentially 3x larger than it 
was in 0.21-fixes due to the character encoding conversion.  However, 
even with 1024, there are few places where we should have issues with 
max_allowed_packet size (most all of our DB data is small).

Mike