]>
Commit | Line | Data |
---|---|---|
c5293e15 | 1 | --- |
849bdd6f SB |
2 | author: Martinp23 |
3 | date: 2012-04-06 20:33:38+00:00 | |
4 | slug: database-prune | |
5 | title: Database prune | |
c5191f36 EK |
6 | category: community |
7 | category: development | |
8 | category: freenode | |
9 | category: infrastructure | |
10 | category: technical | |
df8e5765 | 11 | imported: yes |
3406dcfa | 12 | robots: noindex |
849bdd6f | 13 | --- |
849bdd6f SB |
14 | Every couple of years, freenode likes to get out the shears and prune the services database. Recently we broke the 80,000 usercount barrier, but the services stats are way ahead: |
15 | ||
797f79ff EK |
16 | > Sat 13:35:46 -OperServ(OperServ@services.)- Registered accounts: 446777<br> |
17 | > Sat 13:35:46 -OperServ(OperServ@services.)- Registered nicknames: 557497<br> | |
18 | > Sat 13:35:47 -OperServ(OperServ@services.)- Registered channels: 141373<br> | |
951245ff EK |
19 | |
20 | We've noticed that nearly half of the accounts shown there haven't been used in | |
21 | the past 6 months! More importantly, over the past few months many people have | |
22 | noticed significant waits when issuing certain services commands - and we'd | |
23 | like to fix that. | |
24 | ||
25 | Hopefully, the [services | |
26 | upgrade](http://blog.freenode.net/2012/04/help-us-test-our-services-upgrade/) | |
27 | should help with this, but we're going to coincide this with a database prune. | |
28 | ||
29 | As of the services upgrade date, any nicks unused for > 150 days are at risk of | |
30 | being dropped. This includes grouped nicks. The easy way to avoid this | |
31 | happening is to use each of your grouped nicks (while identified to the | |
32 | appropriate account) within the next few weeks - and to drop those that you | |
33 | don't need anymore! | |
34 | ||
35 | The testnet (testnet.freenode.net, port 9002. 9003 for SSL) is running a | |
36 | database snapshot from mid-March and will be periodically updated from the | |
37 | production network. This database instance is being regularly pruned - so check | |
38 | there to see how your account will be affected (use /msg nickserv info on both | |
39 | the production and test networks to see the differences). | |
40 | ||
41 | Remember that testnet isn't running a real-time duplicate of the production | |
42 | network, so when you use nicks which would be expired on the production | |
43 | network, they will still appear expired on testnet until the next database | |
44 | snapshot is migrated. Don't worry though - the actual pruning will only occur | |
45 | on the current database at the time of upgrade. | |
46 | ||
47 | On which note.. an upgrade date hasn't been formally fixed but we're aiming for | |
48 | mid-May. | |
49 | ||
50 | Thanks, and don't forget to [test the | |
51 | testnet](http://blog.freenode.net/2012/04/help-us-test-our-services-upgrade/)! |