Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: DB tools  (Read 9829 times)

0 Members and 1 Guest are viewing this topic.

capitaine

  • Anope User
  • Offline Offline
  • Posts: 39
    • http://www.coolsmile.net
DB tools
« 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]
Logged

SkaterStuff

  • Guest
(No subject)
« Reply #1 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.
Logged

Dave Robson

  • Team
  • *
  • Offline Offline
  • Posts: 357
(No subject)
« Reply #2 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]
Logged

capitaine

  • Anope User
  • Offline Offline
  • Posts: 39
    • http://www.coolsmile.net
(No subject)
« Reply #3 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.
Logged

SkaterStuff

  • Guest
(No subject)
« Reply #4 on: February 09, 2006, 01:55:47 AM »

What do you mean when there being del? it slows down?
Logged

Pieter Bootsma

  • Team
  • *
  • Offline Offline
  • Posts: 189
    • http://geniusdex.net/
(No subject)
« Reply #5 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.
Logged

SkaterStuff

  • Guest
(No subject)
« Reply #6 on: February 09, 2006, 05:32:45 PM »

ok i never had that problem :)
Logged

capitaine

  • Anope User
  • Offline Offline
  • Posts: 39
    • http://www.coolsmile.net
(No subject)
« Reply #7 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. ;(
Logged

Dave Robson

  • Team
  • *
  • Offline Offline
  • Posts: 357
(No subject)
« Reply #8 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?
Logged

capitaine

  • Anope User
  • Offline Offline
  • Posts: 39
    • http://www.coolsmile.net
(No subject)
« Reply #9 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.
Logged

Dave Robson

  • Team
  • *
  • Offline Offline
  • Posts: 357
(No subject)
« Reply #10 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.
Logged

capitaine

  • Anope User
  • Offline Offline
  • Posts: 39
    • http://www.coolsmile.net
(No subject)
« Reply #11 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 :+
Logged
Pages: [1]   Go Up