search

dmwm / PHEDEX

CMS data-placement suite
8 stars 18 forks source link

PerfMonitor agent: slow t_status_block_dest query #1051

Closed nikmagini closed 7 years ago

nikmagini commented 7 years ago

The PerfMonitor agent had performance issues recently:

https://ggus.eu/?mode=ticket_info&ticket_id=124312

Tracked down to the following SQL used to update the t_status_block_dest table:

https://github.com/dmwm/PHEDEX/blob/4ffa9024e63948b6c6ac6b49a5bf50cb0f15130d/perl_lib/PHEDEX/Monitoring/PerfMonitor/Agent.pm#L63-L69

The problem is the join to t_dps_file. In this case, the same information is also available in t_dps_block. Fix committed:

https://github.com/dmwm/PHEDEX/commit/ef7fe6f94e11af6b3ce4f92768f0bee73bbf2cd4

Patch applied manually to Prod agents on 2016-10-07

Adding issue as reminder to include in 4.2.0 release.

nikmagini commented 7 years ago

Released in 4.2.0 - closing