Nextlcoud: mysql tuning

user0815 · June 25, 2018, 2:22pm

Hello together, first time poster here. I hope I’m in the right forum.

I have installed the nextcloud (13) with snap. But I find it behaves very slow, regarding both bandwith and usability. It takes very long to upload/download small files and using nextcloud with the browser is slow, too. The server as a lot of capacity left (memory and upload bandwith), which is obviousely not used. I did some research on the nextcloud forums, and the result was that tuning the mysql parameters could help.

But I could not find out how to this on snap installation. Is tuning of the mysql parameters (my.cnf) possible? If yes, how?

pachulo · June 25, 2018, 7:02pm

I would say that there is no way right now to do without re-compiling the snap yourself.

I guess that another option would be to do some stuff configurable, like some Apache configs:

github.com

nextcloud/nextcloud-snap/blob/master/src/apache/bin/httpd-wrapper

#!/bin/sh

# shellcheck source=src/https/utilities/https-utilities
. "$SNAP/utilities/https-utilities"
# shellcheck source=src/apache/utilities/apache-utilities
. "$SNAP/utilities/apache-utilities"
# shellcheck source=src/php/utilities/php-utilities
. "$SNAP/utilities/php-utilities"
# shellcheck source=src/hooks/utilities/configuration-utilities
. "$SNAP/utilities/configuration-utilities"

params=""
if certificates_are_active; then
	echo "Certificates have been activated: using HTTPS only"
	params="$params -DEnableHTTPS"

	# Enable HSTS if possible
	if should_enable_hsts; then
		echo "Certificates look to be in order: enabling HSTS"
		params="$params -DEnableHSTS"

This file has been truncated. show original

But @kyrofa knows for sure.

By the way, do you have any idea on what could be tuned?

kyrofa · June 25, 2018, 7:05pm

This conversation is probably better had over here:

Please log an issue, I’m curious what tuning was recommended.