Hi guys
im trying to partition zabbix tables but i get error
ERROR 1564 (HY000): This partition function is not allowed
this is when i try to partition table history_uind
>mysql>ALTER TABLE history_uint ADD PARTITION (PARTITION p2016_01_04 VALUES LESS THAN (UNIX_TIME('2016-01-14 02:00:00')));
mysql version is
"mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1"
im trying to partition zabbix tables but i get error
ERROR 1564 (HY000): This partition function is not allowed
this is when i try to partition table history_uind
>mysql>ALTER TABLE history_uint ADD PARTITION (PARTITION p2016_01_04 VALUES LESS THAN (UNIX_TIME('2016-01-14 02:00:00')));
mysql version is
"mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1"
Comment