I wonder, if there could be any method to regain InnoDB space other than
dump the whole database and reimport.
On Thu, Nov 10, 2011 at 12:44 AM, Johan De Meersman <vegivamp@stripped>wrote:
> ----- Original Message -----
> > From: "Nick Khamis" <symack@stripped>
> > 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:
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat