>From: Claudio Nanni [mailto:claudio.nanni@stripped]
>Sent: Wednesday, January 14, 2009 4:50 AM
>To: Brent Clark
>Subject: Re: Unused and empty tables -> what impact on mysql
>Empty files, like empty tables is not synonym for useless or unused.
>Of course it depends from the storage engine used but
>in the list of performance tuning removing empty tables is way way down,
>they have almost no impact while not used.
>The bottom line, remove only when sure 100% of their uselessness.
[JS] Rename them before deleting them. If that break things, you can recover
very quickly. I was bitten by exactly this issue. I thought the application
was creating the empty tables on the fly, but it turned out that (only) one
of them was required to pre-exist.