CPU consumption

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 :slight_smile:
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.

image

I don’t know if it’s the cause of the issue …
I tried files:cleanup but did nothing.

Can you please help ? :slight_smile:

Steps to reproduce

  1. No idea

Expected behaviour

Not consumming too much CPU :slight_smile:

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 :frowning:

Hello,

I forgot to mention, there is only Owncloud installed on this server (and using mysql)
Can someone help, please ? :slight_smile:

Hi Adrien,
I see you’re running version 10.1.0 which had the exact performance issues you’re describing:
https://doc.owncloud.com/server/admin_manual/release_notes.html#changes-in-10-1-1
Can you go ahead and upgrade your ownCloud version?

Cheers,
Erik

Hi eneubauer,

Thanks, I didn’t noticed that in the changelog.
Can I upgrade from 10.1.0 to 10.2.1 directly ? Or should I just upgrade it to 10.1.1 ?

Adrien