Date: Fri, 02 May 2008 17:58:06 +0200 From: Zbigniew Szalbot <z.szalbot@lc-words.com> To: Chris Pratt <eagletree@hughes.net> Cc: freebsd-questions@freebsd.org Subject: Re: handling mysql binlog data Message-ID: <481B3A0E.6060300@lc-words.com> In-Reply-To: <4C629ECE-9203-4A3B-94FA-8BACEA07EE70@hughes.net> References: <481B08B2.7070702@lc-words.com> <4C629ECE-9203-4A3B-94FA-8BACEA07EE70@hughes.net>
next in thread | previous in thread | raw e-mail | index | archive | help
This is a cryptographically signed message in MIME format. --------------ms040604040504080305050305 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello, Chris Pratt pisze: > On May 2, 2008, at 5:27 AM, Zbigniew Szalbot wrote: > >> 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? >> > > I recently removed all logs prior to the one shown as current > without any problems. I would not think you would want to > remove the one currently in use or problems would result. > > The procedure for this is here: > http://dev.mysql.com/doc/refman/5.1/en/purge-master-logs.html > for 5.1 and here: > http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html > for 5.0 Thanks a lot! It did help me get rid of a few files in a safe way. I only wonder now how to set up a cron job to do it on a permanent basis? 1/ I would probably be better off setting this mysql query (URGE {MASTER | BINARY} LOGS BEFORE 'date') in a separate file an run it from cron? 2/ Even if I do that, I would still have to change the 'date' value each month... hmm... as non-programmer I will probably do best to simply enter a task in a calendar to run this manually... each month :) Thank you anyway - this was very helpful and I instantly saved a lot of space on a shrinking /var partition! -- Zbigniew Szalbot www.lc-words.com --------------ms040604040504080305050305 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIDzCC AmIwggHLoAMCAQICEHu/rJNLTC9H4eJZYOf+/Z0wDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UE BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDQyNjE1MjAzOVoX DTA5MDQyNjE1MjAzOVowSDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjElMCMG CSqGSIb3DQEJARYWei5zemFsYm90QGxjLXdvcmRzLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOB jQAwgYkCgYEAwBXt/3Jlh3DcJScjw091dfTrKTsz9LxRe5EC6YtlCOaRtnkZIPVF0BfpVTy1 rRE+8LWJLq9fEgGAJPOqqgy9gHV9wmoD7F9505reTZS5Zk98eVzsPWjMHBaRIYxiVMtLa7DT Dnm9M6oJDccDkS5kyz/BtsJnsmUomxR68noMxAECAwEAAaMzMDEwIQYDVR0RBBowGIEWei5z emFsYm90QGxjLXdvcmRzLmNvbTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAByS +Jt3BW2uX6CyiFXfz6ninAcCXkPSEHtjgcAHZGwV/TgEio1qKu60Pyn9ycP72XrRzEzCTG9a 85K+fmg6YjMNrrnjrEOlH+FqUt1tNj/ySrxxTLCipY8vakEL4jAyiybYecCj8JQHRxCUGbQo CVHnx+eFWySCZvEwCDb1G6/uMIICYjCCAcugAwIBAgIQe7+sk0tML0fh4llg5/79nTANBgkq hkiG9w0BAQUFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vpbmcg Q0EwHhcNMDgwNDI2MTUyMDM5WhcNMDkwNDI2MTUyMDM5WjBIMR8wHQYDVQQDExZUaGF3dGUg RnJlZW1haWwgTWVtYmVyMSUwIwYJKoZIhvcNAQkBFhZ6LnN6YWxib3RAbGMtd29yZHMuY29t MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDAFe3/cmWHcNwlJyPDT3V19OspOzP0vFF7 kQLpi2UI5pG2eRkg9UXQF+lVPLWtET7wtYkur18SAYAk86qqDL2AdX3CagPsX3nTmt5NlLlm T3x5XOw9aMwcFpEhjGJUy0trsNMOeb0zqgkNxwORLmTLP8G2wmeyZSibFHryegzEAQIDAQAB ozMwMTAhBgNVHREEGjAYgRZ6LnN6YWxib3RAbGMtd29yZHMuY29tMAwGA1UdEwEB/wQCMAAw DQYJKoZIhvcNAQEFBQADgYEAHJL4m3cFba5foLKIVd/PqeKcBwJeQ9IQe2OBwAdkbBX9OASK jWoq7rQ/Kf3Jw/vZetHMTMJMb1rzkr5+aDpiMw2uueOsQ6Uf4WpS3W02P/JKvHFMsKKljy9q QQviMDKLJth5wKPwlAdHEJQZtCgJUefH54VbJIJm8TAINvUbr+4wggM/MIICqKADAgECAgEN MA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBl MRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYD VQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUg UGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWls QHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMj VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQAD gY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTl UAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIAC ZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgw BgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3Rl UGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAY BgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2j ZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguC dJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4k sdMdRv9dX2VPMYIC4zCCAt8CAQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3VpbmcgQ0ECEHu/rJNLTC9H4eJZYOf+/Z0wCQYFKw4DAhoFAKCCAcMwGAYJKoZI hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDgwNTAyMTU1ODA2WjAjBgkq hkiG9w0BCQQxFgQU1udh82M1QawuyqfXD6jQeBDEfKEwUgYJKoZIhvcNAQkPMUUwQzAKBggq hkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZI hvcNAwICASgwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRo YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG cmVlbWFpbCBJc3N1aW5nIENBAhB7v6yTS0wvR+HiWWDn/v2dMIGHBgsqhkiG9w0BCRACCzF4 oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0 ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhB7v6yT S0wvR+HiWWDn/v2dMA0GCSqGSIb3DQEBAQUABIGAgE+RdoIxsysTglDKxRfzjUDJA5TiZgb/ vmRLXcEh8bsmQ0HvfexTeF1GcqOza9xedj+tL77Cpm6/UzCOUaDVM3yApAMpk8+dlmXTtsmp vJAjeKZWCMhhhk+wSbVeHyElgA7R1CXkf9rcuz0YZUJIAZ6aYy86DHBCawnbskBJGGIAAAAA AAA= --------------ms040604040504080305050305--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?481B3A0E.6060300>