MySQL Forums
Forum List  »  Partitioning

Re: Moving data from HEAP table to KEY partitioned ISAM table - advice needed
Posted by: Rick James
Date: November 27, 2010 11:57AM

100M rows -- does that equate to about 3GB of table size? How much RAM do you have?

These have radically different performance characteristics:
LIKE 'abc%'
LIKE '%abc%'
Which are you doing?

Please do SHOW CREATE TABLE.

Partitioning for this case does not help performance.

Please do EXPLAIN SELECT ...;

If you are currently using a MEMORY table, do you realize that the data has no 'persistence'?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Moving data from HEAP table to KEY partitioned ISAM table - advice needed
1227
November 27, 2010 11:57AM


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.