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

Unused and empty tables -> what impact on mysql

2009-01-14 Thread Brent Clark
Hiya I just inherited a project, and before I get started, Id like to do a little clean up. There a * load of unused and empty tables in the db. My question is, does this in any way affect the performance of mysql in anyway and if so how? Kind Regards Brent Clark -- MySQL General Ma