innodb_file_per_table vs ibdata1 performance

MySQL & MariaDB Other MySQL® Questions
1

Good day to all.

When i was choosing between file_per_table and “all in one” - ibdata some time ago, i googled this article - [url]http://umangg.blogspot.ru/2010/02/innodbfilepertable.html[/url]
Yes, it’s 2010 and it says, that ibdata architecture shows more perfomance, then file_per_table.

Can anyone approve it?

2

Hi,

I tought it’s hard to say which way you get better performance. I think better is to choose either shared tablespace or separate tablespace as per your database configuration, work load etc to achieve better performance. For instance, innodb_file_per_table is good when you are often truncates tables to reclaim disk space, to compress data, backup/restore partially i.e. single table/database, storing tables on separate disks etc I believe innodb_file_per_table edge on ibdata1.

Thanks,. .