phil-hildebrand

-- turn off paging (less/more)
psql> \pset pager off

/*
Pager usage is off.
*/

-- find an object name by id

SELECT OID, relname

phil-hildebrand

Keybase proof

I hereby claim:

• I am phil-hildebrand on github.
• I am phildebrand (https://keybase.io/phildebrand) on keybase.
• I have a public key ASAVLGu-aFMtCTRIUD1J3LxD7_k3zudPIY_L2X1ODY_Qago

To claim this, I am signing this object:

phil-hildebrand

---
env:
  - travis:
    namenode-primary: localhost
    namenode-backup: localhost
    journalnode: localhost
    zookeeperserver: localhost
    resourcemanager: localhost
    historyserver: localhost
    httpfs: localhost

phil-hildebrand

#!/bin/sh
#
#   Auto discover and drop FKs:
#
mysql -s -e "select 'alter table ', table_name, ' drop foreign key ', constraint_name, ';' from information_schema.referential_constraints ;" > /tmp/disable_fk.sql
mysql -s <  /tmp/disable_fk.sql

phil-hildebrand

-- Get Current sessions by state:

   SELECT @@hostname as server, user,state,command,count(*) 
   FROM information_schema.processlist 
   GROUP BY user,state,command ;

/*
+-------------+-------------+---------------------------------------------------------------+-------------+----------+
| server      | user        | state                                                         | command     | count(*) |