mysql-relay log issue

jojanmpaul · 03-20-2014, 06:52 AM

Hi,

I have noticed that mysql-relay log files are getting generated at a frequent interval in the following path,

/var/lib/mysql

mysql-relay.000001
mysql-relay.000001
----------------
----------------
mysql-relay.002350

Each file is 4.0K and consumes memory in the server, Could you tell me how to sort it out.

uname -ar
2.6.18-194.3.1.el5

mysql --version
Distrib 5.1.46

TenTenths · 03-21-2014, 03:02 AM

Is your server supposed to be part of a master/slave replication strategy?

If not then check your my.cnf and remove any server-id directive.

If it IS part of a replication strategy then you should be able to set a "expire_logs_days" directive to have the server remove any log files older than the specified interval.