I wonder, if there could be any method to regain InnoDB space other than dump the whole database and reimport.
Thanks, On Thu, Nov 10, 2011 at 12:44 AM, Johan De Meersman <vegiv...@tuxera.be>wrote: > ----- Original Message ----- > > From: "Nick Khamis" <sym...@gmail.com> > > > > I should mention that we have deleted the ib_* files in the past. > > I hope that was an accident, because if you thought that was a good idea > I'm sending someone over with the spiked cluebat. > > Luckily for you, the solution to that particular problem (in the cases > where it's indeed caused by the delete of the ib_data files) is more > deletes, and you're good at those :-p > > The tables show up in the listing because in the <mysqldata>/<database> > directory there are .frm (table descriptor) files created for tables of all > engines, even though those files are really artifacts from the MyISAM > legacy. Thus, the server scans it, lists it, notices it's an InnoDB table > and then fails to find it in the InnoDB data dictionary because you deleted > the one it was in. > > Simply delete the .frm file for such tables, and they'll no longer show up. > > > > As for file_per_table, it's generally a good idea to set that to 1, yes. > Be aware that you may need to tune other MySQL and/or OS level settings, > too, for example max_open_files. > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com > > -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat