[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
bug#25415: MySQL "server has gone away" when reloading database dump due
From: |
Ludovic Courtès |
Subject: |
bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default |
Date: |
Fri, 13 Jan 2017 09:03:41 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) |
Ben Sturmfels <address@hidden> skribis:
> On 13/01/17 01:22, Ludovic Courtès wrote:
>
>>> Could it be worth setting max_allowed_packet to 16M in Guix's
>>> `mysql-configuration-file` function for consistency with Debian?
>>
>> Definitely. I would add a ‘max-allowed-packet’ field in
>> <mysql-configuration> in (gnu services databases) and make sure it’s
>> honored.
>>
>> Would you like to give it a try?
>
> Sure, I'll give it a shot!
>
> It looks as though the MariaDB source comes with a settings file for
> Debian that includes max-allowed-packet=16M:
>
> mariadb-XX.XX.XX/debian/additions/my.cnf
>
> Would you recommend adding just max-allowed-packet, or would it be worth
> applying all these settings in this file?
I’m not famliar with MySQL/MariaDB, but any setting that sounds useful
to you is welcome.
Thanks,
Ludo’.