account | % num jobs | % of wall | count()* | walltime sec | sum(round(max_vsize/1024)) | sum_tres_req_mem | mem_diff | % |
total: | ||||||||
atlas | 100.00% | 100.00% | 288913 | 2694614271 | 1,617,843,841 | 1,389,126,500 | 228,717,341 | 116.46% |
cms | 100.00% | 100.00% | 50840 | 1535630187 | 230,934,497 | 356,035,968 | -125,101,471 | 64.86% |
lhcb | 100.00% | 100.00% | 57574 | 3211019505 | 255,594,384 | 115,148,000 | 140,446,384 | 221.97% |
req<=2000: | ||||||||
atlas | 68.50% | 43.09% | 197903 | 1160991397 | 547,848,230 | 386,762,000 | 161,086,230 | 141.65% |
cms | 74.38% | 0.28% | 37816 | 4244836 | 30,376,806 | 75,632,000 | -45,255,194 | 40.16% |
lhcb | 100.00% | 100.00% | 57572 | 3210873808 | 255,585,171 | 115,144,000 | 140,441,171 | 221.97% |
req>2000: | ||||||||
atlas | 31.50% | 56.91% | 91007 | 1533609961 | 1,069,984,255 | 1,002,358,500 | 67,625,755 | 106.75% |
cms | 25.62% | 99.72% | 13024 | 1531385351 | 200,557,691 | 280,403,968 | -79,846,277 | 71.52% |
0.00% | 0.00% |
SELECT account, count(*), sum(phoenix_job_table.time_end - phoenix_job_table.time_start) as walltime, sum(round(max_vsize/1024)),sum(substring_index(substring_index(phoenix_job_table.tres_req,',',2),'2=',-1)) as sum_tres_req_mem,sum(round(max_vsize/1024)) - sum(substring_index(substring_index(phoenix_job_table.tres_req,',',2),'2=',-1)) as mem_diffFROM slurm_acct_db.phoenix_step_table,slurm_acct_db.phoenix_job_tableWHERE phoenix_job_table.job_db_inx = phoenix_step_table.job_db_inxand substring_index(substring_index(phoenix_job_table.tres_req,',',2),'2=',-1) > 2000and account in ('atlas', 'cms', 'lhcb')and phoenix_step_table.state = 3group by account
[root@t3nfs02 ~]# zfs list -d1 NAME USED AVAIL REFER MOUNTPOINT data01 1.33T 9.15T 32.0K /zfs/data01 data01/dcache 100G 9.15T 32.0K /zfs/data01/dcache data01/t3nfs01_data01 1.23T 9.15T 32.0K /zfs/data01/t3nfs01_data01 data02 4.33T 6.15T 32.0K /zfs/data02 data02/dcache 100G 6.15T 32.0K /zfs/data02/dcache data02/t3nfs01_data01 4.23T 6.15T 32.0K /zfs/data02/t3nfs01_data01
[root@t3se01 layouts]# grep max /etc/dcache/layouts/t3se01.conf srm.request.max-requests=400 srm.request.put.max-requests=100 srm.request.get.max-inprogress=100 srm.request.copy.max-inprogress=100 srm.request.max-transfers=100
Operations
account | % num jobs | % of wall | count()* | walltime sec | sum(round(max_vsize/1024)) | sum_tres_req_mem | vmem_diff | % |
total: | ||||||||
atlas | 100.00% | 100.00% | 483754 | 40601107936 | 1,830,348,765 | 2,866,590,264 | -1,036,241,499 | x% |
req<=2000: | ||||||||
atlas | x% | x% | 309456 | 13627312862 | 585,601,123 | 579,037,953 | 6,563,170 | x% |
req>2000: | ||||||||
atlas | x% | x% | 174298 | 26973795074 | 1,244,747,642 | 2,287,552,311 | -1,042,804,669 | x% |
0.00% | 0.00% |
SELECT account, count(*), sum(`unibe-lhep_job_table`.time_end - `unibe-lhep_job_table`.time_start) as walltime, sum(round(max_vsize/1024)), sum(round(max_rss/1024)),
sum(substring_index(substring_index(`unibe-lhep_job_table`.tres_req,',',2),'2=',-1)) as sum_tres_req_mem,sum(round(max_vsize/1024)) - sum(substring_index(substring_index(`unibe-lhep_job_table`.tres_req,',',2),'2=',-1)) as vmem_diff,sum(round(max_rss/1024)) - sum(substring_index(substring_index(`unibe-lhep_job_table`.tres_req,',',2),'2=',-1)) as rss_diffFROM `unibe-lhep_step_table`,`unibe-lhep_job_table`WHERE `unibe-lhep_job_table`.job_db_inx = `unibe-lhep_step_table`.job_db_inxand substring_index(substring_index(`unibe-lhep_job_table`.tres_req,',',2),'2=',-1) < 2001and account in ('atlasch001', 'atlas-sw', 'atlasplt002', 'atlasprod002', 'atlasplt003', 'atlasch008', 'atlasch002', 'atlasch009')and `unibe-lhep_step_table`.state = 3group by account;