zoer

reduce TCP MSS

iptables  -t mangle -I FORWARD -i wg0 -p tcp -m tcp --tcp-flags SYN,RST SYN -m tcpmss --mss 1343:65535 -j TCPMSS --set-mss 1342

list all available network devices

ls /sys/class/net

zoer

-- active queries
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 
AND age(clock_timestamp(), query_start) < interval '1minute'
ORDER BY query_start desc;

zoer

fu! GenerateUUID()

python << EOF
import uuid
import vim

# output a uuid to the vim variable for insertion below
vim.command("let generatedUUID = \"%s\"" % str(uuid.uuid4()))

EOF

zoer

#!/bin/bash -e

echo "      date     time $(free -m | grep total | sed -E 's/^    (.*)/\1/g')"
while true; do
    echo "$(date '+%Y-%m-%d %H:%M:%S') $(free -m | grep Mem: | sed 's/Mem://g')"
    sleep 1
done

zoer

#!/bin/bash

sudo service mongodb stop
sudo rm /data/mongod.lock
mongod -dbpath /data --repair
sudo service mongodb start