percona-discussion team mailing list archive

[Chandu <chandusingh.dba@xxxxxxxxx>]

Hi

After adding these Lines http://launchpadlibrarian.net/20925048/01_mysqld_safe.diff 
to mysqld_safe on 5.0.75 Highperf build 12 

It starts to write to error log specified in the my.cnf, but still there is a problem that it truncates the file when it is shutdown normally.
Which is bit strange and would like to have the history in the error log file.


-- Snip
-bash-3.2$ tail -f mysqld_error.log
started
090507  5:28:08  InnoDB: Started; log sequence number 0 43656
090507  5:28:08 [Note] Recovering after a crash using /mysql/inst_3308/logbin/logbin
090507  5:28:08 [Note] Starting crash recovery...
090507  5:28:08 [Note] Crash recovery finished.
090507  5:28:08 [Note] /usr/local/mysql-5.0.75-percona-highperf-b12/libexec/mysqld: ready for connections.
Version: '5.0.75-percona-highperf-b12-log'  socket: '/mysql/inst_3308/run/mysqld.sock'  port: 3308  MySQL Percona High Performance Edition (GPL)
090507  5:28:12 [Note] /usr/local/mysql-5.0.75-percona-highperf-b12/libexec/mysqld: Normal shutdown

090507  5:28:14  InnoDB: Starting shutdown...
090507  5:28:17  InnoDB: Shutdown completed; log sequence number 0 43656
090507  5:28:17 [Note] /usr/local/mysql-5.0.75-percona-highperf-b12/libexec/mysqld: Shutdown complete

STOPPING server from pid file /mysql/inst_3308/run/mysqld.pid
ended
tail: mysqld_error.log: file truncated

-- 
syslog-ng should be optional
https://bugs.launchpad.net/bugs/314114
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.

Status in Patches for MySQL by Percona: Confirmed

Bug description:
Please make syslog-ng optional, perhaps by obeying the --log-error argument to mysqld_safe.

Use case: When running several instances of mysqld on one box, parsing info out of syslog becomes awkward, especially after the fact when you don't know what its pid was. Use case for several instances on one box: For QA of an application release, load all DBs onto one box from snapshot-style backups.

Attached is a start.