how to partition syslog table

[ajmal2021]

Hello there,
We are using cacti with syslog plugin for the logs, both latest versions. We are getting millions of logs per week and therefore the system is pretty slow, it often takes like 10 minutes to get to logs.

I was hoping if someone could guide me on how to perform a range or hash partitioning on the syslog table.

Any help would be appreciated.

Thanks in advance

[TheWitness]

The best thing to do is to re-install using the latest version of the plugin, which is much more scalable and enable partitioning from the installer.