RE: /usr/local/mysql/var/ bin files
Hi, Just stopped and started mysql with the -O max_binlog_cache_size=100, but still this bin.001 file is increasing way over this limit, so it may not be this:( I didn't think it was due to replication as we do not have any replication setup. Also check the contents of the file. ?bin(iI;E3.23.43-log(iI;iI;ADatabasecreate table tablename(date varchar(9), time varchar(10), orig varchar(20), action varchar(10), ifdi r varchar(8), src varchar(30), dst varchar(20), service varchar(20))FiI;aDatabaseINSERT INTO table this is the top, the all INSERTS and values added are in the file. I assumed it was a cache as these were all previous actions but can't get a limit on this file. It is okay to periodically delete this file as it does not cause any damage to the database, already checked that one:) but above option does not seem to work. anyone have any other ideas thanks :) Leon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: /usr/local/mysql/var/ bin files
Hello Leon, Thursday, October 18, 2001, 5:09:13 PM, you wrote: LN A quick query, in the directory /usr/local/mysql/var there are LN machinename-bin.001, 002, 003 etc files that are being created. What are LN these files and what do they do. Can I get rid of them as they are taking up LN massive amounts of space. these files are created in Master server in a replication scheme... -- Best regards, SAE's System Administrator [EMAIL PROTECTED] World Council of Hellenes Abroad 2 Komotinis str. 54655 - Thessaloniki GREECE --__--__--__-- This message was passed through SAE's Mailgate Server. Our MailGate Server employs the latest antivirus antispam technology. Please report any errors to [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: /usr/local/mysql/var/ bin files
I found a MySQL system variable max_binlog_cache_size| 4294967295 would caching have anything to do with it rather than replication? thanks Leon. -Original Message- From: SAE's System Administrator [mailto:[EMAIL PROTECTED]] Sent: 18 October 2001 15:22 To: Leon Noble Cc: [EMAIL PROTECTED] Subject: Re: /usr/local/mysql/var/ bin files Hello Leon, Thursday, October 18, 2001, 5:09:13 PM, you wrote: LN A quick query, in the directory /usr/local/mysql/var there are LN machinename-bin.001, 002, 003 etc files that are being created. What are LN these files and what do they do. Can I get rid of them as they are taking up LN massive amounts of space. these files are created in Master server in a replication scheme... -- Best regards, SAE's System Administrator [EMAIL PROTECTED] World Council of Hellenes Abroad 2 Komotinis str. 54655 - Thessaloniki GREECE --__--__--__-- This message was passed through SAE's Mailgate Server. Our MailGate Server employs the latest antivirus antispam technology. Please report any errors to [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
