Re: InnoDB

[gerald_clark]

I delete the old binlogs after doing my nightly mysqlhotcopy.

Tiele Declercq wrote:

Hey, thanks fopr the tip. Indeed the line was in there. Can i now erase
those bin files that have been written before ?
----- Original Message -----
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Tiele Declercq" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 6:39 PM
Subject: Re: InnoDB
 

Those are binary log files used in replication.
If you are not running replication, remove the line
bin-log
from the config file.
Tiele Declercq wrote:

   

Hey guys,

Ii could not find an answer on the innodb website, i'm using InnoDB now
     

for some months and i'm very happy since the constant corruptions i had in
MyISAM are gone now. Although i have been warned that InnoDB would take up
more diskspace i did not suspect gigabytes.
 

When first installed i've set up my DB file at 300MB, hold in mind that
     

the database is quiet large... some tables hold over 2.000.000 records (for
statistics). I soon realized this would have to be a bit bigger so i've set
this to 2G's. Did this because i saw some binary files in my MySQL dir...
myname-bin.001, 002, 003,..... up to 30 for now. Sometimes 2 each day
sometimes none for a few days... Biggest so far is 1G... there are 4 of
those. Total size of those binary files is 7.5G's and i have NO idea what
those files do. I think i've read the complete manual but could find
anything about these files. It can't be log files coz that's ib_logfile0 &
1, each set at 150MB).
 

My total disk space is 40Gb...  so it's enough to hold it for now but i
     

WILL run out of space in a couple of months at this rate. Can i safely
remove these files ? I'm pulling backups of my database each day so if
something goes wrong i can easily restore it.
 

So the currect db file is 2GB big and i have over 1GB free... so it's NOT
     

the ibdata file that takes up diskspace but the hostname-bin.xxx files are
bugging me.
 

Best Regards,

Tiele Declercq
---
Projectleider Start.be
Moderator http://pcshop.start.be
---
http://start.be
     



   



 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]