Sysadmin idioms: Difference between revisions

From DISI
Jump to navigation Jump to search
No edit summary
No edit summary
Line 20: Line 20:
  select max(ecfp4_fk) from fingerprints.ecfp4_data
  select max(ecfp4_fk) from fingerprints.ecfp4_data


 
queue stuck?
Try qmod -c *lamed and qmod -e *@lamed
[[Category:Sysadmin]]
[[Category:Sysadmin]]
[[Category:Idioms]]
[[Category:Idioms]]

Revision as of 18:31, 2 December 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

queue stuck?

Try qmod -c *lamed and qmod -e *@lamed