Having indexing issues

  • The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running “occ db:add-missing-indices” those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
    • Missing index “preferences_app_key” in table “oc_preferences”.

I’m unsure how to sudo to this on nextbox to add the missing index’s, does anyone have the code?

Sorry for anyone who doesn’t speak german, the answer was in the forum. It’s this code.

sudo - s
docker exec -it -u www-data nextbox-compose_app_1 /var/www/html/occ db:add-missing-indices