[kea-dev] Trac changes, performance increase

Tomek Mrugalski tomasz at isc.org
Wed Nov 4 04:16:12 UTC 2015


On 04/11/15 01:58, Jeremy C. Reed wrote:
> In the trac.ini [ticket] section, I changed restrict_owner from true to 
> false. Great speed up. It is a known Trac issue with multiple Trac 
> tickets, including http://trac.edgewall.org/ticket/4245 The problem is 
> related to have too many user accounts and its inefficiency with 
> checking privileges for each. (I have no idea why it checks these 
> privileges for the slow HTML reports but not for the fast RSS reports.)
Fantastic news!

On behalf on the whole team, I'd like wholeheartedly thank you for this
great feat. It was really unbearable to use trac. Finally, we can start
using this essential tool without pulling our hairs out.

> My plan is to somehow see if the Trac users have legitimate Kea wiki or 
> Kea ticket contributions. If not, remove the bogus user account. Once we 
> get the list of users down to some small amount (I guess less than 30 
> legitimate), we can try to renable the restrict_owner=true.
There are 6339 accounts currently. I think maybe 50 of them are
legitimate, the rest is spam. I think I'm most familiar with the
accounts, so I'll go through them and will remove the spam ones.

> We have several other Trac changes to consider (like new plugins), but 
> we were waiting for the Trac performance to be solved first. Maybe in 
> two weeks we can verify this change is okay and then start with those 
> tasks then.
Now that the performance issue is addressed, in my opinion the next step
should be to stop new spam accounts from appearing. I recall that 6 or
maybe 9 months ago we had slightly over 1000 accounts. It now grew to
over 6000. The newest accounts I saw are 15 hours old. Getting rid of
them would be pointless effort, if the new ones are being created by
spam bots.

Thank you again for solving this performance issue. Great work!
Tomek



More information about the kea-dev mailing list