> Is there any chance of loosing any data if I do that. Its a production machine > with over 200 thousand customer tickets
don't think so... > Is there any other suggestions ? If you don't use InnoDB too much (you don't have a lot of data in InnoDB tables) then you can change size of InnoDB data and log files in my.cnf file. But be careful. Use correct way. http://www.innodb.com/ibman.php#Adding_and_removing Mikhail. ----- Original Message ----- From: "Asif Iqbal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 23, 2004 8:18 PM Subject: Re: data file too big > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
