Teguh Triharto Learning Center: .::: Shell Script to Get CPU Memory Usage (%), Swap (%) & Local Check, all_check GTID Mirroring,IP & Hostname,uptime MariaDB in Centos 9 Redhat 9 Rocky Linux 9 :::.

1. local check

Mem_Used_mb=$(free -m | awk 'NR==2{printf "%.f", $3 }')
Mem_Total_mb=$(free -m | awk 'NR==2{printf "%.f", $2 }')

Mem_Used_kb=$(free -m | awk 'NR==2{printf "%.f", $3*1024 }')
Mem_Total_kb=$(free -m | awk 'NR==2{printf "%.f", $2*1024 }')

Mem_Used_gb=$(free -m | awk 'NR==2{printf "%.f", $3/1024 }')
Mem_Total_gb=$(free -m | awk 'NR==2{printf "%.f", $2/1024 }')

Mem_Used_percent=$(free -m | awk 'NR==2{printf "%.2f%%\t\t", $3*100/$2 }')

Mem_swap_used_mb=$(free -m | awk 'NR==3{printf "%.f", $3 }')
Mem_swap_total_mb=$(free -m | awk 'NR==3{printf "%.f", $2 }')

Mem_swap_used_kb=$(free -m | awk 'NR==3{printf "%.f", $3*1024 }')
Mem_swap_total_kb=$(free -m | awk 'NR==3{printf "%.f", $2*1024 }')

Mem_swap_used_gb=$(free -m | awk 'NR==3{printf "%.f", $3/1024 }')
Mem_swap_total_gb=$(free -m | awk 'NR==3{printf "%.f", $2/1024 }')

Mem_swap_percent=$(free -m | awk 'NR==3{printf "%.2f%%\t\t", $3*100/$2 }')

Server=$(hostname)

#!/bin/bash

#!/bin/bash
# Get Hostname
#server=$(hostname)
# Get the IP address using ifconfig, excluding the loopback interface
ip_address=$(ifconfig | awk '/inet / && $2 !~ /^127\./ {gsub("addr:","",$2); print $2}')
ip_address2=$(ip a | awk '/inet / && $2 !~ /^127\./ {gsub("addr:","",$2); print $2}')
# Print the IP address

# Menampilkan informasi dalam KB dan persentase
echo ""
echo ".::: Result checking on server with hostname << $Server >> & << $ip_address2 >> :::."
echo ""
echo "Hostname Server        : $Server"
echo "IP Address(ifconfig)   : $ip_address"
echo "IP Address(ip a)       : $ip_address2"
echo "CPU Usage (%)          : $CPU"
echo "Memory Usage (%)       : $Mem_Used_percent"
echo "Swap Usage(%)          : $Mem_swap_percent"
echo "Used Memory            : $Mem_Used_gb in GB, $Mem_Used_mb in MB, $Mem_Used_kb in KB"
echo "Total Memory           : $Mem_Total_gb in GB, $Mem_Total_mb in MB,$Mem_Total_kb in KB"
echo "Used Swap              : $Mem_swap_used_gb in GB, $Mem_swap_used_mb in MB, $Mem_swap_used_kb in KB"
echo "Total Swap             : $Mem_swap_total_gb in GB, $Mem_swap_total_mb in MB,$Mem_swap_total_kb in KB"
echo ""
echo "disk info"
df -h
echo ""
echo "Copyright by           : Teguh Triharto"
echo "Website                : https://www.linkedin.com/in/teguhth"
echo ""

grep -E '^(VERSION|NAME)=' /etc/os-release

##[root@teguhth data]#

[root@teguhth-all cekmem]# cat local_check.sh

#!/bin/bash
date
#CPU=$(top -bn1 | grep load | awk '{printf "%.2f%%\t\t\n", $(NF-2)}')
CPU=$(top -bn1 | grep "Cpu(s)" | awk '{print 100 - $8"%"}')

Mem_Used_mb=$(free -m | awk 'NR==2{printf "%.f", $3 }')
Mem_Total_mb=$(free -m | awk 'NR==2{printf "%.f", $2 }')

Mem_Used_kb=$(free -m | awk 'NR==2{printf "%.f", $3*1024 }')
Mem_Total_kb=$(free -m | awk 'NR==2{printf "%.f", $2*1024 }')

Mem_Used_gb=$(free -m | awk 'NR==2{printf "%.f", $3/1024 }')
Mem_Total_gb=$(free -m | awk 'NR==2{printf "%.f", $2/1024 }')

