Date: Fri, 02 May 2008 14:27:30 +0200 From: Zbigniew Szalbot <z.szalbot@lc-words.com> To: freebsd-questions@freebsd.org Subject: handling mysql binlog data Message-ID: <481B08B2.7070702@lc-words.com>
index | next in thread | raw e-mail
[-- Attachment #1 --]
Hello,
Following a recent thread I would like to ask if it is safe to remove
old binlog data. From the below I understand that the current binlog is
mysql-bin.000007 and the previous ones (from 000001-000006) are not
written to any more. I just need confirmation before I take any action.
By asking whether it is safe, I only mean if deleting them will not
affect mysql operation. I do backups of mysql data anyway.
-rw-rw---- 1 mysql mysql 61956466 Apr 16 08:44 mysql-bin.000001
-rw-rw---- 1 mysql mysql 697756219 Apr 17 14:26 mysql-bin.000002
-rw-rw---- 1 mysql mysql 1056 Apr 17 14:29 mysql-bin.000003
-rw-rw---- 1 mysql mysql 1073745860 Apr 24 05:49 mysql-bin.000004
-rw-rw---- 1 mysql mysql 620489997 Apr 27 10:48 mysql-bin.000005
-rw-rw---- 1 mysql mysql 229357379 Apr 28 15:55 mysql-bin.000006
-rw-rw---- 1 mysql mysql 869964294 May 2 14:15 mysql-bin.000007
Do I understand correctly that removing mysql-bin.000007 would result in
mysql not writing any data to mysql-bin file until the server gets
restarted?
Many thanks for sharing!
--
Zbigniew Szalbot
www.lc-words.com
[-- Attachment #2 --]
0 *H
01 0 + 0 *H
0b0ˠ{KL/GY`0
*H
0b1 0 UZA1%0#U
Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA0
080426152039Z
090426152039Z0H1 0 UThawte Freemail Member1%0# *H
z.szalbot@lc-words.com00
*H
0 rep%'#Ouu);3Q{e摶y EU<>._$ u}j_yӚMfO|y\=h !bTKky3
.d?ge(zz 3010!U 0z.szalbot@lc-words.com0 U 0 0
*H
wm_Uϩ^C{cdl8j*?)zLLoZ~h:b3
C jRm6?JqL/jA 02&yG( Q[$f060b0ˠ{KL/GY`0
*H
0b1 0 UZA1%0#U
Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA0
080426152039Z
090426152039Z0H1 0 UThawte Freemail Member1%0# *H
z.szalbot@lc-words.com00
*H
0 rep%'#Ouu);3Q{e摶y EU<>._$ u}j_yӚMfO|y\=h !bTKky3
.d?ge(zz 3010!U 0z.szalbot@lc-words.com0 U 0 0
*H
wm_Uϩ^C{cdl8j*?)zLLoZ~h:b3
C jRm6?JqL/jA 02&yG( Q[$f060?0
0
*H
01 0 UZA10U Western Cape10U Cape Town10U
Thawte Consulting1(0&U Certification Services Division1$0"UThawte Personal Freemail CA1+0) *H
personal-freemail@thawte.com0
030717000000Z
130716235959Z0b1 0 UZA1%0#U
Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA00
*H
0 Ħ<UsUNʙZ hup [v :aQP
0cZ,p+Z?qV˯< 6$*+w=+>@dקe*TH<a@ dr` 00U 0 0CU <0:08642http://crl.thawte.com/ThawtePersonalFreemailCA.crl0 U 0)U "0 0 10UPrivateLabel2-1380
*H
HP .
fgCL!6 -6/ P p<ab:~ t%Pb'qW%ݩ9 Oe_N4[5MwV!x!5$ F]_eO100v0b1 0 UZA1%0#U
Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA{KL/GY`0 + 0 *H
1 *H
0 *H
1
080502122730Z0# *H
1p&;; !jn0R *H
1E0C0
*H
0*H
0
*H
@0+0
*H
(0 +71x0v0b1 0 UZA1%0#U
Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA{KL/GY`0 *H
1xv0b1 0 UZA1%0#U
Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA{KL/GY`0
*H
wU+x:o}a =JZAkNSBI/C$Y.䯢r (r(B k1f%d:
\nE#T&ۻ0BrCd|W4<`23|eԋQJ
help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?481B08B2.7070702>