Re: Unique table space or space per table ...
Some rough guidelines
pro per table space: you have single files for one table if you want to make backups etc, fragmentation of tablespace is lower
"against": you cannot easily downgrade to 4.0 branch, so if you want to downgrade you have to dump all data, you cannot let innodb just take up say 40gb space for table spaces (that point doesnt have a really big impact)
hint: be sure to have the newest version if you use 4.1 branch because innodb had a bug in earlier releases that could lead to corruption
Subject
Views
Written By
Posted
3064
March 18, 2005 04:13PM
Re: Unique table space or space per table ...
2200
March 18, 2005 07:43PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.