> I believe that this will flush those logs: > > mysql> reset master;
No.. It won't shrink any of InnoDB datafiles: > > 101M ib_logfile0 > > 101M ib_logfile1 > > 1.9G ibdata1 > > 1.5G ibdata2 It could help if you have some MySQL binary logs: <hostname>-bin.001 ... <hostname>-bin.00N Best regards, Mikhail. ----- Original Message ----- From: "Gregory Newby" <[EMAIL PROTECTED]> To: "Asif Iqbal" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 22, 2004 11:32 PM Subject: Re: data file too big > I believe that this will flush those logs: > > mysql> reset master; > > -- Greg > > On Thu, Jan 22, 2004 at 05:23:07PM -0500, Asif Iqbal wrote: > > Hi All > > > > My data file has all these files > > > > (root)@webrt:/usr/local/mysql/data# du -sh * > > 25K ib_arch_log_0000000000 > > 3.0K ib_arch_log_0000000002 > > 3.0K ib_arch_log_0000000004 > > 101M ib_logfile0 > > 101M ib_logfile1 > > 1.9G ibdata1 > > 1.5G ibdata2 > > 2.0K my.cnf > > 70K mysql > > 2.0K newdb > > 39M rt3 > > 12K test > > 67K webrt.err > > 1.0K webrt.pid > > > > Is there anyway I can remove some of them so I can get some space back ? > > > > I am using mysql -4.0.13 on Solaris 8 > > > > -- > > Asif Iqbal > > PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu > > There's no place like 127.0.0.1 > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]