zafergurel

domain=$1

ips="$(nslookup $1 | grep -zoP "Non-authoritative(.|\n)+" | grep -aPo "\d+\.\d+\.\d+\.\d+")";

# echo $ips;

for ip in $ips; do
    echo "Checking $domain on $ip";
    curl --resolve $domain:443:$ip https://$domain -s -S > /dev/null
    curl --verbose --resolve $domain:443:$ip https://$domain 2>&1 | grep -E "expire"

zafergurel

sh -c "truncate -s 0 /var/lib/docker/containers/*/*-json.log"
echo '{ "log-driver": "json-file", "log-opts": {"max-size": "100m", "max-file": "3"} }' &> /etc/docker/daemon.json
sudo sh -c "truncate -s 0 /var/lib/docker/containers/*/*-json.log"
systemctl reload docker

zafergurel

df | awk '{if($2 > 30000000 && $6 !~ "/var")  {print $6}}'

zafergurel

USE master

SELECT MyInt = CONVERT(BIGINT, o1.object_id) + CONVERT(BIGINT, o2.object_id) + CONVERT(BIGINT, o3.object_id)
INTO #temp
FROM sys.objects o1
JOIN sys.objects o2 ON o1.object_id < o2.object_id
JOIN sys.objects o3 ON o1.object_id < o3.object_id

SELECT SUM(CONVERT(BIGINT, o1.MyInt) + CONVERT(BIGINT, o2.MyInt))
FROM #temp o1

zafergurel

#!/usr/bin/env bash
#check_str=`grep "Advancity Server Performance Tuning Parameters" /etc/sysctl.conf`
#if [[ ! -z $check_str ]]; then echo 'Configuration already made in /etc/sysctl.conf'; exit; fi;

sysctl -a | grep -P "fs.file-max\
|net.ipv4.tcp_max_orphans|net.ipv4.tcp_no_metrics_save|net.ipv4.tcp_window_scaling\
|net.ipv4.tcp_timestamps|net.ipv4.tcp_sack|net.ipv4.tcp_max_syn_backlog|\
net.ipv4.tcp_congestion_control|net.ipv4.tcp_mtu_probing|net.ipv4.tcp_synack_retries|\
net.ipv4.ip_local_port_range|net.ipv4.tcp_rfc1337|net.ipv4.tcp_fin_timeout|\
net.core.somaxconn|net.core.netdev_max_backlog|net.core.optmem_max|net.ipv4.tcp_mem|\

zafergurel

crontab -l > /tmp/mycron
tee -a /tmp/mycron <<EOF
# restart wowza
0 1 * * * /bin/systemctl restart WowzaStreamingEngine
# free cache
*/1 * * * * /opt/advancity/bin/free_mem_cache.sh
# rclone
@reboot /opt/advancity/bin/stream_mover_perculusplus.sh

@reboot sleep 10 && /usr/local/bin/docker-compose -f /perculusdata/perculus-setup/perculus/docker-compose.yml up -d

zafergurel

#!/bin/bash
gracedays=90

# get domain names from a file
# a domain at each line
domain_file="domains.txt"

cat $domain_file | while read -a domains;
do
    server=${domains[0]}

zafergurel

#!/usr/bin/env bash
if find $1 -maxdepth 0 -empty | read v; then echo 1; else echo 0 ; fi

zafergurel

#!/usr/bin/env bash

cron_line="<cron line to search for>"
cronjob=`crontab -l | grep "$cron_line"`

if [[ -z $cronjob ]]
    then
    crontab -l > /tmp/mycron
    echo -e "\n$cron_line" >> /tmp/mycron
    crontab /tmp/mycron

zafergurel

-- https://www.geekytidbits.com/performance-tuning-postgres/
-- http://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/
-- http://okigiveup.net/what-postgresql-tells-you-about-its-performance/
-- https://wiki.postgresql.org/wiki/Introduction_to_VACUUM,_ANALYZE,_EXPLAIN,_and_COUNT
-- https://devcenter.heroku.com/articles/postgresql-indexes#b-trees-and-sorting
-- http://www.databasesoup.com/2014/05/new-finding-unused-indexes-query.html
-- performance tools
-- https://www.vividcortex.com/resources/network-analyzer-for-postgresql

-- show running queries (pre 9.2)