MySQL Forums
Forum List  »  Newbie

Partitioning or Not Partitioning?
Posted by: Manuel Gentili
Date: November 05, 2014 12:11PM

Dear All,

I'm new to this forum, and I'm sorry for my english :-)

I use Mysql for my personal website but now I have a problem that is difficult for me.

I have a table called for example data_test, in witch there are a lot of record. I make a function that is repeated every 1 second that insert about 5000 record every time, so in 3 second I have 15000 record and so on.

In this table I have ID (Primary key), date, customer ID (that can be duplicated), measurement ID (Type of measure that I do), measurement value.

I'd like to divide it for customer, so I think to use partitioning by hash or by key, but they can be duplicated, and I can't know the number of customer that I will have.

So I can create a table for every customer, but I probably will have 1000 or 2000 table in one year.

Any Ideas?
Thank you for your help, Manuel

Options: ReplyQuote

Written By
Partitioning or Not Partitioning?
November 05, 2014 12:11PM

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.