Ashley M. Kirchner wrote:
Probably a silly question, but if I have my logs set to binary, how
can I read them and check on a query that's failing? I don't
necessarily want to switch to text logs because we'll want to do
replication soon here, so I want to keep it as a binary log. My prob
On Fri, 2007-04-27 at 09:19 -0500, [EMAIL PROTECTED] wrote:
> So if one is doing a full mysqldump every night, all bin-logs can be
> deleted after this?
On the slave - Yes. In fact I would highly recommend it before
starting the slave processes again. This will reset the bin log's
'position' b
So if one is doing a full mysqldump every night, all bin-logs can be
deleted after this?
If bin-logging is disabled, will master/slave syncing still occur?
David
> Issuing a 'reset master' will purge all of the logs as well. I wouldn't
> just rm them, as they are being tracked in the index fil
So, I take it since I do not have a slave at all, I could safely just
disable this feature altogether?
If I do not need point in time recovery, and the once every 12 hour dump I
do across all databases is ok with me, I suppose I can just disable said
feature? Heck, some of these boogers are a GB
Issuing a 'reset master' will purge all of the logs as well. I wouldn't
just rm them, as they are being tracked in the index file.
If you aren't running a slave, then these files are only good for data
recovery purposes. Say a DBA goes crazy and deletes all of the databases
mid-day (too much s
> Yes -- sorry for being so general. You can use the binlogs for a)
> replication b) replaying changes since your last backup so you get
> point-in-time recovery. If you have no replication slaves, just delete
> everything older than your latest backup. You can just use 'rm'. If
> you use PUR
Hi Scott,
Scott Haneda wrote:
In the short term, see the manual page for PURGE MASTER LOGS. In the
long term, write a cron job.
innotop (http://sourceforge.net/projects/innotop) also has a new
feature, unreleased because I just wrote it a few hours ago, which will
help you figure out which bin
> In the short term, see the manual page for PURGE MASTER LOGS. In the
> long term, write a cron job.
>
> innotop (http://sourceforge.net/projects/innotop) also has a new
> feature, unreleased because I just wrote it a few hours ago, which will
> help you figure out which binlogs can be purged sa
Hi,
Scott Haneda wrote:
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
See attached message I just sent to another
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 15 June 2004 01:29 pm, Eric Gunnett wrote:
> You can do a reset master, and it will start the log over at 001 and
> remove the old log files that are there.
Thanks,
I also had to restart the slaves (change master to command) to start
You can do a reset master, and it will start the log over at 001 and remove
the old log files that are there.
Eric Gunnett
System Administrator
Zoovy, Inc.
[EMAIL PROTECTED]
>>> Jeff Smelser <[EMAIL PROTECTED]> 06/15/04 11:26AM >>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am tr
11 matches
Mail list logo
