Am 24.06.2014 21:07, schrieb shawn l.green: > It makes a huge difference if the tables you are trying to optimize have > their own tablespace files or if they live > inside the common tablespace. > > http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_file_per_table
which is the most stupid default in case of innodb and only survivable without a lot of work for people who realize that *before* start operations and enable "innodb_file_per_table" from the very begin having defaults which can't be changed later without complete re-import of data and prevent from ever get disk space for long ago deleted data free is the most wrong thing a software developer can do
signature.asc
Description: OpenPGP digital signature