MariaDB table partitioning

Hi,

Anyone has done MariaDB table partitioning in ERPNext application ?

I wonder how to create range partitioning, for example on “posting_date” field, since most of table’s primary key is using “name” field.
Do I have to add posting_date in primary key ?

Thank you.
Subhajit