Ad Widget

Collapse

zabbix partition problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TASSA
    Junior Member
    • Dec 2014
    • 27

    #1

    zabbix partition problem

    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"
  • ingus.vilnis
    Senior Member
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Mar 2014
    • 908

    #2
    Hi,

    What manual are you using for partitioning?
    Try this one (http://zabbix.org/wiki/Docs/howto/mysql_partitioning) and use external script mentioned there for creating/deleting partitions after initial setup.

    Best Regards,
    Ingus

    Comment

    Working...