views:

24

answers:

0

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:-

  1. A select query which selects record based on a given value of c1 and c3.
  2. 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 ?