WalterCool waltercool

Stopping a zombie machine: aws opsworks stop-instance --instance-id <opsworks ID>
Resize root disk on AWS:
z) partprobe /dev/xvdX
a) parted /dev/xvdX print
b) parted /dev/xvdX resizepart Y && resize2fs /dev/xvdXY # resize2fs needed to update the partition table

Update for xfs partitions:

a) growpart /dev/xvda 1

vimdiff cheat sheet

##git mergetool

In the middle file (future merged file), you can navigate between conflicts with ]c and [c.

Choose which version you want to keep with :diffget //2 or :diffget //3 (the //2 and //3 are unique identifiers for the target/master copy and the merge/branch copy file names).

:diffupdate (to remove leftover spacing issues)

:only (once you’re done reviewing all conflicts, this shows only the middle/merged file)

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

	from peewee import *

	class BModel(Model):
	class Meta:
	database = db

	@classmethod
	def create_table(cls, args, *kwargs):
	for field in cls._meta.get_fields():
	if hasattr(field, "pre_field_create"):

	curl -XPUT <hostname-or-IP>:9200/_cluster/settings -H 'Content-Type: application/json' -d '{
	"transient" :{
	"cluster.routing.allocation.exclude._ip" : "X.X.X.X"
	}
	}'

	# Clear all sidekiq scheduled
	require 'sidekiq/api'
	Sidekiq::ScheduledSet.new.clear

	# Clear an specific queue by job name
	jobs = Sidekiq::ScheduledSet.new.select {\|retri\| retri.klass == 'job_name' }
	jobs.each(&:delete)

	# Compress x265 with deinterlace using Cuda
	ffmpeg -hwaccel cuvid -i <INPUT> -pix_fmt p010le -vf yadif -c:v hevc_nvenc -preset slow -acodec copy <OUTPUT> #NOT WORKING ANYMORE

	ffmpeg -i <INPUT> -vf yadif=parity=auto -vcodec hevc_nvenc -acodec copy -preset slow <OUTPUT>

	# Merge Video+Audio
	ffmpeg -i <Video> -i <Audio> -codec copy -shortest <OUTPUT>

	# Extract audio from Video under Mono
	ffmpeg -i <VIDEO> -vn -ac 1 <Audio>

	Backup: pg_dump -Fc -f /path/to/backup.dump

	Restore: pg_restore -U <USER> -h <HOST> -d <DATABASE> -Fc -Oxc backup.dump

	How to connect USB through debug console

	device_add usb-host,vendorid=0xL33T,productid=0xDEMO,id=whatever

	(Obtain values from L33T and DEMO with lsusb)

	Make sure to provide QEMU access to /dev/bus/usb/X/Y, take X and Y from dmesg values

	# Purge all Varnish cache
	varnishadm "ban req.url ~ /"