Despite the conventional wisdom, converting to innodb_file_per_table will not necessarily
help you. It depends on your situation. If most of your growth is in a single table, you
will only have transferred the problem from the ibdata1 file to a new file. The ibdata1
file may also continue to grow, since innodb uses it for several kinds of temporary
storage such as the insert buffer and the undo logs (AKA "rollback segment").
Information Technology Enterprise
Iowa Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137