MySQL Forums :: Newbie :: Partitioning or Not Partitioning?


Advanced Search

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


Subject Written By Posted
Partitioning or Not Partitioning? Manuel Gentili 11/05/2014 12:11PM
Re: Partitioning or Not Partitioning? Rick James 11/05/2014 04:53PM
Re: Partitioning or Not Partitioning? Manuel Gentili 11/06/2014 02:57AM
Re: Partitioning or Not Partitioning? Rick James 11/06/2014 07:16PM
Re: Partitioning or Not Partitioning? Manuel Gentili 11/07/2014 02:07AM
Re: Partitioning or Not Partitioning? Rick James 11/08/2014 05:10PM
Re: Partitioning or Not Partitioning? Manuel Gentili 11/12/2014 05:33PM
Re: Partitioning or Not Partitioning? Manuel Gentili 11/17/2014 11:32AM
Re: Partitioning or Not Partitioning? Rick James 11/19/2014 04:42PM
Re: Partitioning or Not Partitioning? Manuel Gentili 11/20/2014 04:53AM
Re: Partitioning or Not Partitioning? Rick James 11/21/2014 08:26PM
Re: Partitioning or Not Partitioning? Manuel Gentili 11/24/2014 07:30AM
Re: Partitioning or Not Partitioning? Rick James 11/24/2014 07:21PM
Re: Partitioning or Not Partitioning? Manuel Gentili 11/25/2014 04:35AM
Re: Partitioning or Not Partitioning? Rick James 11/25/2014 11:45AM
Re: Partitioning or Not Partitioning? Rick James 11/25/2014 11:55AM
Re: Partitioning or Not Partitioning? Rick James 11/29/2014 03:42PM
Re: Partitioning or Not Partitioning? Wayne Rasmussen 11/24/2014 05:14PM


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.