qps from access log

qps-from-access-log.md

command

cat access_log |cut -d " " -f4|sort |uniq -c |sort -n -r

PS: cut -d " " -f4 equals to awk -F " " '{print $4}'

L:某line对应的log文本

sort -n -r sort -u -n -r
order by number desc select distinct(L) order by number desc

sort本身没有select count(L)功能，也就是不产生number列

uniq -c uniq

select count(L) as number, distinct(L) select distinct(L)

uniq不带-c参数，也产生不了number列

grep
where l LIKE

grep -v
where l NOT LIKE

cat
select *

wc -l
select count(*)

docker ps -a -q |shuf | awk '{system("docker logs --tail 1 ""$1"" ")}'

docker ps -a -q |shuf |awk 'NR%2==0' |awk '{system("docker rm -f ""$1"" ")}'
docker ps -q |shuf |awk 'NR%2==0' |awk '{system("docker stop ""$1"" ")}'

string to hex: echo -n '0123456789abcdefghijklmnopqrstuv' |xxd -c 256 -ps

aes-256-cbc encrypt/decrypt:

echo -n "test 1234" | openssl aes-256-cbc -a -K `echo -n '0123456789abcdefghijklmnopqrstuv' |xxd -c 256 -ps` -iv 0
echo -n "test 1234" | openssl enc -nosalt -aes-256-cbc -base64 -K `echo -n '0123456789abcdefghijklmnopqrstuv' |xxd -c 256 -ps` -iv 0

echo "WC6m55gjidpPpqXZJbagzg==" | openssl aes-256-cbc -d -a -K `echo -n '0123456789abcdefghijklmnopqrstuv' |xxd -c 256 -ps` -iv 0

aes-128-cbc encrypt/decrypt:

echo -n "test 1234" |openssl aes-128-cbc -iv f123 -K 1223 -a

echo "R9MVzzWBA/Ye5qu9a4hX6A==" |openssl aes-128-cbc -iv f123 -K 1223 -a -d