Hello,
I have been running an Owncloud server for about 2 years now.
Few months ago, without changing anything, I noticed my CPU was peeking at 100% all the time.
It was running on Ubuntu 14.04 and an old Owncloud’s version, so I decided to fully upgrade to Ubuntu 18.04 and Owncloud X.
My CPU issue was gone, and I was a happy man
But, the problem just came back.
My CPU is @100% since a week, mysqld is taking all the CPU, and I have now idea how to solve this.
When I do “show full processlist;”, mysql returns ~60 rows, and all is about oc_filecache.
And a simple COUNT takes between 5 and 25s, and returns more than 2 millions.
I don’t know if it’s the cause of the issue …
I tried files:cleanup but did nothing.
Can you please help ?
Steps to reproduce
- No idea
Expected behaviour
Not consumming too much CPU
Server configuration
Operating system: Ubuntu 18.04
Web server: Apache
Database: Mysql
PHP version: 7.2.19
ownCloud version: 10.1.0
Updated from an older ownCloud or fresh install: Updated from older
Signing status (ownCloud 9.0 and above):
Login as admin user into your ownCloud and access
http://example.com/index.php/settings/integrity/failed
paste the results into https://gist.github.com/ and puth the link here.
No errors have been found.
The content of config/config.php:
List of activated apps:
Only basics ones
Are you using an external user-backend, if yes which one: LDAP
LDAP configuration (delete this part if not used)
Too sensitive
Client configuration
Browser: All browsers possible
Operating system: Windows (7,8,10), MAC
ownCloud log (data/owncloud.log)
Found no logs there