I have been using nextcloud in its current configuration for several years. Iâm up to date with system updates and nextcloud.
Nextcloud was never a speed demon, but now itâs just a disaster. Opening the page takes up to 1 minute.
Previously slow operation, I had the impression that it was due to the hardware. However, I installed PhotoPrism, which uses the directory where nextcloud stores photos. Photoprism has no performance problems, entire albums load very quickly, without delays.
After recent system updates (docker, docker-copose), nextcloudâs performance is unacceptable. I have done all mariadb and mysql updates. Did not help. I downgraded docker-ce because portainer had trouble opening the bash console.
I checked everything I could. Previously, when using nextcloud, the CPU load reached 100%. Currently it uses a maximum of 15%.
<?php
$CONFIG = array (
'instanceid' => '***',
'passwordsalt' => '*******',
'secret' => '*******',
'trusted_domains' =>.
array (
0 => '***.duckdns.org',
),
'datadirectory' => '/var/www/html/data',
'dbtype' => 'mysql',
'version' => '28.0.3.2',
'overwrite.cli.url' => '***.duckdns.org',
'overwritehost' => '***.duckdns.org',
'overwriteprotocol' => 'https',
'dbname' => 'nextcloud',
'dbhost' => 'db',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'nextcloud',
'dbpassword' => '*****',
'installed' => true,
'default_phone_region' => 'ISO 3166-2:PL',
'htaccess.RewriteBase' => '/',
'memcache.local' => '\\OC\\Memcache\\APCu',
'apps_paths' =>.
array (
0 =>.
array (
'path' => '/var/www/html/apps',
'url' => '/apps',
'writable' => false,
),
1 =>.
array (
'path' => '/var/www/html/custom_apps',
'url' => '/custom_apps',
'writable' => true,
),
),
'maintenance' => false,
'theme' => '',
'debug' => true,
'loglevel' => 1,
'categoryList' => '',
'mail_smtpmode' => 'smtp',
'mail_sendmailmode' => 'smtp',
'mail_domain' => 'gmail.com',
'mail_smtpport' => '587',
'mail_from_address' => '****',
'mail_smtphost' => 'smtp.gmail.com',
'mail_smtpauthtype' => 'LOGIN',
'enable_previews' => true,
'enabledPreviewProviders' =>.
array (
0 => 'OC\\Preview\\Movie',
1 => 'OC\\Preview\\PNG',
2 => 'OC\\Preview\\JPEG',
3 => 'OC\\Preview\\GIF',
4 => 'OC\\Preview\\BMP',
5 => 'OC\\Preview\\XBitmap',
6 => 'OC\\Preview\\MP3',
7 => 'OC\\Preview\\MP4',
8 => 'OC\\Preview\\AVI',
9 => 'OC\\Preview\\MKV',
10 => 'OC\\Preview\\TXT',
11 => 'OC\\Preview\\MarkDown',
12 => 'OC\\Preview\\PDF',
13 => 'OC\\Preview\\HEIC',
14 => 'OC\\Preview\\HEVC',
),
'updater.release.channel' => 'stable',
0 => 'opcache.save_comments = 1',
1 => 'opcache.revalidate_freq = 60',
2 => 'opcache.validate_timestamps = 0',
3 => 'php_memory_limit=1G',
4 => 'upload_max_filesize=16G',
5 => 'php_upload_limit=16G',
'memories.exiftool' => '/var/www/html/custom_apps/memories/bin-ext/exiftool-amd64-glibc',
'memories.ffmpeg_path' => 'ffmpeg',
'memories.ffprobe_path' => 'ffprobe',
'mail_smtpdebug' => false,
'memories.vod.path' => '/var/www/html/custom_apps/memories/bin-ext/go-vod-amd64',
'memories.vod.ffmpeg' => '/usr/bin/ffmpeg',
'memories.vod.ffprobe' => '/usr/bin/ffprobe',
'filelocking.enabled' => true,
'trusted_proxies' =>.
array (
0 => '127.0.0.1',
1 => '192.168.1.25',
),
'mail_smtpauth' => 1,
'mail_smtpname' => '**********************',
'mail_smtppassword' => '*******************',
'maintenance_window_start' => 1,
'preview_max_memory' => 512,
'app_install_overwrite' =>.
array (
0 => 'metadata',
),
);
I also have errors (example):
Error cron Doctrine\DBAL\Exception: 2024-03-22T23:10:01+00:00
Failed to connect to
the database: An
exception occurred in
the driver:
SQLSTATE[HY000] [2002]
Connection refused at
lib/private/DB/Connection.php
line 139
0. .../Connection.php line 1654
OC\DB\Connection->connect(
)
1. .../Connection.php line 1081
Doctrine\DBAL\Connection->getWrappedConnection(
)
2. .../Connection.php line 261
Doctrine\DBAL\Connection->executeQuery(
... `",
... [],
... [],
... ll
)
3. .../QueryBuilder.php line 337
OC\DB\Connection->executeQuery(
"SELECT ... `",
... [],
... [],
... ll
)
4. .../QueryBuilder.php line 377
Doctrine\DBAL\Query\QueryBuilder->executeQuery(
)
5. .../QueryBuilder.php line 280
Doctrine\DBAL\Query\QueryBuilder->execute(
)
6. .../AppConfig.php line 421
OC\DB\QueryBuilder\QueryBuilder->execute(
)
7. .../AppConfig.php line 187
OC\AppConfig->loadConfigValues(
)
8. .../AppConfig.php line 377
OC\AppConfig->getApps(
)
9. .../AppManager.php line 128
OC\AppConfig->getValues(
... se,
... d"
)
10. .../AppManager.php line 149
OC\App\AppManager->getInstalledAppsValues(
)
11. .../OC_App.php line 231
OC\App\AppManager->getInstalledApps(
)
12. .../Coordinator.php line 90
OC_App::getEnabledApps(
)
13. .../base.php line 700
OC\AppFramework\Bootstrap\Coordinator->runInitialRegistration(
)
14. .../base.php line 1200
OC::init(
)
15. cron.php line 43
require_once(
"\/var\/www\/html\/lib\/base ... p"
)
Error PHP Error: Class 2024-03-24T10:58:56+00:00
"OCA\DAV\Connector\Sabre\ExceptionLoggerPlugin"
not found at
/var/www/html/remote.php#62
I have no idea what else I can do.