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:
-- turn off paging (less/more) | |
psql> \pset pager off | |
/* | |
Pager usage is off. | |
*/ | |
-- find an object name by id | |
SELECT OID, relname |
I hereby claim:
To claim this, I am signing this object:
--- | |
env: | |
- travis: | |
namenode-primary: localhost | |
namenode-backup: localhost | |
journalnode: localhost | |
zookeeperserver: localhost | |
resourcemanager: localhost | |
historyserver: localhost | |
httpfs: localhost |
#!/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 |
-- 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(*) | |