Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7478

log-basename unpredictable behavior in standalone mode

    XMLWordPrintable

    Details

      Description

      Hello,
      We are trying to unify all our setups/configurations with the help of:

      datadir = /var/lib/mysql
      log-basename=mariadb

      However, we've hit the unpredictable behavior (in 5.5.41) in Standalone mode:

      Our syslog configuration:

      [mysqld_safe]
      syslog
      syslog-tag=daemon

      Host: MARIADBTEST

      The tests we've run on CentOS 6.6:

      With Standalone Server [mysqld]:

      1. No syslog
      mariadb.err
      mariadb-slow.log
      MARIADBTEST.pid

      Result: log-basename doesn't affect pid file name.

      2. Adding log_error='' in standalone mode (trying to activate syslog):
      mariadb-slow.log
      MARIADBTEST.err
      MARIADBTEST.pid

      Result: no syslog logging is active, and both err and pid files use hostname.

      With mysqld_multi [mysqld1]:

      1. No syslog
      mariadb.err
      mariadb.pid
      mariadb-slow.log

      Result: everything is good!

      2. Adding log_error='' (trying to activate syslog):
      mariadb.pid
      mariadb-slow.log

      Result: Everything is good, and error log goes to syslog!

      As you see only in mysqld_multi mode the behavior is by design.

      Thanks!
      Alex

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            ShivaS Alex
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: