From c163108c0c0c7b7a4f05da411e98ac0f503e31e0 Mon Sep 17 00:00:00 2001 From: "Suren A. Chilingaryan" Date: Fri, 23 Mar 2018 06:51:23 +0100 Subject: Fix critical bug in docker provisioner, improve mysql performance, provision system users/groups to enable NFS group mapping, various minor fixes --- docs/troubleshooting.txt | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'docs/troubleshooting.txt') diff --git a/docs/troubleshooting.txt b/docs/troubleshooting.txt index ef3c206..ae43c52 100644 --- a/docs/troubleshooting.txt +++ b/docs/troubleshooting.txt @@ -244,6 +244,17 @@ Storage or again we can compare lvm volumes which are used by Gluster bricks and which are not. The later ones should be cleaned up. Again there is the script. +MySQL +===== + - MySQL may stop replicating from the master. There is some kind of deadlock in multi-threaded SLAVE SQL. + This can be seen by exexuting (which should show a lot of slave threads waiting on coordinator to provide + load). + SHOW PROCESSLIST; + The remedy is to restart slave MySQL with 'slave_parallel_workers=0', give it a time to go, and then + restart back in the standard multithreading mode. + + + Performance =========== - To find if OpenShift restricts the usage of system resources, we can 'rsh' to container and check -- cgit v1.2.3