Skip navigation links

MySQL Forums :: Partitioning :: Error 23, 1016: Partition with MyISAM


Advanced Search

Re: Error 23, 1016: Partition with MyISAM
Posted by: Rick James ()
Date: April 01, 2009 12:49AM

I presume you are partitioning to make deletion easier. 200M rows in a single table is not a problem.

InfoBright could hold the data in under 10GB (probably).

If this is data warehousing, you should strive for only one index on the fact table. But that is another discussion.

Options: ReplyQuote


Subject Views Written By Posted
Error 23, 1016: Partition with MyISAM 9145 Rob Redmon 03/31/2009 09:07PM
Re: Error 23, 1016: Partition with MyISAM 4247 Phil Hildebrand 03/31/2009 11:35PM
Re: Error 23, 1016: Partition with MyISAM 3947 Rick James 04/01/2009 12:49AM
Re: Error 23, 1016: Partition with MyISAM 3727 Rob Redmon 04/01/2009 10:33AM
Re: Error 23, 1016: Partition with MyISAM 3788 Rob Redmon 04/01/2009 08:35AM
Re: Error 23, 1016: Partition with MyISAM 3915 Rob Redmon 04/01/2009 09:57AM
Re: Error 23, 1016: Partition with MyISAM 3557 Phil Hildebrand 04/02/2009 01:32AM
Re: Error 23, 1016: Partition with MyISAM 2990 Chris Slominski 06/02/2009 11:42AM


Sorry, you can't reply to this topic. It has been closed.

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.