I am using mysql where I am having a table with 3 integer columns c1, c2, c3.
- Value of column c2 is different on every row
- Value of column c1 will change around every 3 million rows.
- c3 is having only two values (1 or 2).
- primary key of the table is (c1, c2).
Table can have millions of records and we are require to perform following type of queries:-
- A select query which selects record based on a given value of c1 and c3.
- An update query which updates based on a given value of c1 and many values of c2.
Will partitioning the table in this scenario be help full, if yes which partitions should I look for ?