MySQL high CPU load oc_filecache

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?

Memory caching reduces the load on the server:

and for your database, you can also optimize your cache sizes, use or mysqltuner scripts which help you to set reasonable values. I played around with some innodb_* values which resulted in a remarkable speed up:
I haven’t found an “official” recommendation. Would be perhaps nice to have a few more tips on the documentation