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 can use this
feature for your task.
Bye,
Daniel
At 12:28 2002.09.05. +0200, you wrote:
>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. Oracle will store the data in the partition identified
>by month of the new inserted data.
>As the tablespace used by each partition can be specified this is very
>usefull to spread the disk IO to several harddisks.
>
>The main reason for partitioning a table is to make VERY large tables more
>performant. Oracle fetches only the partions needed by the SQL statement,
>this means a full table scan will only process partitions identified by
>the WHERE clause and not the full range of data.
>
>If MySQL does not offer this or a simmilar functionality, how does MySQL
>perform on very large tables (I'm talking here about 10 Gigs+ of data
>stored in a single fact table)?
>
>Best Regards,
>Wolfgang
>
>
>---------------------------------------------------------------------
>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
---------------------------------------------------------------------
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
