Partitioning help

[Naresh Kondeboina]

Hi,

I am new to MySql partitioning. I need some help on partitioning my tables.

My db is having 2 tables:

Table T1:
Schema: (C1 int auto_incr PK, C2 int not null,c3....)
Total Records: 2.5Million
Partitioning col: C2(Range partition with 6 partitions)

Table T2;
Schema: (D1 int auto_incr PK, C1 FK to T1, D2,D3,...)
TotalRecords: >6Million

Question here is, Can I make partitions for T2 based on C2 as they are more co related.