rmmg
1
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