Re: Bin Files.

On Sun, Oct 26, 2008 at 9:13 AM, Madan Thapa <[EMAIL PROTECTED]>wrote: > On Sat, Oct 25, 2008 at 5:50 AM, Grant Peel <[EMAIL PROTECTED]> wrote: >> > Hi all, >> > >> > I had a server pretty much locked up this morning due to the mysql bin >> logs filling up the /var filesystem. >> > >> > I had been

Re: Bin Files.

Deleting the files from the command line is not considered the 'correct' way: http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html There should be a 'log-bin' line in your my.cnf just comment it if you don't want binary logs. Yes, they're mostly just used for master/slave replication,

Bin Files.

Hi all, I had a server pretty much locked up this morning due to the mysql bin logs filling up the /var filesystem. I had been investigating the my.cnf settings file a white back, got sidetracked, and never finished it. The bin logs are named: /var/db/mysql/myserver-bin.01 /var/db/mysql/m

Re: LOAD DATA giving BIG mysql-bin files ...

, 2006 9:48 AM Subject: Re: LOAD DATA giving BIG mysql-bin files ... I think this is normal as the binary log will contain a record of all changes made to the data, therefore if you are loading large files regularly- the bin logs will be quite large. If you do not want the binary logging, edit the

Re: LOAD DATA giving BIG mysql-bin files ...

ce I have to load 12 inputfiles, I get about 2.5 GB of mysql-bin files. Question: is this normal ? If not, how can I avoid these mysql-bin files ? When using MySQL Administrator to look at a mysql-bin file, it shows only: 060330 8:29:00 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\m

LOAD DATA giving BIG mysql-bin files ...

bout 2.5 GB of mysql-bin files. Question: is this normal ? If not, how can I avoid these mysql-bin files ? When using MySQL Administrator to look at a mysql-bin file, it shows only: 060330 8:29:00 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Ver

Re: mysql bin files

On Tue, Aug 03, 2004 at 11:16:43AM -0600, Michael Gale wrote: > Hello, > > I am new to mysql and am in the middle of upgrading our mysql > server to the latest release. Upon viewing our currently data > directory I noticed a large amount of hostname-bin-### files. > >

RE: mysql bin files

Are you running the server with the log-bin option? If you do not need these for restoration and or backup purposes you can purge these files. -Original Message- From: Michael Gale To: [EMAIL PROTECTED] Sent: 8/3/04 12:16 PM Subject: mysql bin files Hello, I am new to mysql and

mysql bin files

Hello, I am new to mysql and am in the middle of upgrading our mysql server to the latest release. Upon viewing our currently data directory I noticed a large amount of hostname-bin-### files. Some of hostname-bin-### have time stamps of January -- from the documentation I have read I

Re: .bin.### files in /var/lib/mysql

"jon yeargers" <[EMAIL PROTECTED]> wrote: > > The /var/lib/mysql directory is collecting -bin.### files. > What are these? Should I be saving them? > They are binary log files: http://www.mysql.com/doc/en/Binary_log.html If you don't need binary log

Re: .bin.### files in /var/lib/mysql

Are you running Replication? - Original Message - From: "jon yeargers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 14, 2003 10:12 AM Subject: .bin.### files in /var/lib/mysql The /var/lib/mysql directory is collecting -bin.### files. What

.bin.### files in /var/lib/mysql

The /var/lib/mysql directory is collecting -bin.### files. What are these? Should I be saving them?

Re: -bin files

On Fri, Mar 21, 2003 at 01:16:46PM -0700, Jeff Mathis wrote: > great. the files are exactly as you describe. > > we are doing transactions when we load. auto commit is off, and the > loader commits rows after a certain number has hit the database. > however, if I understand you correctly, once a l

Re: -bin files

f your data, just what it took > to get there. You can use mysqlbinlog to translate them to SQL files. > > -jeff > > On Fri, 2003-03-21 at 12:52, Jeff Mathis wrote: > > we're using mysql-max4.04 on solaris 2.8. all tables are InnoDB tables. > > > > I see

Re: -bin files

on solaris 2.8. all tables are InnoDB tables. > > I see in the data directory a series of -bin files. I'm assuming > these are the index files. Is this correct? the sum total size of these > files are larger than the files I've allocated for data. How can I > manage these

-bin files

we're using mysql-max4.04 on solaris 2.8. all tables are InnoDB tables. I see in the data directory a series of -bin files. I'm assuming these are the index files. Is this correct? the sum total size of these files are larger than the files I've allocated for data. How can I man

re: server-bin files

On Monday 16 December 2002 22:37, Bc. Radek Krejèa wrote: > I found SERVER-bin.* files from today in my MySQL directory, where > are databases stored. What are theese files and why was created. > > SERVER-bin.001 > SERVER-bin.002 > SERVER-bin.index These files ar

server-bin files

Hello, I found SERVER-bin.* files from today in my MySQL directory, where are databases stored. What are theese files and why was created. SERVER-bin.001 SERVER-bin.002 SERVER-bin.index Owner mysql, group mysql. Thanks Radek -- S pozdravem, Bc. Radek Krejča Starnet, s. r. o

re: bin files

ometimes (I usually JT> go through and delete them daily - after deleting and re-creating about 4 JT> million entries, there were 3 bin files totalling almost 3 gigs...) JT> What are these files exactly (i always figured they were some sort of log), JT> why do they get so out of control

bin files

ng about 4 million entries, there were 3 bin files totalling almost 3 gigs...) What are these files exactly (i always figured they were some sort of log), why do they get so out of control with disk space, and is there any way i can get rid of the

Re: bin files

the bin log files are actually files for binary logs fused in replication. To do rollbacks and such, you need to use innodb table types. Innodb has table locking, commits, rollbacks, etc and also special log files to handle the rollbacks. Read more about innodb table types in the Mysql help. Other

bin files

So I have found out that mysql creates bin logs of all queries so that it can do rollbacks and such. But is it really necessary for it to maintain these logs forever so that they end up to be 10gigs + for only a few thousand current rows. Ric

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;E

RE: /usr/local/mysql/var/ bin files

le 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 fil

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> mass

/usr/local/mysql/var/ bin files

Hi All, A quick query, in the directory /usr/local/mysql/var there are machinename-bin.001, 002, 003 etc files that are being created. What are these files and what do they do. Can I get rid of them as they are taking up massive amounts of space. Any help greatly appreciated. thanks Leon. --

*-bin.* files??

I haven't installed mysql from the scratch, but used a precompiled version that comes with my distribution. Since I've updated it I see some *-bin.* files grow steadily very huge. What are these files in my /var/lib/mysql directory good for? Some kind of journalling for replication? D