As some howto’s and wiki’s disappear from the internet, and I don’t want to use the “way back machine”, here are the sql scripts which I have used to partition the Zabbix History and Trends tables. I have tested these within Mysql v5.7 and v8.0.