Brad Fitzpatrick (bradfitz) wrote in lj_nifty,
Brad Fitzpatrick
bradfitz
lj_nifty

Last unclustered post

I couldn't think where to post this, but then I remembered lj_nifty!

Last unclustered post:
http://www.livejournal.com/talkread.bml?itemid=25192284
(last unclustered comment was talkid=33436284)

Add one to that URL and it won't work.

Other interesting fact: the main database is now only 4.3 GB. When everything was unclustered, it was up to over 50 GB.

More interesting: the table that maps old URLs to new URLs (just the numbers, actually, not the URLs) is 2.7 GB of that 4.3 GB. But now that it's no longer being populated, I can do some things to the table to make it smaller. But even 4.3 GB is small enough to run all in memory.

Other interesting thing: the data that the directory needs is only 400 MB, which can easily easily run in memory, on potentially many different machines. (current project. sssh. :P)
Subscribe

  • friends history

    many years ago, we had the marnanel joule that kept track of our friends history. but it went away around 2011. in fact a lot of livejournal has…

  • ArtLJ

    I was screwing around with custom styles earlier when I stumbled across artlj ( Translations available at Google and Microsoft). It…

  • No more grey comment button!

    Last night I hacked together a Greasemonkey script so that anyone affected by the grey comment button problem can post a comment. Any comments or…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 4 comments