MySQL Forums
Forum List  »  Partitioning

Moving data from HEAP table to KEY partitioned ISAM table - advice needed
Posted by: Simon Hubbard
Date: November 26, 2010 06:09AM

Hi.

I need some advice.

I currently have a db that in it's main table has around 3.2M entries. This will soon grow to 100M.

This table is currently held in a heap table.

I don't think it's going to be feasible to continue to have this table in memory as it grows to 100M therefore I'm exploring putting it in a regular ISAM table but using KEY partitioning.

The two fields in my table are as follows:
domID(int 10)
domain(varchar 70)

99% of all the searches will be done on the domain field in this table.

My question is will KEY partitioning the table give me any performance increases as opposed to a non-partitioned ISAM table?

Bear in mind that most searches on the domain field will be using LIKE, so from my limited understanding a full table scan will be required anyway.

I'm hoping though that it's quicker for MySQL to perform a full table scan on 20 or so partitions rather than on a regular non-partitioned table?

Also, does anyone know if you can partition a heap table?

Many thanks!

Simon



Edited 2 time(s). Last edit at 11/26/2010 06:54AM by Simon Hubbard.

Options: ReplyQuote


Subject
Views
Written By
Posted
Moving data from HEAP table to KEY partitioned ISAM table - advice needed
2542
November 26, 2010 06:09AM


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.