Create index without downtime | TRANSITIONS

Support & Bugs
1

Hi,
I have a requirement to make the transitions feature work faster.
Checking the Matomo FAQ pages, i find that i need to add 3 index.

https://matomo.org/faq/how-to/faq_161/

The challenge is try to add the indexes without downtime, any advice?
I’m using MariaDB 10.4.10.

The tables sizes:
image

2

Hi,

I am no database expert and can’t help with avoiding downtimes this way, but you could try using this to not loose any data during downtimes:
https://matomo.org/faq/log-analytics-tool/faq_19221/