innodb_file_per_table
, and you’re done. Before : 70% RAM used, now ~40%.http://u.qdnx.org/file/postblue-20130603T001356-yaye5gz.html
Nice how-to for reducing #innodb diskspace usage http://vdachev.net/2007/02/22/mysql-reducing-ibdata1/ cc @jpope @jbfavre add