Jeff Frost jfrost
jfrost
/ gist:62287
Created
February 11, 2009 21:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [1234385417] Max concurrent service checks (500) has been reached. Delaying further checks until previous checks are complete... | |
| [1234385417] Max concurrent service checks (500) has been reached. Delaying further checks until previous checks are complete... | |
| [1234385417] Max concurrent service checks (500) has been reached. Delaying further checks until previous checks are complete... | |
| [1234385418] Max concurrent service checks (500) has been reached. Delaying further checks until previous checks are complete... | |
| [1234385418] Max concurrent service checks (500) has been reached. Delaying further checks until previous checks are complete... | |
| [1234385419] Warning: The check of service 'ssh' on host 'ey02-n02' looks like it was orphaned (results never came back). I'm scheduling an immediate check of the service... | |
| [1234385419] Warning: The check of service 'ssh' on host 'ey02-n13' looks like it was orphaned (results never came back). I'm scheduling an immediate check of the service... | |
| [1234385419] Warn |
jfrost
/ gist:64042
Created
February 13, 2009 18:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| schemaname, tablename, | |
| ROUND(CASE WHEN otta=0 THEN 0.0 ELSE sml.relpages/otta::numeric END,1) AS tbloat, | |
| CASE WHEN relpages < otta THEN 0 ELSE relpages::bigint - otta END AS wastedpages, | |
| CASE WHEN relpages < otta THEN 0 ELSE bs*(sml.relpages-otta)::bigint END AS wastedbytes, | |
| CASE WHEN relpages < otta THEN pg_size_pretty(0) ELSE pg_size_pretty((bs*(relpages-otta))::bigint) END AS wastedsize, | |
| iname, ituples::bigint, ipages::bigint, iotta, | |
| ROUND(CASE WHEN iotta=0 OR ipages=0 THEN 0.0 ELSE ipages/iotta::numeric END,1) AS ibloat, | |
| CASE WHEN ipages < iotta THEN 0 ELSE ipages::bigint - iotta END AS wastedipages, | |
| CASE WHEN ipages < iotta THEN 0 ELSE bs*(ipages-iotta) END AS wastedibytes, |
jfrost
/ gist:65887
Created
February 17, 2009 18:34
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Process 1246 resumed (parent 23203 ready) | |
| child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x2b90d4fff440) = 1246 | |
| [pid 1246] close(4 <unfinished ...> | |
| [pid 1246] <... close resumed> ) = 0 | |
| [pid 1246] munmap(0x2b90d38a1000, 4096 <unfinished ...> | |
| [pid 1246] <... munmap resumed> ) = 0 | |
| [pid 1246] rt_sigaction(SIGQUIT, {SIG_DFL}, <unfinished ...> | |
| [pid 1246] <... rt_sigaction resumed> {0x43b970, [QUIT], SA_RESTORER|SA_RESTART, 0x2b90d4ae4680}, 8) = 0 | |
| [pid 1246] rt_sigaction(SIGTERM, {SIG_DFL}, <unfinished ...> | |
| [pid 1246] <... rt_sigaction resumed> {0x43b970, [TERM], SA_RESTORER|SA_RESTART, 0x2b90d4ae4680}, 8) = 0 |
jfrost
/ gist:75461
Created
March 7, 2009 21:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | setting | description | |
| ---------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------- | |
| add_missing_from | off |
jfrost
/ gist:167479
Created
August 13, 2009 21:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| schemaname, tablename, | |
| ROUND(CASE WHEN otta=0 THEN 0.0 ELSE sml.relpages/otta::numeric END,1) AS tbloat, | |
| CASE WHEN relpages < otta THEN 0 ELSE relpages::bigint - otta END AS wastedpages, | |
| CASE WHEN relpages < otta THEN 0 ELSE bs*(sml.relpages-otta)::bigint END AS wastedbytes, | |
| CASE WHEN relpages < otta THEN pg_size_pretty(0) ELSE pg_size_pretty((bs*(relpages-otta))::bigint) END AS wastedsize, | |
| iname, ituples::bigint, ipages::bigint, iotta, | |
| ROUND(CASE WHEN iotta=0 OR ipages=0 THEN 0.0 ELSE ipages/iotta::numeric END,1) AS ibloat, | |
| CASE WHEN ipages < iotta THEN 0 ELSE ipages::bigint - iotta END AS wastedipages, | |
| CASE WHEN ipages < iotta THEN 0 ELSE bs*(ipages-iotta) END AS wastedibytes, |
jfrost
/ gist:210296
Created
October 14, 2009 18:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [gitosis] | |
| [group gitosis-admin] | |
| writable = gitosis-admin | |
| members = jeff@discord jeff@glacier | |
| [group frostconsulting] | |
| members = jeff@discord jeff@glacier | |
| writable = clients jeff |
jfrost
/ gist:224284
Created
November 2, 2009 17:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| schemaname, tablename, | |
| ROUND(CASE WHEN otta=0 THEN 0.0 ELSE sml.relpages/otta::numeric END,1) AS tbloat, | |
| CASE WHEN relpages < otta THEN 0 ELSE relpages::bigint - otta END AS wastedpages, | |
| CASE WHEN relpages < otta THEN 0 ELSE bs*(sml.relpages-otta)::bigint END AS wastedbytes, | |
| CASE WHEN relpages < otta THEN pg_size_pretty(0) ELSE pg_size_pretty((bs*(relpages-otta))::bigint) END AS wastedsize, | |
| iname, ituples::bigint, ipages::bigint, iotta, | |
| ROUND(CASE WHEN iotta=0 OR ipages=0 THEN 0.0 ELSE ipages/iotta::numeric END,1) AS ibloat, | |
| CASE WHEN ipages < iotta THEN 0 ELSE ipages::bigint - iotta END AS wastedipages, | |
| CASE WHEN ipages < iotta THEN 0 ELSE bs*(ipages-iotta) END AS wastedibytes, |
jfrost
/ gist:337936
Created
March 19, 2010 17:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #Crossfit playlist: | |
| Three Days Grace/One-X/06 - Riot.mp3 | |
| Linkin_Park/Meteora/07 - Faint.mp3 | |
| Three Days Grace/Life Starts Now/02 - Break.mp3 | |
| Nickelback/The Long Road/07 - Figured You Out.mp3 | |
| Saving Abel/Addicted [Explicit]/01 - Addicted [Explicit].mp3 | |
| Nickelback/Dark Horse/10 - If Today Was Your Last Day.mp3 | |
| Drowning Pool/Sinner/02 - Bodies.mp3 | |
| Three Days Grace/One-X/03 - Animal I Have Become.mp3 |
jfrost
/ gist:639416
Created
October 21, 2010 21:43
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| _ _ _ _ _ _ _ | |
| _( )_ ( ) ( ) _( )_ ( ) ( ) _( )_ | |
| ( ` ' )| |_| | _ _ __ ( ` ' )| |_| | _ _ __ ( ` ' ) | |
| > < | _ |( ) ( ) /'_ `\ > < | _ |( ) ( ) /'_ `\ > < | |
| (_, ,_)| | | || (_) |( (_) |(_, ,_)| | | || (_) |( (_) |(_, ,_) | |
| (_) (_) (_)`\___/'`\__ | (_) (_) (_)`\___/'`\__ | (_) | |
| ( )_) | ( )_) | | |
| \___/' \___/' | |
jfrost
/ gist:650247
Created
October 27, 2010 23:32
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| OLDIFS=$IFS | |
| IFS='|' | |
| i=0 | |
| $PSQL -lt --no-align | grep -v '^postgres$\|^template[01]' | | |
| while read -a DATABASES; do | |
| #DB=( ${DB[@]} ${DATABASES[0]} ) | |
| DB[${i}]=${DATABASES[0]} | |
| DBOWNER[${i}]=${DATABASES[1]} | |
| DBENCODING[${i}]=${DATABASES[2]} |