Mariadb configuration options

English Applications
#1

Hello

Here is my /etc/my.cnf

user_install@linux-dpgm:~> sudo grep -vE '^\s*(#|$)'  /etc/my.cnf
-
-
[client]
port       = 3306
socket     = /bdd/client/sock/mysql_client.sock
-
-
[mysqld]
innodb_file_format=Barracuda
innodb_file_per_table=ON
server-id       = 1
port       = 3307
socket     = /bdd/mysql/sock/mysqld.sock
pid-file   = /bdd/mysql/sock/mysqld.pid
general_log       = 1
general_log_file        = /var/log/mysql/mysql/mysqld.log
log-error                       = **/var/log/mysql/mysql/mysqld_error.log**
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
-
-
[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log
!includedir /etc/my.cnf.d

user_install@linux-dpgm:~>

Here the real used parameter from mariadb :

user_install@linux-dpgm:~> mysql --socket=/bdd/mysql/sock/mysqld.sock  -BNe "show global variables" | grep log_error
log_error       **/var/log/mysql/mysqld.log**
user_install@linux-dpgm:~>

log-error should be ‘/var/log/mysql/mysql/mysqld_error.log’ is not it ?

Any help is welcomme

#2

log-error is set (to /var/log/mysql/mysqld.log) in /etc/my.cnf.d/error_log.cnf, and that likely overrides your setting.

#3

I did not read what was in /etc/my.cnf.d because I think it was usefull for me.

Thank you.

#4

Well, your /etc/my.cnf (which you posted here), but also the default one, has this as last line:

!includedir /etc/my.cnf.d

Guess what this does… :wink:

#5

It is what I wanted to say;).

Thank you for helping.

Thread is closed.