Disk Usage Estimate Notes

From a conversaion with Paul M. and Alex A., ca October 4, 2017.

disk_usage_estimate_notes

 

Advertisements

work disk clean up notes

in TB:

  • 09-26: 80
  • 10-04: 77
  • 10-06: 62
  • 10-18: 60
  • 10-19: 55

Useful select:

select sum((work_file.size*1.e-9)*(unix_timestamp(now()) - unix_timestamp(atime))/3.15e7) as sumgby, sum(work_file.size*1.e-9) as sumgb, dirname from work_dir, work_file where work_dir.id = dirId and work_dir.uid = 4380 group by dirId order by sumgby desc limit 10;