close Warning: Can't synchronize with repository "keplertools" (/srv/svn/keplertools does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 3 years ago

Last modified 3 years ago

#5055 accepted Verbesserung

Mysql-Tuning

Reported by: Rüdiger Kupper Owned by: Rüdiger Kupper
Priority: bei Gelegenheit Milestone: Nextcloud: Optimierungen
Component: Webdienst: Kepler-Cloud Severity: beeinträchtigt keinen Unterricht
Keywords: Cc:

Description

Es gibt Skripte, die dabei helfen, die Parameter eines mysql-Servers zu tunen.

von ​https://help.nextcloud.com/t/how-to-shrink-oc-filecache-440gb-vs-360gb-files-hosted/107025/11:

There are a tuning scripts for database server to adjust the cache settings for best performance. tuning-primer.sh and mysqltuner.pl. If your Nextcloud setup is running on a small hardware, a way could be to make a database dump directly to a remote system over network (400 GB will take some time) if you then have a more suited system to carry out the cleaning up…}}}

Change History (2)

comment:1 by Rüdiger Kupper, 3 years ago

Z.B. ​https://github.com/major/MySQLTuner-perl
Mal drüberlaufen lassen!

comment:2 by Rüdiger Kupper, 3 years ago

Status: new → accepted
Note: See TracTickets for help on using tickets.