Death is your art. You make it with your hands day after day. That final gasp, that look of peace. And part of you is desperate to know: What's it like? Where does it lead you? And now you see, that's the secret. Not the punch you didn't throw or the kicks you didn't land. She really wanted it. Every Slayer has a death wish. Even you.

Spike ,'Conversations with Dead People'


Buffistas Building a Better Board  

Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.

To-do list


§ ita § - Aug 21, 2003 7:56:09 am PDT #4720 of 10000
Well not canonically, no, but this is transformative fiction.

It might mean that Bitches could be housed on a separate server from Natter and the show threads on another - cutting the load on each individual server a lot.

If they use different databases, then the shared info (like users) is a problem.

If they use the same database, then nothing's been gained.


Sean K - Aug 21, 2003 8:08:14 am PDT #4721 of 10000
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty

If they use different databases, then the shared info (like users) is a problem.

How much of a problem? More hassle than it's worth? (I have a feeling the answer is "yes," but I thought it was worth asking)


§ ita § - Aug 21, 2003 8:11:34 am PDT #4722 of 10000
Well not canonically, no, but this is transformative fiction.

Like you'd have to have two user IDs and log in twice, and there'd be no direct connection between the two sites, at first blush.

It's possible the site hosts will allow two domains to connect to the same table, but I don't know how sound a solution that would be.


Kristen - Aug 21, 2003 8:21:18 am PDT #4723 of 10000

ita, I'll pass that question along to Steven with some others I have for him.

It's possible the site hosts will allow two domains to connect to the same table, but I don't know how sound a solution that would be.

Generally speaking, this is not allowed by webhosts.

I had other things that I was going to say but I think they've been blocked by this headache I have behind my eyes.


Typo Boy - Aug 21, 2003 8:27:50 am PDT #4724 of 10000
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

I think in the article they ended up with a wait_timeout of 60 seconds, not 30. (30 being the minimum they could get away with).


§ ita § - Aug 21, 2003 8:33:19 am PDT #4725 of 10000
Well not canonically, no, but this is transformative fiction.

Which article is this, TB? I must have missed a post.


Jon B. - Aug 21, 2003 8:36:21 am PDT #4726 of 10000
A turkey in every toilet -- only in America!

This article, ita. Rob linked to it upthread.


Rob - Aug 21, 2003 8:36:49 am PDT #4727 of 10000

Yep, and after considering it while I was in the shower I think that something like five minutes would work for Buffistas. I can't believe the system leaks hundreds of connections in a few minutes, or it would be bringing the server down all the time.


§ ita § - Aug 21, 2003 8:56:04 am PDT #4728 of 10000
Well not canonically, no, but this is transformative fiction.

Ah. Okay. I did miss that. Kristen's pitching it, so we'll see.


Karl - Aug 21, 2003 4:29:16 pm PDT #4729 of 10000
I adore all you motherfuckers so much -- PMM.

If Steve does wind up changing wait_timeout, he'll need to make sure server threads get cached properly (they don't by default). This blog entry by one of Yahoo's database masters has more details.

While I'm here: Kristen, I humbly apologise for not getting back to you about CVS a while ago; my life had something of a meltdown. ita, did you get my mail a few weeks ago about CVS and the developer list? I'll take down my server if Kristen's got our needs covered.

Also, insent to ita re: developer list and SQL.