Re: index

[Michael Dykman]

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.