SHELL：引用参数会遇到的问题（TIPs）
其实，本文是一个TIPS。
当SHELL通过【$1 / $2 / $3 …】这种方式传递参数的时候你可能会遇到这样的问题：
当参数个数达到两位数，比方说：【$10】
这时候，你直接使用：
|
1 |
variable1=$10 |
你是拿不到第十个参数[……]
SHELL类别订阅
SHELL：将UltraEdit编辑的Excel数据，转化成MySQL的批量执行脚本
直接看脚本吧：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
# convert data # 说明： # 使用该脚本前，你准备的数据是通过UltraEdit的列编辑模式编辑的Excel的数据 # variable # 要操作的目标 data_target=$1 # function display_mission(){ echo "转换任务详情" echo "=====================" echo "操作的对象：$data_target" # 本脚本的场景一般都是文本文件 echo "-------" echo "对象类型" file $data_target echo "-------" echo "对象大小" du -sh $data_target echo "-------" echo "对象行数" cat $data_target | wc -l # end echo "" } # do # display # 显示当前操作详情 display_mission # 每行末尾增加符号【"】 echo "每行尾部追加符号：[\"]" sed -i 's/$/\"/g' $data_target # 去掉所有空格 echo "去掉所有空格" sed -i 's/ //g' $data_target # 增加分割双引号的空格 echo "增加区别调用脚本的参数的双引号的空格" sed -i 's/\"\"/\" \"/g' $data_target # 增加sh之行时候的空格以及第一个参数的空格 # 在这个场景中：我的引用脚本的文件临时命名为：1.sh echo "增加sh之行时候的空格以及第一个参数的空格" sed -i 's/sh1.sh\"/sh 1.sh \"/g' $data_target # 处理类似【" ""】这种格式的问题 echo "处理类似【\" \"\"】这种格式的问题" sed -i '/" ""/s/" ""/" " "/g' $data_target # done |
原Excel表，可能是类似这样的：
其中，我关心的是：
1. 客户名
2. 邮箱
3. 电话
4. 公司
然后，我通过UltraEdit，列编辑的可能是这样的：
[crayon-5c94[……]
SHELL：MySQL，多表级联插入
场景：
在MySQL中，有两张表：
1. 用户表person
2. 组织表company
用户表中有一个到组织表的外键：id_company
当前，组织表中已经有数据。
我希望在用户表录入数据的时候，根据组织名自动的获取组织的id然后插入用户表。
为了实现这个需求，通过SH[……]
Ansible：自动配置脚本（Shell）
这几天，用SHELL写了一个Ansible的自动配置脚本。
如下：
图：代码发布在我的Git服务器上。
执行后的呈现如下所示：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
[root@ansible-me ~]# ls -ltr /etc/ansible/ total 60 -rw-r--r-- 1 root root 20277 Nov 5 15:49 bak_ansible.cfg-20181105_152354 -rw-r--r-- 1 root root 20277 Nov 5 16:01 ansible.cfg -rw-r--r-- 1 root root 20277 Nov 5 16:01 bak_ansible.cfg-20181105_155716 [root@ansible-me ~]# [root@ansible-me ~]# sh /script/shell/ansible-config-auto.sh Command [Git] is exsist! ------> is Git exsist? About GIT RPM git-1.8.3.1-14.el7_5.x86_64 ------> Version of [PIP] git version 1.8.3.1 Directory is [/git_data] ---> Direcotry is exsist. Directory is [/etc/ansible] ---> Direcotry is exsist. ---> Do Ansible Gitting. Cloning into '/git_data/ansible-20181105_160245'... remote: Enumerating objects: 221, done. remote: Counting objects: 100% (221/221), done. remote: Compressing objects: 100% (179/179), done. remote: Total 372394 (delta 165), reused 42 (delta 42), pack-reused 372173 Receiving objects: 100% (372394/372394), 134.27 MiB | 28.00 KiB/s, done. Resolving deltas: 100% (237302/237302), done. Checking out files: 100% (11565/11565), done. Copy [ansible.cfg]: source code to Special dir. Environment Variables: Ansible ansible.cfg: Modify [root@ansible-me ~]# [root@ansible-me ~]# ls -ltr /etc/ansible/ total 80 -rw-r--r-- 1 root root 20277 Nov 5 15:49 bak_ansible.cfg-20181105_152354 -rw-r--r-- 1 root root 20277 Nov 5 16:01 bak_ansible.cfg-20181105_155716 -rw-r--r-- 1 root root 20277 Nov 5 16:40 bak_ansible.cfg-20181105_160245 -rw-r--r-- 1 root root 20436 Nov 5 16:40 ansible.cfg [root@ansible-me ~]# |
这个自动部署只是完成了初级的配置，… 更多的内容还是需要手动进行配[……]
SHELL：统计CPU使用率大于XX时，CPU/内存/虚拟内存，高耗进程以及资源使用情况
运行时：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 |
[root@bigdata1 shell]# pwd /script/shell [root@bigdata1 shell]# ls -ltr total 12 -rw-r--r-- 1 root root 5012 Jul 16 13:48 calc_resource.sh drwxr-xr-x 2 root root 4096 Jul 16 13:51 2018-07-16_13:48:36 [root@bigdata1 shell]# [root@bigdata1 shell]# sh calc_resource.sh ===================== Memory status ===================== Memory used - [65.00]% Memory free - [34.00]% ===================== Swap status ===================== Swap used - [0]% Swap free - [0]% ===================== CPU status ===================== CPU Usage - Busy - [9.5]% CPU Usage - idle - [90.5]% ===================== If : CPU busy is larger enough Then : do ===================== CPU usage is [BUSY] ----------- Current Path = [/script/shell] Top 10 - CPU = file [/script/shell/2018-07-16_13:53:15/process_top10_cpu_2018-07-16_13:53:15] Top 10 - Memory = file [/script/shell/2018-07-16_13:53:15/process_top10_memory_2018-07-16_13:53:15] Top 10 - Virutal Memory = file [/script/shell/2018-07-16_13:53:15/process_top10_v_mem_2018-07-16_13:53:15] Top status = file[/script/shell/2018-07-16_13:53:15/top_status_2018-07-16_13:53:15] ----> do: TOP ----> do: CPU ----> do: Memory ----> do: Virtual Memory [root@bigdata1 shell]# [root@bigdata1 shell]# ls -ltr total 16 -rw-r--r-- 1 root root 5012 Jul 16 13:48 calc_resource.sh drwxr-xr-x 2 root root 4096 Jul 16 13:51 2018-07-16_13:48:36 drwxr-xr-x 2 root root 4096 Jul 16 13:53 2018-07-16_13:53:15 [root@bigdata1 shell]# [root@bigdata1 shell]# ls -ltr 2018-07-16_13\:48\:36/ total 164 -rw-r--r-- 1 root root 47808 Jul 16 13:48 top_status_2018-07-16_13:48:36 -rw-r--r-- 1 root root 35455 Jul 16 13:48 process_top10_cpu_2018-07-16_13:48:36 -rw-r--r-- 1 root root 37007 Jul 16 13:48 process_top10_memory_2018-07-16_13:48:36 -rw-r--r-- 1 root root 36961 Jul 16 13:48 process_top10_v_mem_2018-07-16_13:48:36 [root@bigdata1 shell]# [root@bigdata1 shell]# ls -ltr 2018-07-16_13\:53\:15/ total 164 -rw-r--r-- 1 root root 47808 Jul 16 13:53 top_status_2018-07-16_13:53:15 -rw-r--r-- 1 root root 35455 Jul 16 13:53 process_top10_cpu_2018-07-16_13:53:15 -rw-r--r-- 1 root root 37007 Jul 16 13:53 process_top10_memory_2018-07-16_13:53:15 -rw-r--r-- 1 root root 36961 Jul 16 13:53 process_top10_v_mem_2018-07-16_13:53:15 [root@bigdata1 shell]# |
脚本代码：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 |
# file_name: calc_cpu_memory_processes # Detect CPU or Memory is high, whitch processes is majorn problem. # variable # Meta info string_date=$(date "+%Y-%m-%d_%H:%M:%S") string_path_current=$(cd $(dirname $0); pwd) #file_script_log=$string_path_current/$string_date/script_log_$string_date file_script_log="" # Memory # free -m memory_used=$(free -m | grep "buffers/cache" | awk '{print $3}') memory_free=$(free -m | grep "buffers/cache" | awk '{print $4}') memory_total=$(free -m | grep "Mem" | awk '{print $2}') f_memory_percent_used=0 f_memory_percent_free=0 # Swap swap_used=$(free -m | grep "Swap" | awk '{print $3}') swap_free=$(free -m | grep "Swap" | awk '{print $4}') swap_total=$(free -m | grep "Swap" | awk '{print $2}') f_swap_percent_used=0 f_swap_percent_free=0 # CPU cpu_processes_list=$(cat /proc/cpuinfo | grep processor) #cpu_percent_topview_idle=$(top -b -d 1 -n 1 | grep "Cpu" | awk '{print $5}' | cut -d'%' -f1) cpu_percent_topview_idle=$(top -b -d 1 -n 4 | grep "Cpu" | tail -n 1 | awk '{print $5}' | cut -d'%' -f1) #cpu_percent_topview_idle=$(top -b -d 1 -n 3 | grep "Cpu" | awk '{sum+=$5} END {print sum/NR}') f_cpu_topview_percent_busy=0 cpu_busy_percent_edge=90 # function func_if_cpu_busy_larger_then_do(){ # init echo "" echo "=====================" echo "If : CPU busy is larger enough" echo "Then : do" echo "-------" echo "Current : busy percent: [$f_cpu_topview_percent_busy]%" echo "Edge : busy percent: [$cpu_busy_percent_edge]%" echo "=====================" echo "" # variable # current #input_cpu_current="$1" #input_cpu_edge="$2" #if [ "$f_cpu_topview_percent_busy" -gt "$cpu_busy_percent_edge" ] if [ `echo "$f_cpu_topview_percent_busy > $cpu_busy_percent_edge" | bc` -eq 1 ] then echo "CPU usage is [BUSY]" echo "-----------" echo "Current Path = [$string_path_current]" # do mkdir mkdir $string_path_current/$string_date # variable file_process_top10_cpu=$string_path_current/$string_date/process_top10_cpu_$string_date file_process_top10_memory=$string_path_current/$string_date/process_top10_memory_$string_date file_process_top10_v_mem=$string_path_current/$string_date/process_top10_v_mem_$string_date file_top_status=$string_path_current/$string_date/top_status_$string_date # display echo "Top 10 - CPU = file [$file_process_top10_cpu]" echo "Top 10 - Memory = file [$file_process_top10_memory]" echo "Top 10 - Virutal Memory = file [$file_process_top10_v_mem]" echo "Top status = file[$file_top_status]" # do # Top status echo "----> do: TOP" echo "Top status" > $file_top_status echo "=========================================" >> $file_top_status top -b -d 1 -n 1 >> $file_top_status # top10 - cpu echo "----> do: CPU" echo "Top10 - CPU" > $file_process_top10_cpu ps auxw|head -1 >> $file_process_top10_cpu echo "=========================================" >> $file_process_top10_cpu ps auxw|sort -rn -k3|head -10 >> $file_process_top10_cpu # top10 - memory echo "----> do: Memory" echo "Top10 - Memory" > $file_process_top10_memory ps auxw|head -1 >> $file_process_top10_memory echo "=========================================" >> $file_process_top10_memory ps auxw|sort -rn -k4|head -10 >> $file_process_top10_memory # top10 - virtual memory echo "----> do: Virtual Memory" echo "Top10 - Virtual Memory" > $file_process_top10_v_mem ps auxw|head -1 >> $file_process_top10_v_mem echo "=========================================" >> $file_process_top10_v_mem ps auxw|sort -rn -k5|head -10 >> $file_process_top10_v_mem fi } func_cpu_percent_single(){ # variable # 需要过滤的【mpstat】的标记 f_input_signal="$1" # 依赖命令：mpstat # 该命令不是每个Linux都有的 # 该函数没有写完，后面补全 } func_cpu_usage(){ # init echo "" echo "=====================" echo "CPU status" echo "=====================" echo "" # 依赖命令：top # Command: # top -b -d 1 -n 1 f_cpu_topview_percent_busy=$(echo "scale=2;100-$cpu_percent_topview_idle" | bc) # display echo "CPU Usage - Busy - [$f_cpu_topview_percent_busy]%" echo "CPU Usage - idle - [$cpu_percent_topview_idle]%" } func_swap_percent_and_display() { # init echo "" echo "=====================" echo "Swap status" echo "=====================" echo "" # calc if [ $swap_total != "0" ] then f_swap_percent_used=$(echo "scale=2;($swap_used/$swap_total)*100" | bc) f_swap_percent_free=$(echo "scale=2;($swap_free/$swap_total)*100" | bc) fi # display echo "Swap used - [$f_swap_percent_used]%" echo "Swap free - [$f_swap_percent_free]%" } func_memory_percent_and_display() { # init echo "" echo "=====================" echo "Memory status" echo "=====================" echo "" # calc if [ $memory_total != "0" ] then f_memory_percent_used=$(echo "scale=2;($memory_used/$memory_total)*100" | bc) f_memory_percent_free=$(echo "scale=2;($memory_free/$memory_total)*100" | bc) fi # display echo "Memory used - [$f_memory_percent_used]%" echo "Memory free - [$f_memory_percent_free]%" } # do # mkdir # do mkdir #mkdir $string_path_current/$string_date # Memory func_memory_percent_and_display # Swap func_swap_percent_and_display # CPU func_cpu_usage # if CPU busy is larger, then func_if_cpu_busy_larger_then_do # done # Finished. |
——————————————
Done。