From owner-freebsd-questions@FreeBSD.ORG Fri May 2 12:27:35 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8382B1065688 for ; Fri, 2 May 2008 12:27:35 +0000 (UTC) (envelope-from z.szalbot@lc-words.com) Received: from relay.lc-words.com (relay.lc-words.com [62.121.130.110]) by mx1.freebsd.org (Postfix) with ESMTP id E88218FC1A for ; Fri, 2 May 2008 12:27:34 +0000 (UTC) (envelope-from z.szalbot@lc-words.com) Received: from localhost (localhost [127.0.0.1]) by relay.lc-words.com (Postfix) with ESMTP id 483BEC947C for ; Fri, 2 May 2008 14:27:33 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=lc-words.com; s=mainlcwords.key.pem; t=1209731253; bh=lJmqaJg33+aop2W1Xem0nirGesV yqJT41fTW0bWu+u8=; h=Message-ID:Date:From:Reply-To:MIME-Version:To: Subject:Content-Type; b=bAGo601b0UouYQfZW3M/fM15ZxXBdLDe6zMz8Oib7e 4xSjYTYghhlrEFbg1M3i7I7Fd3vh7SEEiinqpsE+UjqVJgxhJlSlApm56FjCgKb0mte NQtuPa9zrA2ruN04p1QWCvTcKtzUW3gVWmEmbtia3Ty6/JH6jsNqkqzNPoThH0= Received: from relay.lc-words.com ([127.0.0.1]) by localhost (relay.lc-words.com [127.0.0.1]) (amavisd-maia, port 10024) with ESMTP id 30912-05 for ; Fri, 2 May 2008 14:27:33 +0200 (CEST) Received: from [127.0.0.1] (cxw210.internetdsl.tpnet.pl [83.19.156.210]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: info@lc-words.com) by relay.lc-words.com (Postfix) with ESMTPSA id CE261C9421 for ; Fri, 2 May 2008 14:27:32 +0200 (CEST) Message-ID: <481B08B2.7070702@lc-words.com> Date: Fri, 02 May 2008 14:27:30 +0200 From: Zbigniew Szalbot User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: freebsd-questions@freebsd.org Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms060609020009050103070904" X-Virus-Scanned: Maia Mailguard Subject: handling mysql binlog data X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: z.szalbot@lc-words.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 May 2008 12:27:35 -0000 This is a cryptographically signed message in MIME format. --------------ms060609020009050103070904 Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit 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 --------------ms060609020009050103070904 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 hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDgwNTAyMTIyNzMwWjAjBgkq hkiG9w0BCQQxFgQUqM9wtq0m65474haOszvgHSFqmm4wUgYJKoZIhvcNAQkPMUUwQzAKBggq hkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZI hvcNAwICASgwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRo YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG cmVlbWFpbCBJc3N1aW5nIENBAhB7v6yTS0wvR+HiWWDn/v2dMIGHBgsqhkiG9w0BCRACCzF4 oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0 ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhB7v6yT S0wvR+HiWWDn/v2dMA0GCSqGSIb3DQEBAQUABIGAixEbd6aflFUrA3gSOrThb32YnhkP/2EC zssgPUpaQWtOU7hCSeYvQyS/7lkutuSvonIFBpmc2iAocoSGKEIJ3msxn5eRZiWunGQ6qAqJ 1lxuRcYjVCbbu+wwQt/qctHm/ENkkXysjRr+V5s0nt08sqxgMgYzirDufGXUi/RRkUoAAAAA AAA= --------------ms060609020009050103070904--