[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: |
Ben Sturmfels |
|
Subject: |
bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default |
|
Date: |
Fri, 13 Jan 2017 10:29:20 +1100 |
|
User-agent: |
Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Icedove/38.8.0 |
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?
Ben
signature.asc
Description: OpenPGP digital signature