From: Claudio Nanni
Date: January 14 2009 9:49am
Subject: Re: Unused and empty tables -> what impact on mysql
List-Archive: http://lists.mysql.com/mysql/215912
Message-Id: <53bcf3a60901140149l494b3bf2u552d5fd8d5af44aa@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=000e0cd2501613940904606e430f

--000e0cd2501613940904606e430f
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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.

Cheers
Claudio Nanni


2009/1/14 Brent Clark <brentgclarklist@stripped>

> 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 Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@stripped
>
>

--000e0cd2501613940904606e430f--