Alors,

> surtout après quelques essais infructueux :

la bonne réponse est :
:/etc/mysql# mysqld --verbose --help

key-buffer-size                                         67108864

max-allowed-packet                                      67108864
query-cache-size                                                67108864

> 
> /etc/mysql# cat my.cnf
> # The MariaDB configuration file
> #
> # The MariaDB/MySQL tools read configuration files in the following order:
> # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
> # 2. "/etc/mysql/conf.d/*.cnf" to set global options.
> # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
> # 4. "~/.my.cnf" to set user-specific options.
> #
> # If the same option is defined multiple times, the last one will apply.
> #
> # One can use all long options that the program supports.
> # Run program with --help to get a list of available options and with
> # --print-defaults to see which it would actually understand and use.
> 
> #
> # This group is read both both by the client and the server
> # use it for options that affect everything
> #
> [client-server]


> # Import all .cnf files from configuration directory
> !includedir /etc/mysql/conf.d/
> !includedir /etc/mysql/mariadb.conf.d/

[mysqld]
key_buffer_size         = 64M
max_allowed_packet      = 64M
query_cache_size        = 64M

Il faut écrire ses éléments de configuration perso tout à la fin du fichier 
my.cnf,
obligatoirement après les includes, afin d'appliquer ces éléments par-dessus
les variables définies au préalable dans les répertoires inclus (cf. infra).

Logique, me direz-vous !

Ph. Gras

Répondre à