Menampilkan postingan dari November, 2021
Sebenernya linux sudah menyediakan crontab buat job scheduler, tapi crontab maksimal atau paling kecil hanya 1 menit, kalo kebutuhannya dibawah 1 menit gimana ? Bikin script bash manual solusinya. Contoh mau bikin script cancel query locking tiap 5 …
Commandline server linux (centos, redhat, ubuntu, freebsd) mysql -e "show full processlist;" -ss | awk '{print "KILL "$1";"}'| mysql note : this action can impact to session replication, suggest to manual query ex…
Show host from os disk -> ls /sys/class/scsi_host/ host0 host1 host2 Scan for each host -> echo "- - -" > /sys/class/scsi_host/host0/scan -> echo "- - -" > /sys/class/scsi_host/host1/scan -> echo "- - -&…
