content/news/2012-04-06-database-prune.md

   1 ---
   2 author: Martinp23
   3 date: 2012-04-06 20:33:38+00:00
   4 slug: database-prune
   5 title: Database prune
   6 category: community
   7 category: development
   8 category: freenode
   9 category: infrastructure
  10 category: technical
  11 imported: yes
  12 robots: noindex
  13 ---
  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
  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>
  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/)!