Paul A schreef op do 17-09-2015 om 12:06 [-0400]: > We did try the innodb_file_per_table in 5.5 (but you have to ALTER all > the > tables to get the benefits) and the sum total of all the individual > files > was a little bigger than the original ibdata1 -- so whatever the > other > benefits might have been, "spacesaving" (which was my original reply) > was > not one of them.
You don't have to alter, a dump, drop database, and restore will sort it out. Space saving isn't strictly the goal. If you don't have file-per-table then free space from deleting rows can't be reclaimed, so the ibdata1 file will never shrink. This can mean that if, say, you empty that giant table of old staged records, you don't get that space back unless you're using file-per-table. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