Mem_Used_percent=$(free -m | awk 'NR==2{printf "%.2f%%\t\t", $3*100/$2 }')

Mem_swap_used_mb=$(free -m | awk 'NR==3{printf "%.f", $3 }')
Mem_swap_total_mb=$(free -m | awk 'NR==3{printf "%.f", $2 }')

Mem_swap_used_kb=$(free -m | awk 'NR==3{printf "%.f", $3*1024 }')
Mem_swap_total_kb=$(free -m | awk 'NR==3{printf "%.f", $2*1024 }')

Mem_swap_used_gb=$(free -m | awk 'NR==3{printf "%.f", $3/1024 }')
Mem_swap_total_gb=$(free -m | awk 'NR==3{printf "%.f", $2/1024 }')

Mem_swap_percent=$(free -m | awk 'NR==3{printf "%.2f%%\t\t", $3*100/$2 }')

# Total memory server for maria
Mem_mTotal_mb=$(free -m | awk 'NR==2{print $2}')
Mem_mTotal_gb=$(free -m | awk 'NR==2{printf "%.2f", $2/1024 }')

# Ambil memory MariaDB dalam MB (dibulatkan) maria
MEMORY_MARIA_MB=$(ps -C mariadbd -o rss= | awk '{sum+=$1} END {printf "%.0f", sum/1024}')

# Hitung persentase memory for maria
MEMORY_MARIA_USAGE=$(awk -v used="$MEMORY_MARIA_MB" -v total="$Mem_mTotal_mb" 'BEGIN {printf "%.2f", (used/total)*100}')

Server=$(hostname)

#!/bin/bash

#!/bin/bash
# Get Hostname
#server=$(hostname)
# Get the IP address using ifconfig, excluding the loopback interface
ip_address=$(ifconfig | awk '/inet / && $2 !~ /^127\./ {gsub("addr:","",$2); print $2}')
ip_address2=$(ip a | awk '/inet / && $2 !~ /^127\./ {gsub("addr:","",$2); print $2}')
# Print the IP address

# Menampilkan informasi dalam KB dan persentase
echo ""
echo ".::: Result checking on server with hostname << $Server >> & << $ip_address2 >> :::."
echo ""
echo "Hostname Server : $Server"
echo "IP Address(ifconfig) : $ip_address"
echo "IP Address(ip a) : $ip_address2"
echo "CPU Usage(%) : $CPU"
echo "Memory Usage(%) Maria : ${MEMORY_MARIA_USAGE}%"
echo "Memory Usage (%) Total : $Mem_Used_percent"
echo "Swap Usage(%) : $Mem_swap_percent"
echo "Memory Usage Maria : ${MEMORY_MARIA_MB} MB"
echo "Used Memory : $Mem_Used_gb in GB, $Mem_Used_mb in MB, $Mem_Used_kb in KB"
echo "Total Memory : $Mem_Total_gb in GB, $Mem_Total_mb in MB,$Mem_Total_kb in KB"
echo "Used Swap : $Mem_swap_used_gb in GB, $Mem_swap_used_mb in MB, $Mem_swap_used_kb in KB"
echo "Total Swap : $Mem_swap_total_gb in GB, $Mem_swap_total_mb in MB,$Mem_swap_total_kb in KB"
echo ""
systemctl status mariadb | grep Active
echo
echo "disk info"
df -h
echo ""
echo "Copyright by : Teguh Triharto"
echo "Website : https://www.linkedin.com/in/teguhth"
echo ""

grep -E '^(VERSION|NAME)=' /etc/os-release

[root@teguhth-all cekmem]#

simpel again

##[root@teguhth data]# cat local_check.sh
# cat check_cpu_mem_usage.sh
#!/bin/bash
date
#CPU=$(top -bn1 | grep load | awk '{printf "%.2f%%\t\t\n", $(NF-2)}')
CPU=$(top -bn1 | grep "Cpu(s)" | awk '{print 100 - $8"%"}')

Mem_Used_mb=$(free -m | awk 'NR==2{printf "%.f", $3 }')
Mem_Total_mb=$(free -m | awk 'NR==2{printf "%.f", $2 }')

Mem_Used_kb=$(free -m | awk 'NR==2{printf "%.f", $3*1024 }')
Mem_Total_kb=$(free -m | awk 'NR==2{printf "%.f", $2*1024 }')

