CodeIgniter Forums

Full Version: Partition table mysql
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
(10-06-2018, 03:59 AM)InsiteFX Wrote: [ -> ]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
(10-06-2018, 08:58 AM)InsiteFX Wrote: [ -> ]I found this web site might be of interest to you.

Everything You Need to Know About MySQL Partitions

Thanks