On Nov 29, 2011, at 11:50 AM, Claudio Nanni wrote:
>
> This is not to say that MySQL could not have more of the file management
> features. For example, the ability to add or remove datafiles on the fly and the
> ability to detach tablespaces as collections of tables.
>
> That's where MySQL(read InnoDB) got stuck actually, it never introduced a powerful
> datafiles management system,
> and that is where Oracle excels (as far as being almost a O.S.) with multiple level
> of abstractions, just think of ASM.
> It is actually the part of Oracle I like most as well as the really "oraclish" way to
> get stats out of it!
> The 'problem' with MySQL is that it is so easy to start with it that people do not
> realize that is also a real RDBMS.
> --
Yes, Oracle has features of the known kind. But, if we consider the wishlist for InnoDB,
then on top there would be an
ability to add files without stopping database (that is without innodb tablespaces),
followed by the ability to control
which files are part of the database (information schema of that).
It looks like at some point they have decided that the file per table thing will cover all
needs. Well, it doesn't. I personally
do not like dealing with 50G files should individual table grow to this size. It will be
much better managed with a larger collection
of smaller files, without innodb tablespaces. It is after I have those I would want the
features like removing files or compacting
the database.

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.