Mem_Used_gb=$(free -m | awk 'NR==2{printf "%.f", $3/1024 }')
Mem_Total_gb=$(free -m | awk 'NR==2{printf "%.f", $2/1024 }')

Mem_Used_percent=$(free -m | awk 'NR==2{printf "%.2f%%\t\t", $3*100/$2 }')

Mem_swap_used_mb=$(free -m | awk 'NR==3{printf "%.f", $3 }')
Mem_swap_total_mb=$(free -m | awk 'NR==3{printf "%.f", $2 }')

Mem_swap_used_kb=$(free -m | awk 'NR==3{printf "%.f", $3*1024 }')
Mem_swap_total_kb=$(free -m | awk 'NR==3{printf "%.f", $2*1024 }')

Mem_swap_used_gb=$(free -m | awk 'NR==3{printf "%.f", $3/1024 }')
Mem_swap_total_gb=$(free -m | awk 'NR==3{printf "%.f", $2/1024 }')

Mem_swap_percent=$(free -m | awk 'NR==3{printf "%.2f%%\t\t", $3*100/$2 }')

# Total memory server for maria
Mem_mTotal_mb=$(free -m | awk 'NR==2{print $2}')
Mem_mTotal_gb=$(free -m | awk 'NR==2{printf "%.2f", $2/1024 }')

# Ambil memory MariaDB dalam MB (dibulatkan) maria
MEMORY_MARIA_MB=$(ps -C mariadbd -o rss= | awk '{sum+=$1} END {printf "%.0f", sum/1024}')

# Hitung persentase memory for maria
MEMORY_MARIA_USAGE=$(awk -v used="$MEMORY_MARIA_MB" -v total="$Mem_mTotal_mb" 'BEGIN {printf "%.2f", (used/total)*100}')

Server=$(hostname)

#!/bin/bash

#!/bin/bash
# Get Hostname
#server=$(hostname)
# Get the IP address using ifconfig, excluding the loopback interface
#ip_address=$(ifconfig | awk '/inet / && $2 !~ /^127\./ {gsub("addr:","",$2); print $2}')

ip_address=$(hostname -I | awk '{print $1}' | sed "s/ //g")
ip_address2=$(ip a | awk '/inet / && $2 !~ /^127\./ {gsub("addr:","",$2); print $2}')
# Print the IP address

# Menampilkan informasi dalam KB dan persentase
echo ""
echo ".::: Result checking on server with hostname << $Server >> & << $ip_address >> :::."
echo ""
echo "Hostname Server : $Server"
echo "IP Address(ifconfig) : $ip_address"
echo "CPU Usage(%) : $CPU"
echo "Memory Usage(%) Maria : ${MEMORY_MARIA_USAGE}% << MarinaDB >>"
echo "Memory Usage(%) Total : $Mem_Used_percent"
echo "Swap Usage(%) : $Mem_swap_percent"
echo "Memory Usage Maria : ${MEMORY_MARIA_MB} MB"
echo "Used Memory : $Mem_Used_gb in GB, $Mem_Used_mb in MB, $Mem_Used_kb in KB"
echo "Total Memory : $Mem_Total_gb in GB, $Mem_Total_mb in MB,$Mem_Total_kb in KB"
echo "Used Swap : $Mem_swap_used_gb in GB, $Mem_swap_used_mb in MB, $Mem_swap_used_kb in KB"
echo "Total Swap : $Mem_swap_total_gb in GB, $Mem_swap_total_mb in MB,$Mem_swap_total_kb in KB"
echo ""
systemctl status mariadb | grep Active
echo
echo "disk info"
df -h
echo ""
echo "Copyright by : Teguh Triharto"
echo "Website : https://www.linkedin.com/in/teguhth"
echo ""

grep -E '^(VERSION|NAME)=' /etc/os-release

##[root@teguhth data]#

2. all check include

#!/bin/bash
date
#CPU=$(top -bn1 | grep load | awk '{printf "%.2f%%\t\t\n", $(NF-2)}')
CPU=$(top -bn1 | grep "Cpu(s)" | awk '{print 100 - $8"%"}')
Mem_Used_mb=$(free -m | awk 'NR==2{printf "%.f", $3 }')
Mem_Total_mb=$(free -m | awk 'NR==2{printf "%.f", $2 }')

Mem_Used_kb=$(free -m | awk 'NR==2{printf "%.f", $3*1024 }')
Mem_Total_kb=$(free -m | awk 'NR==2{printf "%.f", $2*1024 }')

