MySQL Forums
Forum List  »  Partitioning

Re: What is the performance degradation for huge partitioned tables?
Posted by: Mikael Ronström
Date: October 26, 2006 11:32PM

Hi,
Partitioning on a BLOB field is currently not supported so
you probably want to partition on a hash of the URL.

Rgrds Mikael

Per Arne Engstad Wrote:
-------------------------------------------------------
> For a project we want to store up to 5 billion
> (5.000 million) rows in a single database table.
> In order for this to work we need partitioning,
> and we probably need to use hash partitioning on a
> text field (URL). The table has a couple of
> indexes; a primary key (string) and at least one
> integer column which contains an index.
>
> Do you have any performance numbers/graphs which
> show:
> - the decrease in insert time per row as a
> function of number of rows in the table
> - the increase in select time per unique row as a
> function of number of rows in the table
>
> Do you have any experience wrt. maximum number of
> rows using partitioning in real applications on
> single-CPU Linux hardware?
>
> I hope you can help.
>
> Best regards
> Per Arne

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What is the performance degradation for huge partitioned tables?
2508
October 26, 2006 11:32PM


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.