Performance issue after upgraded to 1.53.1-42-gc0c3ad2

[ForkZ]

seems solved。according to this issue and thx acritox:

Missing MySQL index for table notifications_attribs?

Is LibreNMS perhaps missing an index for the notifications_attribs table? I noticed the webinterface was getting realllly slow (each click 5+ seconds) and had a look, seems the database was busy only counting notifications: select count(*) as aggregate from `notifications` left join `notifications_attribs` on `notifications_attribs`.`notifications_id` = `notifications`.`notifications_id` where (`notifications_attribs`.`key` = 'sticky' and `notifications_attribs`.`value` = 1) or (not exists (se…

using this sql to build the indexes
CREATE INDEX notifications_attribs_user_idx ON notifications_attribs (notifications_id,user_id);
By the way,Do we have a DBA to optimize our sqls and tables？