Is there a plan to have any tablespace management tools for innobase?
I personaly dont' care if these are via a separate program or through
the mysql SQL interface but the following would be very handy.
move tables between tablespaces
list tables in a tablespace
shrink tablespace
It is very handy with BDB and MyISAM tables to be able to back them
up directly or move them across different machines. If I have
a large database server with gigs of InnoDB tablespace and we need
to move a single database or table to another server it would
require mysqldump and reloading the tables, which can be very slow
for large tables. This seems to be the main disadvantage of the table
space method. It would be nice if one could move a binary table
with the following steps.
- shutdown the server
- copy a table into a new tablespace by itself
- move the "portable" table space to the new server
- expand the tablespace for growing room or copy the table to an
existing tablespace
I realize these are major things, I'm just curious if there are plans
for any of the above sort of tools.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
