Which processes are swapping?!

Recently one machine was swapping. No free space on the swap partition. Hmmm… Since this machine was used as a database server, obviously I suspected mysql. But why to guess when I could knew¬†for sure which process was¬†swapping… [codesyntax lang=”bash”] for file in /proc/*/status ; do awk ‘/VmSwap|Name/{printf $2 ” ” $3}END{ print “”}’ $file; … Continue reading Which processes are swapping?!

Topology refactoring using classic MySQL replication commands – version 2

This one in not very different than Topology refactoring using classic MySQL replication commands – version 1, actually it’s the other way around. Context: Initial state: dbfoo1(M) – dbfoo2(S) \ dbfoo3(S) Desired state: dbfoo1(M) – dbfoo2(MS) – dbrfoo3(S) Let’s get it done: stop slave on dbfoo3 MariaDB [(none)]> stop slave; check the “freezing point” on … Continue reading Topology refactoring using classic MySQL replication commands – version 2