>-----Original Message----- >From: Claudio Nanni [mailto:claudio.na...@gmail.com] >Sent: Wednesday, January 14, 2009 4:50 AM >To: Brent Clark >Cc: mysql@lists.mysql.com >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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
