Hi Daniel, So what would be a good solution within MySQL to store large amounts of data if they have to go into a single table? InnoDB seems to be the right table type to use (especially as they support transactions as well) but you do not have controll over the used tablespace. They are just filled up one by one when inserting new data.
I'm afraid doing table scans on table having a very high row count will kill performace. Even on a Oracle 9i I had alreay 50 minutes for a single full table scan on the table. Bye, Wolf -----Ursprüngliche Nachricht----- Von: Daniel Kiss [mailto:[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 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
