Having indexing issues

NextBox
#1
  • 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?

#2

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