oloflarsson.se
innodb_file_per_table for existing MySQL database
So you want to toggle innodb_file_per_table on for your existing MySQL database? This is a step by step guide explaining how to do just that. Should I really enable innodb_file_per_table? Some people prefer it on: I do http://www.mysqlperformanceblog.com/2007/11/01/innodb-performance-optimization-basics/ http://code.openark.org/blog/mysql/reasons-to-use-innodb_file_per_table https://tools.percona.com/wizard Some people prefer it off: http://umangg.blogspot.se/2010/02/innodbfilepertable.html Other Articles Other people have already written articles on the subject. I would suggest reading