November 02, 2024, 09:10:33 AM
Welcome,
Guest
Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Home
Help
Search
Login
Register
Anope IRC Services
>
Anope Support
>
1.6.x (Read Only)
>
DB tools
« previous
next »
Pages: [
1
]
Go Down
Print
Author
Topic: DB tools (Read 17732 times)
0 Members and 1 Guest are viewing this topic.
capitaine
Anope User
Offline
Posts: 39
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
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
Posts: 39
(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
Posts: 189
(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
Posts: 39
(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
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
Posts: 39
(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
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
Posts: 39
(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
Print
Pages: [
1
]
Go Up
« previous
next »