Mysql performance on boss is terrible!
Since the 12.2 upgrade i have noticed a lot of very slow loading web pages. Looking at the mysql slow queries log there are an enormous number of ones like this, that should have been close to instant. Its bothering me enough that I am going to have to dig into it.
# Time: 2021-08-20T19:35:18.826539Z
# User@Host: skip-grants user[instantiate.php] @ localhost [] Id: 31469255
# Query_time: 5.324131 Lock_time: 0.002438 Rows_sent: 1152 Rows_examined: 29629
SET timestamp=1629488118;
select p.uuid,p.name,p.pid,v.creator,p.profileid, p.usecount,f.marked from apt_profiles as p left join apt_profile_versions as v on v.profileid=p.profileid and v.version=p.version left join group_membership as g on g.uid_idx='926619' and g.pid_idx=v.pid_idx and g.pid_idx=g.gid_idx left join apt_profile_favorites as f on f.profileid=p.profileid and f.uid_idx='926619' where locked is null and p.disabled=0 and v.disabled=0 and (p.public=1 or p.shared=1 or v.creator_idx='926619' or g.uid_idx is not null );