|
Pages: 1 ... 3 4 [5] 6 7 ... 10
41
« Last post by golfreeze on กันยายน 04, 2022, 10:34:02 AM »
=== delete all *.txt command with xargs faster than "-exec rm {} \;" find . -type f -name "*.txt" | xargs rm =="-exec rm" more slowly than "xargs rm" find . -type f -name "*.txt" -exec rm {} \;
42
« Last post by golfreeze on กันยายน 04, 2022, 10:30:43 AM »
== create 10 files with extension .txt with xargs seq 10 | xargs -I {} touch {}.txt
43
« Last post by golfreeze on กันยายน 04, 2022, 10:25:30 AM »
=== text3 ==== store manager total_sales Woodridge,Australia Jon Stephens 33726.77 Lethbridge,Canada Mike Hillyer 33679.79 Bridge,Canada Mike Hillyer 43679.89 Sisaket,Thailand thong 562.22 Pathumthani,Thailand White 992.42 Saimai,Bangkok Packetlove 8229.4
=== text4 === store:manager:total_sales Woodridge,Australia:Stephens:33726.77 Lethbridge,Canada:Hillyer:33679.79 Bridge,Canada:Mike:43679.89 Sisaket,Thailand:thong:562.22 Pathumthani,Thailand:White:992.42 Saimai,Bangkok:Packetlove:8229.4
44
« Last post by golfreeze on กันยายน 04, 2022, 10:24:46 AM »
##show second column contain word "account" awk '$2 ~ account {print} ' filenamel
##show first column start with "e" in file check.sh awk '$1 ~ /^e/ {print } ' check.sh
##show first column start with not contain "e" in file check.sh awk '$1 !~ /^e/ {print } ' check.sh
##search and grep "account" from file awk '/account/ {print } ' check.sh awk '/^account/ {print }' check.sh
##if > < >= <= && || finding $5 more than 2000 and less than 2500 then print awk '$5 > 2000 && $5 <2500 {print $0}' check.sh
##if > < >= <= && || finding $5 more than 2000 or $5 not contain "sal" in line then print awk '$5 > 2000 || $5 !~ /sal/ {print $0}' check.sh
##if need change first line with specific "Start processing" and grep "account" awk 'BEGIN {print "Start processing"} {print $0}' check.sh awk 'BEGIN {print "Start processing"} /account/ {print $0}' check.sh
###if need add BEGIN and END of awk and grep "account" awk 'BEGIN {print "Start processing"} /account/ {print $0} END {print "End processed"}' check.sh
##if need count NR=Number record , NF=Number of field awk '{print NR,$0,NF} END {print "End processed"}' check.sh
##if need print LAST Field $NF awk '{print NR,$0,$NF,FILENAME} ' check.sh
##if need only line4 until line8 in file to show awk 'NR==4,NR==8 {print $0}' check.sh awk 'NR==4,NR==8 {print $0}' check.sh | awk '$3 ~ /username/'
##if substitute space with some character use OFS=output field substitute => if see space " " then replace with "@@" awk 'NR==4,NR==8 {print $0}' check.sh | awk 'BEGIN{OFS="@@"} {print $2,$3}' awk 'BEGIN {print "Start processing"} {print $0}' text3 | awk 'BEGIN{OFS="@"} {print $1,$2".com"}'
##if substitute space with some character use FS=field substitute => if see ":" then replace with space " " awk 'BEGIN{FS=":"} {print $2,$3}' text4
##if substitute space with some character use FS=field substitute => if see ":" then replace with "@@" awk 'BEGIN{FS=":";OFS="@@"} {print $2,$3}' text4
##if substitute last character in file use ORS=":" with : awk 'BEGIN {print "Start processing"} {print $0}' text3 | awk 'BEGIN{OFS="@";ORS=":"} {print $1,$2".com"}' output=> Start@processing.com:store@manager.com:Woodridge,Australia@Jon.com:Lethbridge,Canada@Mike.com:Bridge, Canada@Mike.com:Sisaket,Thailand@Liamthong.com:Pathumthani,Thailand@White.com:Saimai,Bangkok@Packetlove.com:
###if need awk run if condition or run condition on script file awk '{if ($3 > 2000) print $0 }' text3 output=> store manager total_sales Woodridge,Australia Jon Stephens 33726.77 Lethbridge,Canada Mike Hillyer 33679.79 Bridge,Canada Mike Hillyer 43679.89 Saimai,Bangkok Packetlove 8229.4
awk '{if ($3 > 2000) print $0; else print "Low" }' text3 output=> store manager total_sales Woodridge,Australia Jon Stephens 33726.77 Lethbridge,Canada Mike Hillyer 33679.79 Bridge,Canada Mike Hillyer 43679.89 Low Low Saimai,Bangkok Packetlove 8229.4
###if need awk run if condition or run condition on script file awk -f script text4
###toupper=change small character to BIG capital leeter on first column , length=count length of character on $3 awk '{print toupper($1),length($3)} {print $0}' text3
45
« Last post by golfreeze on สิงหาคม 20, 2022, 03:01:02 AM »
===== DB Task ===== run import script in sql testdb=> \copy (select * from param_change_request where id in (161, 162)) TO '/home/testdb/backhour.csv' CSV HEADER;
แล้วสามารถไปดูที่ไฟล์ backhour.csv ได้ครับ
46
« Last post by golfreeze on สิงหาคม 20, 2022, 02:56:45 AM »
ถ้าเรามีการเตรียม สคิปในไฟล์ check_query_alter_update.sql เพื่อทำรายการใน db=testdb เราสามารถรันผ่าน command psql ได้ดังนี้
postgres=> \c testdb testdb=> \i 19aug2022_operation/Script/check_query_alter_update.sql ALTER TABLE
เท่านี้ครับผม
47
« Last post by golfreeze on เมษายน 15, 2022, 01:10:52 PM »
===for centos , debian 11 cd /usr/local/directadmin/scripts/custom wget https://raw.githubusercontent.com/poralix/directadmin-utils/master/php/php-extension.sh -O php-extension.sh chmod 750 php-extension.sh ./php-extension.sh install redis ==for freebsd cd /usr/local/directadmin/scripts/custom wget https://raw.githubusercontent.com/poralix/directadmin-utils/master/php/php-extension.sh -O php-extension.sh chmod 750 php-extension.sh mkdir -p /usr/local/src และแก้ไข #!/bin/bash -> #!/usr/local/bin/bash ใน php-extension.sh แล้วรัน ./php-extension.sh install redis
48
« Last post by golfreeze on เมษายน 14, 2022, 11:15:06 AM »
byobu command ctrl+a+c = new window ctrl+a+o = swap window ctrl+a+% = split vertical view
49
« Last post by golfreeze on เมษายน 12, 2022, 07:42:44 AM »
csf lfd stop alert email for nrpe on debian os directadmin กรณีมีอีเมลส่งมาแจ้ง เยอะ alert สามารถแก้ไขเพื่อไม่ให้ส่ง email จาก service csf ที่เป้นหัวข้อ lfd ได้โดย If debian enable “csf” need allow on csf.conf “TCP_in” and “TCP_out” and Disable lfd for resource usage Subject: lfd on packetlove.com: Excessive resource usage: nagios (494190 (Parent PID:494190)) From: < root@packetlove.com> Message-Id: < E1ne3x7-002N0R-7t@packetlove.com> Date: Tue, 12 Apr 2022 07:00:13 +0700 Time: Tue Apr 12 07:00:13 2022 +0700 Account: nagios Resource: Process Time Exceeded: 75567 > 1800 (seconds) Executable: /usr/local/nagios/bin/nrpe Command Line: /usr/local/nagios/bin/nrpe -c /usr/local/nagios/etc/nrpe.cfg -f PID: 494190 (Parent PID:494190) Killed: No --1649721613-eximdsn-849789542-- ==แก้ไขเพื่อไม่ให้ส่ง email ได้โดย vi /etc/csf/csf.pignore user:nagios exe:/usr/local/nagios/bin/nrpe cmd:/usr/local/nagios/bin/nrpe -c /usr/local/nagios/etc/nrpe.cfg -f ==reload csf rule 1 รอบ csf -r
50
« Last post by golfreeze on เมษายน 03, 2022, 06:23:36 PM »
ในกรณี disk เป็น volume group เราสามารถสั่ง check disk ระบุ partition ได้เลยครับ command[check_disk]=/usr/local/nagios/libexec/check_disk -w 6% -c 3% -p /
Pages: 1 ... 3 4 [5] 6 7 ... 10
|
|
|