Partitioning or Not Partitioning?
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
Subject
Written By
Posted
Partitioning or Not Partitioning?
November 05, 2014 12:11PM
November 05, 2014 04:53PM
November 06, 2014 02:57AM
November 06, 2014 07:16PM
November 07, 2014 02:07AM
November 08, 2014 05:10PM
November 12, 2014 05:33PM
November 17, 2014 11:32AM
November 19, 2014 04:42PM
November 20, 2014 04:53AM
November 21, 2014 08:26PM
November 24, 2014 07:30AM
November 24, 2014 07:21PM
November 25, 2014 04:35AM
November 25, 2014 11:45AM
November 25, 2014 11:55AM
November 29, 2014 03:42PM
November 24, 2014 05:14PM