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.
The challenge is try to add the indexes without downtime, any advice?
The tables sizes:
I recommend you there also mention your MySQL version etc as the answer might depend on this (eg does it support online updates or not). A search in your favourite search engine for adding indexes without downtime might help too.