You are here

Innodb file per table

Dear Team, I would like to know that enabling innodb file per table option will increase the performance in mysql

It depends on your setup and your workload, sometimes "innodb_file_per_table" is good for performance and some others it is not:
http://umangg.blogspot.ru/2010/02/innodbfilepertable.html

I would recommend you to test it first in a testing system before applying on productions.

For information about advantages and disadvantages of "innodb_file_per_table" check out this link:
http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html

abdel-mawlacomment