Skip to content

Instantly share code, notes, and snippets.

Tony Ford tony4d

Block or report user

Report or block tony4d

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@tony4d
tony4d / mysql-analyze-all-tables.sh
Created Oct 13, 2015
Analyze all tables in a mysql database from the command line (bash)
View mysql-analyze-all-tables.sh
#!/bin/bash
# To avoid doing things like putting your mysql password on the cli which is not secure
# Use mysql config editor http://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html
for table in $(mysql --login-path=mylogins -D database_name -Bse "show tables");
do mysql --login-path=mylogins -D database_name -Bse "analyze table $table";
done
@tony4d
tony4d / ruby-from-source.sh
Last active Aug 29, 2015
Compile ruby from source for rbenv on OS X
View ruby-from-source.sh
# Assumptions:
# - You are using rbenv, installed in ~/.rbenv
# - You are using homebrew
# - You want to install ruby 2.1.2 (for example)
#
# Make sure you have openssl installed first
brew install openssl
# Before you begin, download ruby source from https://www.ruby-lang.org/en/downloads/
@tony4d
tony4d / keybase.md
Created Apr 17, 2014
Keybase verification
View keybase.md

Keybase proof

I hereby claim:

  • I am tony4d on github.
  • I am tony4d (https://keybase.io/tony4d) on keybase.
  • I have a public key whose fingerprint is 3F64 5B71 C70B 4BFE 5E2A D205 2AEC 93AD 5C92 5CAC

To claim this, I am signing this object:

@tony4d
tony4d / mysqldump-backup.sh
Last active Jun 11, 2019
Backup all databases on a mysql server excluding information/performance_schema and including UDFs/stored procedures. Most useful scheduling this on a slave db.
View mysqldump-backup.sh
#!/bin/bash
# No username or passwords in this script, you should use mysql_config_editor
# to store it securely. The login-path in this script is set to "local-backup" so when you create
# your .mylogin.cnf with the mysql-config-editor make sure it is set the same
# See http://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html
# An example to create your config for a mysql user "backup":
# shell> sudo mysql_config_editor set --login-path=local-backup --host=localhost --user=backup --password
# The backup user in the mysql server needs these privileges: SELECT, RELOAD, SHOW DATABASES, REPLICATION CLIENT
@tony4d
tony4d / mysqldump-backup-slave.sh
Last active Jun 18, 2018
Using mysqldump for backups on a slave. Note the use of --master-data=2, this makes sure we get a global read lock and write out a comment in the sql file with the master log filename and current position. Now this backup is good for adding or bringing back a slave from scratch.
View mysqldump-backup-slave.sh
mysqldump -u [user] -p -xQce -R --master-data=2 --max-allowed-packet=1024M -B [db_name] | gzip > [db_name].sql.gz
@tony4d
tony4d / gist:5826186
Created Jun 20, 2013
Install some ie vms on a mac
View gist:5826186
# first download and install virtual box
curl -O http://download.virtualbox.org/virtualbox/4.2.12/VirtualBox-4.2.12-84980-OSX.dmg
# Then install ie8, 9 & 10 vms
curl -s https://raw.github.com/xdissent/ievms/master/ievms.sh | env IEVMS_VERSIONS="8 9 10" bash
@tony4d
tony4d / gist:5779546
Last active Dec 18, 2015
Simple mysqldump to sync up a dev env
View gist:5779546
mysqldump -u [user_name] -p -Qce --max-allowed-packet=1024M -B [database_name] > database_name.sql
@tony4d
tony4d / memcache_bench.php
Created Jan 21, 2013
Benchmark the memcache php extension from cli
View memcache_bench.php
<?php
/*
exit codes:
0 - everything ok.
1 - failure to connect
*/
if ( ! extension_loaded('memcache') ) {
die("memcache pecl module is not available. Please install a STABLE version from http://pecl.php.net/package/memcache");
}
@tony4d
tony4d / xbox-ie-user-agent.txt
Created Oct 19, 2012
Xbox 360 Internet Explorer (ie) User Agent
View xbox-ie-user-agent.txt
Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; Xbox)
@tony4d
tony4d / p4merge4git.md
Created Aug 24, 2012
Setup p4merge as a visual diff and merge tool for git
View p4merge4git.md
You can’t perform that action at this time.