LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-20-2014, 07:52 AM   #1
jojanmpaul
Member
 
Registered: Sep 2012
Location: Bangalore
Posts: 80

Rep: Reputation: Disabled
mysql-relay log issue


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
 
Old 03-21-2014, 04:02 AM   #2
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 2,574

Rep: Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929Reputation: 929
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix relay issue L0cayta Linux - Software 2 05-28-2012 11:05 AM
Can MySQL log on via SSH/bash? mysql:x:27:101:MySQL Server:/var/lib/mysql:/bin/bash Ujjain Linux - Newbie 2 04-24-2009 03:21 PM
Mysterious Local Relay entries in Sendmail log rchapman Linux - Server 2 02-06-2007 01:13 AM
Sendmail Log unknown relay address (cron message) leventis Linux - Security 2 05-31-2006 03:23 PM
Sendmail relay issue ppuddick Linux - Networking 3 06-01-2003 09:23 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 08:41 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration