Hi All, 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. regards anandkl On 6/15/07, Olaf Stein <[EMAIL PROTECTED]> 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 not aware of Thanks Olaf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
