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
