July 24th, 2002

livejournal

Module Name: livejournal
Committed By: bradfitz
Date: Wed Jul 24 08:34:22 UTC 2002

Modified Files:
---------------
livejournal/cgi-bin: ljlib.pl
livejournal/htdocs: talkread.bml

Log Message:
------------
bradfitz:
I asked Avva to add support for a new db role type "cluster[n]lite" to
act like "cluster[n]slave", except with old log2 and talk2... very
heavily used tables, and very small. By putting them on their own machines,
we could get some good cache wins on some very cheap machines.

avva:
Here's an updated patch which implements the lite role. The changes to
ljlib.pl are to get_recent_items() as before, plus implementation of
'onlysubjects' in get_talktext2().

The changes to talkread.bml are: eliminate loading subjects in the
large query which loads all comments, and consider using the lite db
for this query if possible. Then find only those comments that
actually are displayed with just their subjects, when threading, and
load subjects only for those comments, instead of loading subjects for
everything as before. This should speed up talkread.bml on large
comment pages.

I tried to test as exhaustively as possible, with lots of large
threads, mixed display of subject-only and full comments, etc. Seems
to work fine.


To generate a diff of this commit:
cvs rdiff -r1.230 -r1.231 livejournal/cgi-bin/ljlib.pl
http://cvs.livejournal.org/browse.cgi/livejournal/cgi-bin/ljlib.pl.diff?r1=1.230&r2=1.231
cvs rdiff -r1.86 -r1.87 livejournal/htdocs/talkread.bml
http://cvs.livejournal.org/browse.cgi/livejournal/htdocs/talkread.bml.diff?r1=1.86&r2=1.87

livejournal

Module Name: livejournal
Committed By: bradfitz
Date: Wed Jul 24 10:48:03 UTC 2002

Modified Files:
---------------
livejournal/bin/maint: stats.pl

Log Message:
------------
my god did that ever suck. never been awake at 3am or so to see stats
running and killing the databases. fast now.

next up: US states query. but, that one's not as easy to fix...
think i'll just put a machine back on slow role, and make stats
use that if available.


To generate a diff of this commit:
cvs rdiff -r1.22 -r1.23 livejournal/bin/maint/stats.pl
http://cvs.livejournal.org/browse.cgi/livejournal/bin/maint/stats.pl.diff?r1=1.22&r2=1.23

ljcom

Module Name: ljcom
Committed By: bradfitz
Date: Thu Jul 25 00:16:47 UTC 2002

Modified Files:
---------------
ljcom/bin/maint: pay.pl

Log Message:
------------
for some reason, use of purchased codes doesn't always apply payment
to account when it's created. some code path involved when paypal
servers are being lame isn't as robust, or something. in any case,
this query fixes it


To generate a diff of this commit:
cvs rdiff -r1.8 -r1.9 ljcom/bin/maint/pay.pl
http://cvs.livejournal.org/browse.cgi/ljcom/bin/maint/pay.pl.diff?r1=1.8&r2=1.9