On Fri, 23 Jan 2004, Mikhail Entaltsev wrote: > Date: Fri, 23 Jan 2004 09:34:52 +0100 > From: Mikhail Entaltsev <[EMAIL PROTECTED]> > To: Gregory Newby <[EMAIL PROTECTED]>, Asif Iqbal <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: data file too big > > > I believe that this will flush those logs: > > > > mysql> reset master;
Is there any chance of loosing any data if I do that. Its a production machine with over 200 thousand customer tickets > > 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 I don't. Is there any other suggestions ? > > 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] > > > > > > -- 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]
