[omid_student]

Hi guys
I need use partition in my database mysql
I have 3 columns in table
UserID[PrimaryKey],CountryCode,Date

I need make partition table with CountryCode
But because it is not primary key so i cannot use partition base of CountryCode

How do use it?

[InsiteFX]

There are different types of partitions.

SEE:

MySQL - 19.2 Partitioning Types

[omid_student]

There are different types of partitions.

SEE:

MySQL - 19.2 Partitioning Types

I saw their my friend and i cannot use it
Only i cannot use non-primary key field in partition

[InsiteFX]

I found this web site might be of interest to you.

Everything You Need to Know About MySQL Partitions

[omid_student]

I found this web site might be of interest to you.

Everything You Need to Know About MySQL Partitions

Thanks