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 <trimur...@tulassi.com> 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
 - mdyk...@gmail.com

 May the Source be with you.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

  • index Trimurthy
    • Re: index Michael Dykman

Reply via email to