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.
On Wed, May 27, 2009 at 2:45 AM, Sebastien MORETTI
> Does the use of "innodb_file_per_table" option imply a performance cost ?
> Compared to default: all InnoDB indexes are in ibdataX file(s).
> Sébastien Moretti
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html