RE: Unused and empty tables -> what impact on mysql

2009-01-14 Thread Jerry Schwartz
>-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

Re: Unused and empty tables -> what impact on mysql

2009-01-14 Thread Brent Clark
Claudio Nanni wrote: 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 sur

Re: Unused and empty tables -> what impact on mysql

2009-01-14 Thread Claudio Nanni
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 useless