:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 5. September 2002 13:07
An: Moestl, Wolfgang
Betreff: Re: Table partitioning functionality
Hi,
No, I'm afraid. MyISAM tables cannot be cut in several pieces. But check ot
the InnoDB table type, because they work very similar to Oracle. InnoDB
uses
Hi,
You could do the partitioning logic on the application side.
For example you can create a new table every month with a
different suffix corresponding to the year/month number.
Then you add the info about this new table into a master
description table, which holds one row per created table,
Hi,
Does MySQL offering a similar functionality as Oracle does with table partitioning?
Oracle can split a table into several pieces where the pieces are - usually -
identified by a range of valus.
For example, one may split a table holding data on a daily basis into monthly
partitions.
Hi,
No, I'm afraid. MyISAM tables cannot be cut in several pieces. But check ot
the InnoDB table type, because they work very similar to Oracle. InnoDB
uses tablespaces, and there can be many of them, maybe with autoextend
functionality.
I know it is not the same you would like, but maybe you