代元培

linux安装mysql过程

CentOS7使用firewall-cmd操作防火墙与端口

Linux离线安装MySQL8.0.21教程

# 统计第4列为0112并且第5列为00或者03的行数awk -F '|' '{if(($4=="0112")&&($5=="00"||$5=="03")) print $1}' epcc0303_20210423.txt|wc -l# 去重展示第一列的时间awk -F '|' '{print $1}' epcc0303_20210422.txt|sort|uniq

#!/bin/bash. ~/.bashrcdateEnd=`date +"%Y%m%d"`dateBegin=`date +%Y%m%d -d"-30 day $dateEnd"`if [ $# == 1 ]; then if [ ! -n "$(echo $1| sed -n "/^[0-9]\+$/p")" ]; then echo "FATAL: The parameter is not a number." exit -1 fi i.

20000000000069|950615951|2019-04|3.7020000000000069|950615951|2019-05|1.3020000000000069|950615951|2019-06|1.3020000000000069|950615951|2019-08|1.5020000000000069|950615951|2019-09|1.4020000000000069|950615951|2019-10|1.6020000000000069|950615951|20.

#!/bin/bash# alias sp='sh /home/work/.sp-gp' # 查gp库. ~/.bashrcre="[[:digit:]]+"fields="F_sp_id, F_sp_user_id, F_sp_company, F_sp_display_name, F_create_time"if [[ $1 =~ $re ]]; then sql="SELECT $fields FROM fn.t_scenario_sp_map WHERE F_sp_id =.

# 获取当前时间time=`date +"%Y-%m-%d %H:%M:%S"`# 获取一分钟之前time=`date -d "1 minute ago" +"%Y-%m-%d %H:%M:%S"`# 获取一小时之前time=`date -d "1 hour ago" +"%Y-%m-%d %H:%M:%S"`# 获取一天前时间time=`date -d "1 day ago" +"%Y-%m-%d %H:%M:%S"`...

#!/bin/bash# load_dypserver.shname='dypserver'SV="./supervise.$name"unalias pidof &>/dev/nullexec 0</dev/null#ulimit -c unlimitedcd `dirname $0`#LIBRDKAFKA_DIR=`pwd`/lib#export LD_LIBRARY_PATH=$LIBRDKAFKA_DIR:$LD_LIBRARY_PATHif [ ! -.

if [ `grep -c "*.*.*.*" $CURRENT_DIR/conf/ubclient.conf` -eq '0' ];thenecho -e "\n" >> $CURRENT_DIR/conf/ubclient.confcat>>$CURRENT_DIR/conf/ubclient.conf<<EOF[.UbClient][..@Service]Name : testConnectAll : 0DefaultConnectTimeOut.

STYLE='s/\t/","/g;s/^/"/;s/$/"/;s/\n//g'DYPSTYLE='s/\t/","/g;s/\n//g'alias gp_rd='psql -h *.*.*.* -p 5432 -d dyp_gp_pay -U dyp_data_rd'alias gp_rd_c='gp_rd -t -A -F "," |sed "$STYLE"'alias gp_rd_d='gp_rd -t -A -F "|" |sed "$DYPSTYLE"'alias gp_rd_h='g.

current=`date "+%Y-%m-%d %H:%M:%S"` timeStamp=`date -d "$current" +%s`echo $timeStamp# 将current转换为时间戳，精确到毫秒currentTimeStamp=$((timeStamp*1000+`date "+%N"`/1000000)) echo $currentTimeStamp

自动换行是每行超过n个字的时候，vim自动加上换行符用 :set textwidth=70来设置n 自动折行是把长的一行用多行显示，不在文件里加换行符用 :set wrap 设置自动折行 :set nowrap 设置不自动折行...

# 交集sort a.txt | uniq > aa.txtsort b.txt | uniq > bb.txtcat aa.txt bb.txt | sort | uniq -d# 并集cat a.txt b.txt | sort | uniq# 差集cat aa.txt bb.txt bb.txt | sort | uniq -u# 取差集sort a.txt b.txt b.txt|uniq -u > diff.txt

awk -F' ' '{print $1}' uids | xargs | tr ' ' ',' >> uids_row

cat a.txt | awk '{sum+=$1} END {print "Sum = ", sum}'

1、查看系统是否有僵尸进程使用Top命令查找，当zombie前的数量不为0时，即系统内存在相应数量的僵尸进程。2、定位僵尸进程使用命令ps -A -ostat,ppid,pid,cmd |grep -e '^[Zz]'定位僵尸进程以及该僵尸进程的父进程僵尸进程ID：3457，父进程ID：3425僵尸进程ID：3533，父进程ID：35113、使用Kill -HUP 僵尸进程ID...

#!/bin/bash. ~/.bashrccurrent_date=`date +%Y-%m-%d`echo ${current_date}basepath=$(cd `dirname $0`; pwd)cd $basepathBAK=/home/work/daiyuanpei/monitorif [ "`ls -A ${BAK}`" = "" ];then echo "$...

# 推文件scp uid.txt work@10.10.10.10:/home/work/# 拉文件scp work@10.10.10.10:/home/work/uid.txt ./# wgetwget ftp://daiyuanpei.xxx.com:8021/home/users/daiyuanpei/sql_data/test.txt# 格式化显示当前目录文件大小ls -...

############## awk ################ 第一列求和cat aaa.txt | awk '{sum+=$1} END {print "Sum = ", sum}'# 把列式转为逗号隔开的数据awk -F' ' '{print $1}' uids | xargs | tr ' ' ',' >> uids_row# 取第二列为新文件：cat u...

方法一：利用grepgrep -v '^\s*$' test.txt > new_file注：-v表示将匹配的结果进行反转，正则表达式匹配空行。（空行可包括空格符、制表符等空白字符）方法二：利用sedsed '/^\s*$/d' test.txt > new_file注：d代表删除该行或者：sed -i '/^\s*$/d' test.txt方法三：利用aw...