Periodically High mysqld CPU load with snap installation

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
,
1

Nextcloud version (eg, 20.0.5): 25.0.5
Operating system and version (eg, Ubuntu 20.04): Linux Mint 20.3 x86_64
Apache or nginx version (eg, Apache 2.4.25): idk
PHP version (eg, 7.4): 8.1.16

The issue you are facing:

While monitoring I find that, according to sysstat, every 12 minutes the CPU load of two mysqld processes spike to 100%.
Executing show full processlist gives the following at the time of the incident:

| 16698 | nextcloud       | localhost | nextcloud | Query   |    60 | executing              | SELECT `user_id` FROM `oc_filecache` `f` INNER JOIN `oc_mounts` `m` ON `storage_id` = `storage` WHERE (`size` < 0) AND (`parent` > -1) LIMIT 1 |

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Wait for 12 minutes.
2

Anyone…knows what this Query means?