Hello,
I’ve been a happy nextcloud user for some years now.
I run a pretty simple nextcloud setup on a nuc that I also use as a media center.
Lately, couldn’t really say when I noticed that the NC performance started degrading. Nothing too bad but 2-3 extra secondes before showing the main files page.
When i checked the CPU use of the server i noticed that mysql was taking a lot of CPU, thing that i had not noticed previously.
I only have 4 active users so i don’t think i have a capacity problem (i5 Quad core proc with 8 gigs ram & ssd)
htop gives me various lines that look like:
2263 mysql 20 0 633M 263M 9720 S 78.7 3.3 5h25:29 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
18969 mysql 20 0 633M 263M 9720 S 57.3 3.3 43:57.12 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
So i got curious and went checking what query runs I see this exact query all the time:
Query updating UPDATE
oc_filecacheSET
mimetype= '117' WHERE (
mimetype<> '117') AND (
mimetype<> '2') AND (LOWER(
name) LIKE '%.dcm')
No matter what I do.
Is my setup getting old or is something messing with my nextcloud setup?
Thanks and have a nice day,