Am March 23, 2020 8:16:47 AM UTC schrieb Per Jessen
I have deleted database 'webforums', no need for the time being.
Ok. Just in case: I excluded this database from monitoring now... ;-)
Both tools recommended to increase the "InnoDB buffer pool size". I cross checked this with an SQL statement stolen from stackexchange[1]: => result of all tools: Recommended_InnoDB_Buffer_Pool_Size = 32G
I wonder how much of that was caused by my trying to load and upgrade vbulletin. Those tables got a lot of exercise.
Me does not know for 100% either... :-/ But what I can tell from the latest experience: don't try to import huge database dumps, if the cluster is under high pressure already. The WSReplication receive queue[1] seems to be a good indicator about the possibility for uploading dumps here. JFYI: I created a wiki page now, which should explain the whole setup of the cluster. Feel free to enhance it with your findings - or ask back if something is not clear. Regards, Lars -- [1]: https://monitor.opensuse.org/icinga/cgi-bin/status.cgi?search_string=Wsrep+recv&style=detail&servicestatustypes=31 [2]: https://progress.opensuse.org/projects/opensuse-admin-wiki/wiki/Galera_Clust... -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org