Zabbix MySQL Partionioning to Housekeeping

[scout]

Hello,

Is there any supported workaround how to move back from MySQL database partitioning to internal Zabbix housekeeping structure?
At the moment we have a working production database which was implemented with external Perl script to make table partitioning and disable internal housekeeping. I'm thinking of moving back to internal housekeeping.

Thanks

[kloczek]

How many nvps you have now?

[scout]

Around 620.

Why I'm thinking of moving out from partitioning - I thought it could be related to high queue number but just after posted this message I found out that I didn't have applied partition for history_text and history_uint (if I'm not mistaken) tables.

Right now all required tables have partitions and I need to wait for at least a week to clear history_text table data because it takes around 60G.

Btw, any suggestions were to start for troubleshooting high queue numbers? I have right now around 5K. Most of it is SNMPv2 agent items. Tried to increase update interval for some templates but seems it didn't help.

Thanks for suggestions or any comments

[kloczek]

IMO even with ~600 nvps it is worth to use partitioned tables.
Nevertheless if you want to tremve partitions just do "ALTER TABLE <table_name> REMOVE PARTITIONING;".
https://dev.mysql.com/doc/refman/5.7...anagement.html

[scout]

I found out that I didn't do partitioning on some of the tables.
for now created partitions for those tables and fixed script to make nightly partitioning