Anope IRC Services

Anope Support => 1.6.x (Read Only) => Topic started by: capitaine on February 07, 2006, 09:23:04 AM

Title: DB tools
Post 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]
Title:
Post by: SkaterStuff on February 07, 2006, 03:47:09 PM
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.
Title:
Post by: Dave Robson on February 07, 2006, 04:39:19 PM
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]
Title:
Post by: capitaine on February 08, 2006, 10:17:14 PM
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.
Title:
Post by: SkaterStuff on February 09, 2006, 01:55:47 AM
What do you mean when there being del? it slows down?
Title:
Post by: Pieter Bootsma on February 09, 2006, 01:07:26 PM
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.
Title:
Post by: SkaterStuff on February 09, 2006, 05:32:45 PM
ok i never had that problem :)
Title:
Post by: capitaine on February 09, 2006, 09:05:35 PM
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. ;(
Title:
Post by: Dave Robson on February 10, 2006, 08:10:24 AM
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?
Title:
Post by: capitaine on February 10, 2006, 04:59:26 PM
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.
Title:
Post by: Dave Robson on February 10, 2006, 05:08:12 PM
Id try disabling mysql, and see if you still get lag.  I'm willing to bet you wont.
Title:
Post by: capitaine on February 12, 2006, 02:11:30 AM
Ok but at first, I will try an sql update every 4 hours.

Thanks for the help :+