From: Michael Dykman
Date: October 30 2012 6:00pm
Subject: Re: index
List-Archive: http://lists.mysql.com/mysql/228541
Message-Id: <CANLyif-2h2HO9gD4r91-Y5wwCJRzLBfKnPCXZhcfKHacKR22zw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

Innodb stores it's indexes internally in the datafile; they do consume
storage, but that space is shared with the data.

innodb_per_file will, in most cases, enhance performance in a
high-concurrency environment.  It also can simplify administration,
and help limit your liabilities in the event of catastrophic
filesystem error.

 - md

On Tue, Oct 30, 2012 at 3:18 AM, Trimurthy <trimurthy@stripped> wrote:
> hi lists          1. does the indexes require additional storage other than
> the table space storage.          2. is there any performance difference
> will be there, if we go for innodb_file_per_table.
>
>
>
>
>
>
>   Normal
>   0
>
>
>
>
>   false
>   false
>   false
>
>   EN-US
>   X-NONE
>   AR-SA
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Thanks & Kind Regards,
>
>  TRIMURTHY
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.