Partition table mysql

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?

There are different types of partitions.

SEE:

MySQL - 19.2 Partitioning Types

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

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

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

Everything You Need to Know About MySQL Partitions

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

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

Everything You Need to Know About MySQL Partitions

Thanks