Patrick Tully mrpatrick

Professional guru by day, amateur photog, astronomer, road biker, and banjo player on weekends

mrpatrick / remove_known_host.sh

Created September 8, 2015 13:23

remove host from .ssh/known_hosts file

ssh-keygen -R [HOSTNAME]

mrpatrick / largest_tables.mysql

Created August 12, 2015 14:21

Find the largest (byte size) 20 tables in GB in MySQL 5.x - taken from: https://www.percona.com/blog/2008/02/04/finding-out-largest-tables-on-mysql-server/

	SELECT CONCAT(table_schema, '.', table_name),
	CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
	CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
	CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx,
	CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
	ROUND(index_length / data_length, 2) idxfrac
	FROM information_schema.TABLES
	ORDER BY data_length + index_length DESC
	LIMIT 20;

mrpatrick / git_subtree_add.sh

Last active August 29, 2015 14:27

Add a subtree repo/project to an existing repo

	# Works with master branch
	git subtree add --squash --prefix=circle [email protected]:avatarnewyork/circleci.git master

mrpatrick / docker-exec.sh

Last active January 6, 2016 21:34

enter a container with exec

	# where the container is 0f4fe0b1f413
	docker exec -i -t 0f4fe0b1f413 bash

	# or for an apache instance
	docker exec -ti projectname_projectname_1 /bin/bash

	# or for example mysql
	docker exec -ti projectname_db_1 /bin/bash

mrpatrick / docker_rm_except.sh

Last active August 31, 2015 18:01

From https://coderwall.com/p/ewk0mq/stop-remove-all-docker-containers stop / remove all containers

docker rm $(docker ps -a |grep -v RUNNING_CONTAINER_NAME | awk '{print $1}')

mrpatrick / gzip_uncompressed_file_size.sh

Created July 22, 2015 15:52

find uncompressed file size. The first line returns the uncompressed file size in bytes

	#!/bin/bash
	time zcat test.gz\| wc -c

mrpatrick / rest_drupal_pwd.sh

Created July 8, 2015 13:27

reset drupal admin password

drush upwd admin --password="s3cr3t"

mrpatrick / git_patch_file_branches.sh

Created July 2, 2015 11:10

From http://nicolasgallagher.com/git-checkout-specific-files-from-another-branch/ Patch a single file across branches

	# On branch master
	git checkout gh-pages
	git checkout master -- myplugin.js
	git commit -m "Update myplugin.js from master"

mrpatrick / bad_robots_access_logs.sh

Created July 1, 2015 14:47

Find all robot user agents in logs, sort by hits

cat access_log | awk -F\" '{print $6}' | sort | uniq -c | sort -n |grep bot

mrpatrick / force_git_pointer.sh

Last active August 29, 2015 14:23

Force branch pointer for current release

	git branch -f stage release-v1.0.1
	git push -f origin stage