| # Adjust the display resolution | |
| # Use with: | |
| # 128MB of video memory | |
| # Graphics Controller: VBoxVGA | |
| # 3D acceleration enabled | |
| VBoxManage setextradata "Mac OS X El Capitan" VBoxInternal2/EfiGraphicsResolution 1920x1080 |
| -- Count the number of rows for all tables in a schema | |
| -- From: https://stackoverflow.com/a/38684225/638425 | |
| select table_schema, | |
| table_name, | |
| (xpath('/row/cnt/text()', xml_count))[1]::text::bigint as row_count | |
| from ( | |
| select table_name, table_schema, | |
| query_to_xml(format('select count(*) as cnt from %I.%I', table_schema, table_name), false, true, '') as xml_count | |
| from information_schema.tables |
| UPDATE pg_index SET indisready = false WHERE indrelid = 'my_table'::regclass::oid; | |
| \copy my_table(column1, column2, ...) FROM 'my_table.csv' CSV HEADER; | |
| UPDATE pg_index SET indisready = true WHERE indrelid = 'my_table'::regclass::oid; |
| while read p; do | |
| curl -s "$p" | grep -o "/hotel/" | wc -l | |
| done < curl -s https://www.agoda.com/sitemaps.xml | egrep -o "https.*?=.*?_.*?_.*?_.*?_[[:digit:]]*" |
| $ ssh redis-server "redis-cli -h redis.host.com --csv hgetall {s0m3key}" | \ | |
| awk -F, '{ gsub(/","/,"\" \"",$0); print "HMSET", "{s0m3key}", $0 }' - | redis-cli --pipe |
| function loadenv() { | |
| . "$1" ; export $(cut -d= -f1 "$1") | |
| } | |
| export -f loadenv |
| $ echo '{"apps": [{"name": "app1"}, {"name": "app2"}]}' | pm2 restart - |
| # Given a log file with entries of the following form: | |
| # 2017-05-06T16:42:54.392Z 66.249.64.58 200 GET /path/to-somewhere 27.020 ms - - "-" | |
| # Print all slow Google bot requests | |
| tail -f web-server.log | awk '{ip=$2; status=$3; time=$6; path=$5; if (ip ~ /66\.249\.64/ && time > 150) print time " (" status ") " path}' |
| sed -i '1,10d' myfile | |
| # As per http://superuser.com/a/405314 |
If you get these in your syslog:
Dec 19 05:07:01 ip-10-0-2-194 cron[9036]: (*system*aws-crawnchers) WRONG FILE OWNER (/etc/cron.d/some-cronjob)
Dec 19 05:08:01 ip-10-0-2-194 cron[9036]: (*system*web-server) INSECURE MODE (group/other writable) (/etc/cron.d/some-cronjob)
You need to: