MySQL high CPU load oc_filecache

Hi,
Sometimes MySQL have high CPU load, getting to 100%, and with mytop I have dozens entries like this:

Sending SELECT SUM(size) AS f1, MIN(size) AS f2 FROM oc_filecache WHERE parent = ‘3957158’ AND storage = ‘314’

Does anybody help me with this?
Thanks
Cheers

Memory caching reduces the load on the server:
https://docs.nextcloud.com/server/9/admin_manual/configuration_server/caching_configuration.html

and for your database, you can also optimize your cache sizes, use tuning-primer.sh or mysqltuner scripts which help you to set reasonable values. I played around with some innodb_* values which resulted in a remarkable speed up:
https://github.com/owncloud/core/issues/20967#issuecomment-205474772
I haven’t found an “official” recommendation. Would be perhaps nice to have a few more tips on the documentation https://docs.nextcloud.com/server/9/admin_manual/configuration_database/linux_database_configuration.html