Skip to content

Instantly share code, notes, and snippets.

@doublejosh
Last active August 29, 2015 13:57
Show Gist options
  • Save doublejosh/9402263 to your computer and use it in GitHub Desktop.
Save doublejosh/9402263 to your computer and use it in GitHub Desktop.
Form Cache Table Size Breakdown
LOCAL...
mysql -uroot -proot tableau_pantheon_www -e "select cid, LENGTH(data) as length_data, serialized, expire, created INTO OUTFILE '/Users/***USER***/Documents/Tableau/form_cache_size-local.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' from cache_form"
LOCAL WITH OUT OUTFILE...
mysql -uroot -proot tableau_pantheon_www -e "select cid, LENGTH(data) as length_data, serialized, expire, created from cache_form" > /Users/jlind/Documents/Tableau/form_cache_size-local.txt
REMOTE...
mysql -upantheon -p***PASS*** -h dbserver.live.***HASH***.drush.in -P ***PORT*** pantheon -e "select cid, LENGTH(data) as length_data, serialized, expire, created from cache_form" > /Users/***USER***/Documents/Tableau/form_cache_size-live.txt
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment