Results 1 to 5 of 5

Thread: Mariadb configuration options

  1. #1
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,038

    Default Mariadb configuration options

    Hello

    Here is my /etc/my.cnf

    Code:
    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 :

    Code:
    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
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  2. #2

    Default Re: Mariadb configuration options

    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. #3
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,038

    Default Re: Mariadb configuration options

    Quote Originally Posted by wolfi323 View Post
    log-error is set (to /var/log/mysql/mysqld.log) in /etc/my.cnf.d/error_log.cnf, and that likely overrides your setting.
    I did not read what was in /etc/my.cnf.d because I think it was usefull for me.

    Thank you.
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  4. #4

    Default Re: Mariadb configuration options

    Quote Originally Posted by jcdole View Post
    I did not read what was in /etc/my.cnf.d because I think it was usefull for me.
    Well, your /etc/my.cnf (which you posted here), but also the default one, has this as last line:
    Code:
    !includedir /etc/my.cnf.d
    Guess what this does...

  5. #5
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,038

    Default Re: Mariadb configuration options

    Quote Originally Posted by wolfi323 View Post
    Well, your /etc/my.cnf (which you posted here), but also the default one, has this as last line:
    Code:
    !includedir /etc/my.cnf.d
    Guess what this does...
    It is what I wanted to say.

    Thank you for helping.

    Thread is closed.
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •