Hi Sebastian, It depends. In general, no. In some filesystems and operating systems, it actually helps. I think you can base your decision on whether it makes server administration easier for you.
Regards Baron On Wed, May 27, 2009 at 2:45 AM, Sebastien MORETTI <sebastien.more...@unil.ch> wrote: > Hi, > > Does the use of "innodb_file_per_table" option imply a performance cost ? > Compared to default: all InnoDB indexes are in ibdataX file(s). > > Thanks > > -- > Sébastien Moretti -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org