Slow database queries after server migration

[ForkZ]

just like ours’ and acritox issue:

Performance issue after upgraded to 1.53.1-42-gc0c3ad2

we opened the slow_sql.log and we found this below: # Time: 2019-07-24T12:01:55.966733Z # User@Host: librenms[librenms] @ [10.1.0.213] Id: 226576 # Query_time: 29.131667 Lock_time: 0.000035 Rows_sent: 1 Rows_examined: 109419476 SET timestamp=1563969715; 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) …

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…