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?
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...
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.
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/
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,
