Hello,
The MySQL server running my nextcloud db have a high CPU usage, there is constant request like this one:
UPDATE `oc_authtoken` SET `password` = 'xxx' WHERE `id` = yyy
There is around 10 requests in the same time which commit, updating (max 1sec time running each).
I don’t have any errors in logs (nextcloud or nginx). Same problem after restart services
If someone have an idea
Thanks
My config:
Nextcloud version: 21.0.1.1
Operating system and version: Debian 10
nginx version: 1.20.0-1
PHP version: 7.4.18-2
mysql version: mysql Ver 15.1 Distrib 10.5.10-MariaDB,
<?php
$CONFIG = array (
'updatechecker' => true,
'instanceid' => 'xxxx',
'passwordsalt' => 'xxxx',
'secret' => 'xxxx',
'trusted_domains' =>
array (
0 => 'mydomain',
1 => '192.168.1.x',
),
'datadirectory' => '/mnt/disk/nextcloud',
'version' => '21.0.1.1',
'dbtype' => 'mysql',
'dbname' => 'nextcloud',
'dbhost' => '192.168.1.x',
'dbtableprefix' => 'oc_',
'dbuser' => 'nextcloud',
'dbpassword' => 'xxx',
'logtimezone' => 'Europe/Paris',
'installed' => true,
'default_language' => 'fr',
'enable_previews' => true,
'preview_max_x' => 1024,
'preview_max_y' => 1024,
'preview_max_scale_factor' => 1,
'mail_smtpmode' => 'smtp',
'mail_from_address' => 'cloud',
'mail_domain' => 'xxx',
'maintenance' => false,
'overwriteprotocol' => 'https',
'defaultapp' => 'files',
'log_type' => 'file',
'mail_smtpauthtype' => 'PLAIN',
'filelocking.enabled' => true,
'theme' => '',
'mail_smtphost' => 'mail',
'mail_smtpport' => '25',
'overwrite.cli.url' => 'xxx',
'loglevel' => 2,
'logfile' => '/var/log/nextcloud.log',
'mysql.utf8mb4' => true,
'has_rebuilt_cache' => true,
'trashbin_retention_obligation' => '30,60',
'updater.release.channel' => 'stable',
'memcache.local' => '\\OC\\Memcache\\Redis',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '/var/run/redis/redis.sock',
'port' => 0,
),
'app_install_overwrite' =>
array (
0 => 'files_external_onedrive',
),
'trusted_proxies' => ['192.168.1.1'],
);