[irc/freenode/web-7.0.git] / content / news / 2012-04-06-database-prune.md

author: Martinp23
date: 2012-04-06 20:33:38+00:00
slug: database-prune
title: Database prune
category: community
category: development
category: freenode
category: infrastructure
category: technical
---
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:


<blockquote>Sat 13:35:46 -OperServ(OperServ@services.)- Registered accounts: 446777
Sat 13:35:46 -OperServ(OperServ@services.)- Registered nicknames: 557497
Sat 13:35:47 -OperServ(OperServ@services.)- Registered channels: 141373</blockquote>


We've noticed that nearly half of the accounts shown there haven't been used in the past 6 months! More importantly, over the past few months many people have noticed significant waits when issuing certain services commands - and we'd like to fix that.

Hopefully, the [services upgrade](http://blog.freenode.net/2012/04/help-us-test-our-services-upgrade/) should help with this, but we're going to coincide this with a database prune.

As of the services upgrade date, any nicks unused for > 150 days are at risk of being dropped. This includes grouped nicks. The easy way to avoid this happening is to use each of your grouped nicks (while identified to the appropriate account) within the next few weeks - and to drop those that you don't need anymore!

The testnet (testnet.freenode.net, port 9002. 9003 for SSL) is running a database snapshot from mid-March and will be periodically updated from the production network. This database instance is being regularly pruned - so check there to see how your account will be affected (use /msg nickserv info on both the production and test networks to see the differences).

Remember that testnet isn't running a real-time duplicate of the production network, so when you use nicks which would be expired on the production network, they will still appear expired on testnet until the next database snapshot is migrated. Don't worry though - the actual pruning will only occur on the current database at the time of upgrade.

On which note.. an upgrade date hasn't been formally fixed but we're aiming for mid-May.

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