MySQL database partitioning

[tars]

We are running MySQL and our database has reached about 70Gigs so we're having lots of performance issues. From research it looks like we need to setup partitioning on MySQL.

I have seen the following document but it seems quite old, and it's a blog instead of documentation. Is there a more up to date document to help guide us with this change?

I have also seen the following Youtube video. In that video he references a Wiki article. That article (and wiki) don't exist anymore. There is also conflicting information in that video and the blog.

Any assistance appreciated.

Thanks

[PavelZ]

There is also a link to github - https://github.com/OpensourceICTSolu...titioning-perl
The project, although written in Perl, is updated occasionally. They have added Docker support..

There is an important addition: the nature of data in Zabbix contributes to its good compression.
Enable compression:

ALTER TABLE ... ROW_FORMAT=COMPRESSED

It will be worse than Postgres TSDB, but on MySQL you do not need to install any addons at all. Only standard functions are used.

If you use Grafana, you might find this dashboard useful - https://github.com/pavlozt/zabbix-db-auditor/

[tars]

Thanks, but is the blog article still valid? Are those are still the same tables you need to enable partitioning on? I don't know a lot about MySQL so trying to figure out the doc.

[PavelZ]

It seems to me that the article is even being updated)
It even describes zabbix 7.0 (history_bin table add) , but the article is dated 2021 - there was no zabbix 7.0 back then.

[tars]

Thanks both. I did notice the extra history_bin table in my setup and it's not shown in a Youtube video I was watching. I assume that is a new one.