If you specify one file per table, these files would be created under the
database directory of that particular database . So, the benifit with
respect to IO is negative. To have these files placed in different file
system to get IO benifit, you need to use symbolic links.
Please correct me if i am wrong.
On 6/15/07, Olaf Stein <steino@stripped> wrote:
> Hi all,
> Are there any reasons why one would NOT use separate ibd files for each
> table (--innodb_file_per_table). It seems logical to me to separate what
> does not belong together logically (different databases), but I as the
> shared tablespace is the default I wonder if it has nay advantages I am
> aware of
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1