MariaDB (for ownCloud) High CPU Load

@michaing Maybe something we could add to our install script as tweak?

Does ownCloud probably have an occ for this like Nextcloud has?

occ db:add-missing-indices

nope, something like this is missing on OwnCloud. They support following db commands only

 db
  db:convert-mysql-charset      
  db:convert-type               
  db:restore-default-row-format 
1 Like

Then it sounds like a good idea to add that index. Not sure whether it can be tweaked a bit. Does someone know a reference from ownCloud docs or forum?