Skip to content

Instantly share code, notes, and snippets.

View smerrill's full-sized avatar
🤖
Attention is all you need

Steven Merrill smerrill

🤖
Attention is all you need
75 followers · 13 following
View GitHub Profile
@smerrill
smerrill / gist:941143
Created April 25, 2011 20:25
!.*/(\.[^/]*|CVS|_darcs|_MTN|\{arch\}|blib|.*~\.nib|.*\.(framework|app|pbproj|pbxproj|xcode(proj)?|bundle))$
@smerrill
smerrill / gist:941142
Created April 25, 2011 20:24
https://gist.github.com/941137
@smerrill
smerrill / remove-old-mysql-51-binaries.sh
Created March 24, 2011 23:13
#!/bin/bash
# Remove all the mysql 5.1.56 commands from your Homebrew installation.
ls -aFl $(brew --prefix)/bin/mysql* | grep 56 | awk {'print $9'} | tr -d '@' | xargs rm
@smerrill
smerrill / varnish-esi-watch.sh
Created January 3, 2011 20:00
Watch Varnish's transactions go by for ESI blocks in Drupal.
varnishlog -x 'CLI' -x 'WorkThread' -x 'Debug' -o TxURL '^/esi/block/'
@smerrill
smerrill / load_vcl_clear_cache.sh
Created December 8, 2010 18:50
Load a new VCL file, replace the running configuration, and set all cache to be purged.
OLD_CFG=`varnishadm -S /etc/varnish/secret -T 127.0.0.1:6082 "vcl.list" | grep active | awk '{print $3}'`
NEW_CFG="vcl-"`date +%s`
varnishadm -S /etc/varnish/secret -T 127.0.0.1:6082 "vcl.load $NEW_CFG /etc/varnish/default.vcl"
varnishadm -S /etc/varnish/secret -T 127.0.0.1:6082 "vcl.use $NEW_CFG"
varnishadm -S /etc/varnish/secret -T 127.0.0.1:6082 "vcl.discard $OLD_CFG"
varnishadm -S /etc/varnish/secret -T 127.0.0.1:6082 "purge req.url ~ .*"
@smerrill
smerrill / gist:571149
Created September 9, 2010 00:47
def verify(a:String) = {(10 - a.reverse.tail.zip(Stream.continually(List(2, 1)).flatten).foldLeft(0)((sum, vals) => sum + (vals._1.toString.toInt * vals._2).toString.toList.foldLeft(0)(_+_.toString.toInt)) % 10).toString.last.toString.toInt == a.last.toString.toInt}
@smerrill
smerrill / convert-myisam-tables-to-innodb.sh
Created June 13, 2010 19:10
#!/bin/bash
# Variables definitions
DBNAME="tony_local_test"
MYSQL_COMMON="-uroot -D$DBNAME"
SQL_QUERY="SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '$DBNAME' AND ENGINE='MyISAM';"
ALTER_TABLE_QUERY=""
# Build up one giant SQL string.
for i in `mysql $MYSQL_COMMON --skip-column-names -s -e "$SQL_QUERY"`; do
@smerrill
smerrill / website-test.js
Created June 8, 2010 03:16
var sys = require("sys"),
http = require("http"),
growl = require("./node-growl/lib/growl"),
child_process = require("child_process");
function createClient() {
var i = http.createClient(80, website);
// Handle a connection error.
// Thanks to http://rentzsch.tumblr.com/post/664884799/node-js-handling-refused-http-client-connections.
@smerrill
smerrill / mysql-backup.sh
Created June 4, 2010 03:28
#!/bin/bash
date=`date "+%Y-%m-%d"`
for i in /Applications/MAMP/db/mysql/*/; do
dbname=`basename $i`
/Applications/MAMP/Library/bin/mysqldump -uroot $dbname > ~/hdd-smerrill/Documents/Backups/$dbname-$date.sql
done
@smerrill
smerrill / Miss Headers
Created May 28, 2010 14:52
sub vcl_deliver {
if (obj.hits > 0) {
set resp.http.X-Cache = "HIT";
} else {
set resp.http.X-Cache = "MISS";
}
return (deliver);
}