Website performance - Apr. 12 (PDT) update

[dwell]

Hello everyone, here is the update from the weekend. I will cover the 2 points from the previous lj_maintenance posts so we can close the loop on them.

Speed up the way our user information is pulled out of our databases.There were 2 more emergency patches released this weekend that have been helping the situation. We will continue to look at

Comments

[alby_lion]

As time goes on and demands increase, are there any plans to delete long-abandoned journals (those without a login for three-to-five years or more)?

[darkblysse]

I'd like to know this as well.

There's journals out there (one that I wanted for my username, for example) that were taken in 2000/2001/2002 and have no entries, friends, or comments posted at all. I'd like to know if there's a plan to maybe purge some of those accounts in the future.

[alby_lion]

Exactly.

I also have a few people who only registered accounts to stalk me then gave up when it was all friends-only. But it's a bit of a waste to be "friends of" these journals when they've never had a post.

[icequeen64]

I'd also like to know this, because my very first LJ (shiva64) I ever had was hacked into years ago, and I would like it deleted. I don't know french, and this was when I was stupid about password security. :|

[hellsop]

Clearing dead journals won't help much. They don't add to the transaction rate load on the databases, once they're indexed they only make the caches marginally larger, and obviously they don't grow at a rate anywhere near the rate that active journals do. tiny gain for the remote chance of really annoying someone who decides to come back.

[duskwuff]

Almost certainly not. LJ has consistently stated that journals will not be deleted for inactivity ( FAQ 9, FAQ 127), and no significant load is generated by journals that are not being viewed.

[alby_lion]

Yeah, but I was just wondering if that would ever change. I'd be right pissed off if I came back five years later and found my journal missing. But there are quite a few junk journals. Removing those wouldn't help with the current situation, but over time, who knows? But oh well. Guess another server is the more likely outcome then.

[duskwuff]

Disks get cheaper all the time.

[leticia]

Seriously, this. My desired and accustomed username has been tied up with a two-post camwhore shill pointing to a long-dead porn site forever and ever ago.

A journal that hasn't been updated since 2000? I mean, seriously?