CodeIgniter Forums
Partition table mysql - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: Partition table mysql (/thread-71898.html)



Partition table mysql - omid_student - 10-06-2018

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?


RE: Partition table mysql - InsiteFX - 10-06-2018

There are different types of partitions.

SEE:

MySQL - 19.2 Partitioning Types


RE: Partition table mysql - omid_student - 10-06-2018

(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


RE: Partition table mysql - InsiteFX - 10-06-2018

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

Everything You Need to Know About MySQL Partitions


RE: Partition table mysql - omid_student - 10-06-2018

(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