Sysadmin idioms: Difference between revisions

From DISI
Jump to navigation Jump to search
(bla)
No edit summary
Line 7: Line 7:
grant access on bet:
grant access on bet:
  xfs_quota -xc "limit bsoft=1000g bhard=1500g tbalius" /srv/work
  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


[[Category:Sysadmin]]
[[Category:Sysadmin]]
[[Category:Idioms]]
[[Category:Idioms]]

Revision as of 23:10, 24 November 2014

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