Sysadmin idioms

From DISI
Revision as of 23:10, 24 November 2014 by Frodo (talk | contribs)
Jump to navigation Jump to search

Save time as sysadmin.

~teague/Scripts/sshnodes.py to call ~teague/batch/mount-diva2.sh 

see progress of raid rebuild, eg on aleph.

cat /proc/mdstat

grant access on bet:

xfs_quota -xc "limit bsoft=1000g bhard=1500g tbalius" /srv/work

maximum FP FK referenced from substance

select max(ecfp4_fk) from substance;

how many protomers

select count(prot_id) from protomer;

how many substances

select count(sub_id) from substance;

max FP reference in FP master join table:

select max(ecfp4_fk) from fingerprints.ecfp4_data