Hello,
Sorry for the delay falzo, I was trying to fix the problem but I couldn’t.
I am still getting this error on the nextcloud.log
MySQL server has gone away
Here is the error in details
it essentially means you are hitting a timeout or something like that. as we don’t know how large your tables already are in terms of number of files and whatnot, and which other extension, apps and plugins you might run, it could be a lot here from simply overloading the server up to just the need of fine tuning your mysql settings.
I have a VPS at DigitalOcean with 2 vCPUs and 4GB / 80GB Disk. I am running 2 Wordpress Websites and NextCloud with less than 1000 visitors a day.
This is my.cnf I only changed.
max_allowed_packet = 512M
wait_timeout=3600
Here are an image that shows the server load over a week.
also, do you use memcached/redis etc.? maybe also check if that is configured and running correctly…
Yes, I have Redis installed and added to the NextCloud config.php file
‘memcache.local’ => ‘\OC\Memcache\APCu’,
‘filelocking.enabled’ => true,
‘memcache.locking’ => ‘\OC\Memcache\Redis’,
‘redis’ =>
array (
‘host’ => ‘localhost’,
‘port’ => 6379,
‘timeout’ => 0.0,
),
I tried to ping the redis-cli and this is the outcome.
This is the redis.conf if you want to check it out. I only changed
maxmemory 256mb
maxmemory-policy allkeys-lru
Felix, I tried the fix you suggested. but I am still getting the same error. The error occur when loading a preview of a +300mb PDF document. I moved the large documents to a separate folder to prevent loading the preview.
Should I upgrade the server or is it a configuration issue?
I am monitoring the server via Netdata.
Can you guys help me out
I appreciate your support.
Regards,
Nasser