Mem_Used_gb=$(free -m | awk 'NR==2{printf "%.f", $3/1024 }')
Mem_Total_gb=$(free -m | awk 'NR==2{printf "%.f", $2/1024 }')

Mem_Used_percent=$(free -m | awk 'NR==2{printf "%.2f%%\t\t", $3*100/$2 }')

Mem_swap_used_mb=$(free -m | awk 'NR==3{printf "%.f", $2 }')
Mem_swap_total_mb=$(free -m | awk 'NR==3{printf "%.f", $3 }')

Mem_swap_used_kb=$(free -m | awk 'NR==3{printf "%.f", $2*1024 }')
Mem_swap_total_kb=$(free -m | awk 'NR==3{printf "%.f", $3*1024 }')

Mem_swap_used_gb=$(free -m | awk 'NR==3{printf "%.f", $2/1024 }')
Mem_swap_total_gb=$(free -m | awk 'NR==3{printf "%.f", $3/1024 }')

Mem_swap_percent=$(free -m | awk 'NR==3{printf "%.2f%%\t\t", $3*100/$2 }')

Server=$(hostname)

#!/bin/bash
# Get Hostname
Server=$(hostname)
# Get the IP address using ifconfig, excluding the loopback interface
ip_address=$(ifconfig | awk '/inet / && $2 !~ /^127\./ {gsub("addr:","",$2); print $2}')
ip_address2=$(ip a | awk '/inet / && $2 !~ /^127\./ {gsub("addr:","",$2); print $2}')
# Print the IP address

# Menampilkan informasi dalam KB dan persentase

# Menampilkan informasi dalam KB dan persentase
echo ""
echo ".::: Result checking on server with hostname << $Server >> & << $ip_address2 >> :::."
echo ""
echo "Hostname Server        : $Server"
echo "IP Address(ifconfig)   : $ip_address"
echo "IP Address(ip a)       : $ip_address2"
echo "CPU Usage (%)          : $CPU"
echo "Memory Usage (%)       : $Mem_Used_percent"
echo "Swap Usage(%)          : $Mem_swap_percent"
echo "Used Memory            : $Mem_Used_gb in GB, $Mem_Used_mb in MB, $Mem_Used_kb in KB"
echo "Total Memory           : $Mem_Total_gb in GB, $Mem_Total_mb in MB,$Mem_Total_kb in KB"
echo "Total Swap             : $Mem_swap_total_gb in GB, $Mem_swap_total_mb in MB,$Mem_swap_total_kb in KB"
echo "Used Swap              : $Mem_swap_used_gb in GB, $Mem_swap_used_mb in MB, $Mem_swap_used_kb in KB"
echo ""
echo "Check GTID Replication"

COUNTER=0

while [ $COUNTER -lt 2 ]; do
    let COUNTER=COUNTER+1

        TGL=$(date +%Y"-"%m"-"%d" "%H":"%M":"%S" ")
        CEK=`mysql -uroot -proot -e"show slave status \G;" | grep Seconds_Behind_Master `
        RESULT=$(echo $CEK | awk '{print $2}')
        if [[ $RESULT != "0" ]] ; then
                echo $TGL" --> $CEK " >> cek_rep.log
                #echo $TGL" --> Seconds_Behind_Master : "$CEK >> cek_rep.log
        fi

        echo "no: $COUNTER : $CEK "
sleep 1 #slepp or wait
done

echo ""
echo "Resume Processlist: "
mysql -uroot -proot -e "show status where variable_name like 'threads%'";

echo ""
echo "Uptime MariaDB"
mysql -uroot -proot -e "select @@hostname,@@version,now() - interval variable_value second as 'MySQL started on',TIME_FORMAT(SEC_TO_TIME(VARIABLE_VALUE ),'%Hh %im') as Uptime from information_schema.global_status where variable_name='Uptime';";

echo ""
echo "disk info df -h"
df -h

echo ""
echo "maxscale info"
maxadmin list servers

echo ""
echo "tail -10 mysql log"
tail -10 /var/lib/mysql/mysql_error.log

echo ""
echo "Maxscale log"
tail -10 /var/log/maxscale/maxscale.log

Teguh Triharto Learning Center

Blog List

Tuesday, January 23, 2024

.::: Shell Script to Get CPU Memory Usage (%), Swap (%) & Local Check, all_check GTID Mirroring,IP & Hostname,uptime MariaDB in Centos 9 Redhat 9 Rocky Linux 9 :::.

No comments:

Post a Comment

Popular Posts