Anope IRC Services
Anope Support => 1.6.x (Read Only) => Topic started by: capitaine on February 07, 2006, 09:23:04 AM
-
Hi everybody,
I have my services slowing down, and I think it's due to the nick.db which is 4.7 Mb sized.
Are there any tools to rebuild or unfragment .db, or purge unused nicks ?
[Edite le 7-2-2006 par capitaine]
-
Yes you have to open up the services config and set the nicks to expire after like 20 days or something if not used.. just like the channel.
-
a 4.7 meg nick.db really shouldnt be slowing services down much at all... assuming you dont have a redicuously short UpdateTimeout setting.
[Edited on 7-2-2006 by Rob]
-
I have 90 days nicks expiration and
UpdateTimeout 30m
ExpireTimeout 30m
ReadTimeout 5s
It doesn't get slow all the time, it seems it is when expired nicks are deleted.
I got to check this anyway.
-
What do you mean when there being del? it slows down?
-
It has to check all nicks to see if they have to expire. I'm not sure how many nicks you have, but with a 4.7 MB nick.db file it's only a few nicks. If it is a tad slow every 30 minutes i don't forsee huge problems tho, unless it actually hangs for a minute.
-
ok i never had that problem :)
-
According to anope_ns_alias, we have 26742 nicks.
It hangs more than 120 secondes.
I had to extend the ping timeout to 180 sec on Unreal, to prevent the services disconnect. ;(
-
Ah i should have guessed you were using mysql - it will cause lag issues on update/expire/just about anything - im assuming its a localhost mysql connection?
-
Yes it's a local mysql. Everything is on the same host.
Do you think it's due to the whole sql db updated every 30 min ?
I will tune the config a bit.
-
Id try disabling mysql, and see if you still get lag. I'm willing to bet you wont.
-
Ok but at first, I will try an sql update every 4 hours.
Thanks for the help :+