database server .err file

Discussion in 'Installation/Configuration' started by Fumble, Nov 4, 2014.

  1. Fumble

    Fumble Member

    Hello guys,

    On a database server, I have a file in /var/lib/mysql named

    "$hostname".err

    With a lot of logs... Like mysql warning, errors, and stuff.

    This file is... huge.

    I think this file were created because of ISPCONFIG, cause I don't mention it in my mysql server configuration.

    Do you know how to configure it in ISPconfig to log less, or log somewhere else?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig is not creating any logs in /var/lib/mysql folder.
     
  3. Fumble

    Fumble Member

    Ok, so were does this came from?

    In fact what make me think it is "because" of ISPconfig, is that when you have error creating a new DNS zone for exemple, a pri.domain.tld.err will be created.

    As this is the same way to name files with error... Bind will never name a file like this as mysql will never name a file like this...
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    I dont know. I just can tell you that its not from ISPConfig. Check your my.cnf file if it contains any error loggin options.

    The bind .err files are config files that get created when bind rejects a zone due to errors, they are not log files.
     
  5. Fumble

    Fumble Member

    That's the think, I don't mention this file at all in my configuration...
    [client]
    port = 3306
    socket = /var/run/mysqld/mysqld.sock
    [mysqld_safe]
    socket = /var/run/mysqld/mysqld.sock
    nice = 0
    [mysqld]
    user = mysql
    pid-file = /var/run/mysqld/mysqld.pid
    socket = /var/run/mysqld/mysqld.sock
    port = 3306
    basedir = /usr
    datadir = /var/lib/mysql
    tmpdir = /tmp
    lc-messages-dir = /usr/share/mysql
    skip-external-locking
    server-id = 1
    key_buffer = 16M
    max_allowed_packet = 16M
    thread_stack = 192K
    thread_cache_size = 8
    myisam-recover = BACKUP
    query_cache_limit = 1M
    query_cache_size = 16M
    log_bin = /var/log/mysql/mysql-bin.log
    binlog_do_db = kaporal
    expire_logs_days = 10
    max_binlog_size = 100M
    [mysqldump]
    quick
    quote-names
    max_allowed_packet = 16M
    [mysql]
    [isamchk]
    key_buffer = 16M
    !includedir /etc/mysql/conf.d/
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    See:

    http://dev.mysql.com/doc/refman/5.1/en/error-log.html

     
  7. Fumble

    Fumble Member

    Ok, I know why... And there is nothing about ispconfig, you were right!


    For those that are interested by the answer, it is because of Percona (Mysql fork).

    When starting MySQL, this is launch:

    /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306

    when starting percona:

    /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.tld.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306


    regards,
     

Share This Page