Network WikkedWire disappeared

Willaim · Lurker Joined: 27 Jun 2003 Posts: 235 Location: IRC

I'm just curious as to why my network disappeared from SearchIRC.

It's no longer accessible via http://www.searchirc.com/network/WikkedWire

I thought you didn't delete networks? Did it somehow get 'purged'?

Jason · Posted: Apr 21, 2008 11:58am Post subject:

We do not remove networks, but we did have a server crash a few days ago, and the db got corrupted. It looks like your network record was damaged when the db was recovered.

If you resubmit it, I can approve it so it's back.

Willaim · Lurker Joined: 27 Jun 2003 Posts: 235 Location: IRC

Ah, ok

Done.

Thanks.

PingBad · Guru Joined: 05 Feb 2005 Posts: 2026 Location: New Zealand

Jason · Posted: Apr 22, 2008 5:17pm Post subject:

myisam

PingBad · Guru Joined: 05 Feb 2005 Posts: 2026 Location: New Zealand

ever considered innodb?

Jason · Posted: Apr 22, 2008 8:50pm Post subject:

sure. I use it all the time.

PingBad · Guru Joined: 05 Feb 2005 Posts: 2026 Location: New Zealand

hrm, just a suggestion, but why not convert your network table from myisam to innodb? Personal experience (and recommendations from database intensive projects such as MediaWiki) show that InnoDB tables are much less susceptible to corruption.

dotslasher · Newbie Joined: 03 Apr 2004 Posts: 81 Location: Belgium

my network: StaticBox got removed as well. (irc dot staticbox dot net)

ButtaKnife · none Joined: 26 Apr 2005 Posts: 26

dotslasher · Newbie Joined: 03 Apr 2004 Posts: 81 Location: Belgium

no sorry, that's nenolod who does that every single night Razz

Jason · Posted: Apr 23, 2008 4:29pm Post subject:

Any network that is missing needs to be resubmitted. :(

If the server crashes and there are db issues, I restore from the last good database backup. With this situation, I wasn't aware of the problem till it was too far gone - going to a backup would mean losing recent data.

SearchIRC has been running for almost 10 years now, and this is not something we deal with often.