MySQL Forums
Forum List  »  Partitioning

copy of SAP COPA
Posted by: Lars Johansson
Date: March 24, 2008 02:06AM

Hi,I can do with some advice.
I'm copying the SAP COPA table CE1xxxx over to a partitioned table using period as partition INDEX, this gives me a hell of a lot of partitions (one new each month). I now have 60 myisam partitions with aprox. 600.000 row in each. The intention with the copy is reporting, we never update or delete rows, just adding.
Is this a reasonable setup?
I have not started creating sensible secondary indexes yet, so still I do not know of performance, but my idea was to chop this table up for easier maintenance etc.
But I need very good read performance in the end.
Any advice is highly appreciated.
Is it possible to make Mysql to process partitions in parallel?
From what I read it is not, if so that is my absolute top wish for mysql.

p.s.
COPA CE1 tables - where all economical transactions ends up in an SAP system.

Options: ReplyQuote


Subject
Views
Written By
Posted
copy of SAP COPA
6584
March 24, 2008 02:06AM
2673
March 24, 2008 07:42AM
2846
March 24, 2008 10:12AM


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.