Skip to content

Instantly share code, notes, and snippets.

tony4d /
Created Oct 13, 2015
Analyze all tables in a mysql database from the command line (bash)
# To avoid doing things like putting your mysql password on the cli which is not secure
# Use mysql config editor
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";
tony4d /
Last active Aug 29, 2015
Compile ruby from source for rbenv on OS X
# 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
tony4d /
Created Apr 17, 2014
Keybase verification

Keybase proof

I hereby claim:

  • I am tony4d on github.
  • I am 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 /
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.
# 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
# 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 /
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.
mysqldump -u [user] -p -xQce -R --master-data=2 --max-allowed-packet=1024M -B [db_name] | gzip > [db_name].sql.gz
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
# Then install ie8, 9 & 10 vms
curl -s | env IEVMS_VERSIONS="8 9 10" bash
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 / memcache_bench.php
Created Jan 21, 2013
Benchmark the memcache php extension from cli
View memcache_bench.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");
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 /
Created Aug 24, 2012
Setup p4merge as a visual diff and merge tool for git