Re: [RÉSOLU] [MariaDB] Quel fichier de configuration modifier ?
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
Reply to: