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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.