[Koha-devel] Cleaning up...

[Robin Sheat]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: This is a digitally signed message part
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20150918/d026c3c2/attachment.pgp>