Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Partition pointValues table


  • The pointValues table has grown huge on mysql. How can i partition it to improve overall performance ?


  • here is one simple example:
    one day one PARTITION

    alert table pointvalues
    PARTITION BY RANGE (ts) (
    PARTITION b140601 VALUES LESS THAN (1401552000000),
    PARTITION b140701 VALUES LESS THAN (1404144000000),
    PARTITION b140801 VALUES LESS THAN (1406822400000)
    PARTITION b140801 VALUES LESS MAXVALUE
    )