9622.net


September 26, 2002 : More about the Error Messages



So today things have been awfully quiet around here, and I haven't had a single error message or doublepost. This leads me to conclude one thing, it's not the size of the site that's the problem--meaning the number of threads in the archive--it's the traffic.
Every time you view or reload a page or post a thread or comment, MT goes back to the database. (or does it? i'm a bit of a novice in this area.) That, I think, is what's triggering the procwatch script. So what's the solution?
(a) we could switch to a MySQL database instead of the berkeley db that is the MT default and which we are currently using. i believe the wonderchicken (or someone) has (negative) experience with this. i don't know if this would work. it would be a shot in the dark.
(b) we could swtich web hosts. i'd hate to have to do this. i've used dreamhost for years and, until now, have been very happy with them. plus, there's no guarantee we wouldn't have the same problems with another host, or that we'd find one as cheap or reliable as dreamhost.
(c) i don't know what (c) is.
Does anyone have any thoughts or ideas?

Posted by jpoulos at September 26, 2002 03:27 PM


People have said these things about that :

I doubt switching to MySQl over berkly makes that much of a difference. What is the max number of users and or processes in the database configuration?

Posted by: romakimmy on September 26, 2002 03:30 PM

I saw we close off entry for new members, and then, make the current members fight until only the best 10 or so of us remain.
This worked out real well down at the ballpit at my local McDonnald's Playland.
There's hardly a line anymore.

Posted by: dong_resin on September 26, 2002 03:33 PM

(assuming, of course that you have access to this information)

Posted by: romakimmy on September 26, 2002 03:36 PM

My monkey bananas cents, errors are not a problem on my end.
Note: if you don't preview first, before posting that is my biggest error guaranteed during busy times.

Posted by: Thomcatspike on September 26, 2002 03:42 PM

Does anyone have any thoughts or ideas?
... just that I love all youze monkeys.

Posted by: whatnot on September 26, 2002 03:44 PM

My monkey bananas cents, errors are not a problem on my end.
Note: if you don't preview first, before posting that is my biggest error guaranteed during busy times.
Ps, it just happened yet this time I was able to back up, in the past no backing, just relogging.

Posted by: Thomcatspike on September 26, 2002 03:44 PM

Obviously the East Coast people should have traffic preference. I mean, that's just the logical decision.

Posted by: witchstone on September 26, 2002 03:48 PM

Here's what the procwatch script looks for and kills.
* user with more than 25 total processes (kill any that puts them over)
* user using more than 75% of processor with multiple processes (kill any that puts them over)
* user using more that 20% of memory with multiple processes (kill any that puts them over)
* one process using more than 50% of processor for longer than 3 minutes (kill process)
* one process using more than 10% of memory for longer than 3 minutes (kill process)

I'm not sure that's the problem, but that's all Dreamhost has given me to go on.
Isn't it possible that MySQL might do its job more efficiently and use less memory and/or processor cycles?
I don't know, though. According to SiteMeter, we're averaging just under 1000 page views per day. That can't possibly be taxing the server that much, can it?

Posted by: jpoulos on September 26, 2002 03:49 PM

Note: the awstats analyzer I run indicates our page views are over 2000 per day.

Posted by: jpoulos on September 26, 2002 03:52 PM

duh. scratch the first comment. I was thinking (if you could call it that) of Apache confg. It's late.
I'm not sure if MySQL is more or less processor intensive than berkley database. Maybe you could search out some benchmarks, but I seem to remember reading somewhere that MySQL was more process intensive than some.

Posted by: romakimmy on September 26, 2002 03:52 PM

"According to SiteMeter, we're averaging just under 1000 page views per day. That can't possibly be taxing the server that much, can it?"
I wouldn't think so, but I guess it depends on what kind of horsepower the server has. My site, running on a dual-300mHz PII Dell server with 256MB of RAM, is an Access '97 back-end with an .ASP front-end and it gets about 4000 hits a day, plus it acts as an SMTP server, an FTP server, and a VisualRoute server, and it's rarely using more than 5% of its available RAM and CPU resources. Access '97 is also a lot less efficient than MySQL or MS SQL, as far as I know.

Posted by: Crash on September 26, 2002 04:03 PM

*looks around timidly*
I knew I shouldn't have let that picture out in the wild. Now jpoulos has it. I'm screwed.

Posted by: eyeballkid on September 26, 2002 04:06 PM

what, the monkey pic? is that yours?

Posted by: jpoulos on September 26, 2002 04:08 PM

(c) i don't know what (c) is.
(c) is we all turn off our computers, give away our material goods, and travel the world in pursuit of spiritual enlightenment.

Posted by: pardon me on September 26, 2002 04:17 PM

That "hurricane" was weak, yo. I'm still with you.
My suggestion is: get one of them computers like Richard Pryor had in Superman 3.

Posted by: ColdChef on September 26, 2002 04:23 PM

We need the WOPR!

Posted by: kafkaesque on September 26, 2002 04:25 PM

"(c) is we all turn off our computers, give away our material goods, and travel the world in pursuit of spiritual enlightenment."
No need, my friend. Let me tell you the story about the time I caddied for the Dalai Lama:
So we finish 18 and he's going to stiff me. So I say, 'Hey, Lama, hey. How about a little something, you know, for the effort?' And he says, 'Oh, uh, there won't be any money. But when you die, on your deathbed, you will receive total consciousness.'
So I've got that going for me, which is nice.

Posted by: Crash on September 26, 2002 04:25 PM

MySQL doc which makes me wonder if MT's querying is tripping the script. but seeing as I'm just learning MySQL (messing around with it now as a matter of fact) and have never touched berkleyDB, I wouldn't have clue as to how to lighten the load.
It's late. I'm blithering like an idiot. Transactional tables suck. I'm going to bed.

Posted by: romakimmy on September 26, 2002 04:26 PM

Wow, it's at times like these that I realize how techno ignorant I really am. The rest of the time I can convince myself that I'm smart.

Posted by: witchstone on September 26, 2002 04:30 PM

You should hang out at my work some time. You'll feel like Brainiac From The Planet Smart-tron in no time.

Posted by: kafkaesque on September 26, 2002 04:37 PM

Crash, I heard about the Lama. Long hitter, right? Flowing robes, grace, bald? Striking.
Gunga galunga.

Posted by: pardon me on September 26, 2002 04:42 PM

We need the WOPR!
No it's beyond that!! We need the IRAC(Internal Retrieval Associative Computer), that wiseass mainframe from Wonder Woman.
side thought=was the IRAC the inspiration for the Imac? or was this just a sly way of saying that Lynda Carter had a nice one?

Posted by: jonmc on September 26, 2002 04:58 PM

Even more than that....
We need....
The Humonga Cowabunga (from Down Undah)!!!!
Now there's a movie reference quiz for ya.

Posted by: kafkaesque on September 26, 2002 05:02 PM

Hmmm, kaf, as the amputee said to the fetishist, I'm stumped.

Posted by: jonmc on September 26, 2002 05:11 PM

Brain. Hurting.

Posted by: anathema on September 26, 2002 05:13 PM

I think you jinxed the MeFi server, lupo. I know you're secretly shedding golden tears of joy.

Posted by: Ufez Jones on September 26, 2002 05:15 PM

While I'm at it I have to tell ya'll how excited I am. My crappy little blog got name checked today by one of my favorite blogs. I know, I know, I'm a total dork. Not a big deal for most, but for me...whoa! Now, if I could only get someone to comment. Thanks for indulging me.

Posted by: anathema on September 26, 2002 05:18 PM

I marry and parent geeks, I ain't one, but I have to concur it is user traffic. When we monkeys are jostling each other to post on a particular thread, evidently we are pushing each other's posts out of alignment.
Honestly, on my end it isn't that bad and i can be patient about it. If you others are having more difficulties, then indeed you must hunt down a solution and drag it back here to the zoo.

Posted by: b****fire on September 26, 2002 05:19 PM

For some reason, when I'm trying to compare a movie to absolute drivel, my mind always grasps for the same film. For example: I watched the Avengers last night, and it was on par with Mannequin 2: On the Move.

Posted by: eyeballkid on September 26, 2002 05:30 PM

I saw Frailty the other night. Not terrible, but not really very good either. Is there a Kim Cattrall movie that expresses that sentiment, Eyeball?

Posted by: kafkaesque on September 26, 2002 05:32 PM

well, I almost have Zimbo done. (the publishing system I've writing off an on for over a year now.. it uses Php and MySQL...) Ya want I should finish it? then we'll have noone to blame but me.

Posted by: tj on September 26, 2002 05:32 PM

As I recall, you gave us lip for not knowing your Wim Wenders' movie....It seems there's a bit of a double standard here. I mean, Annette and Frankie vs. German road flicks? How can we win? I aspire to be both learned and trashy, lord knows I do, but really. I just can't know every obscure reference to every obscure movie computer. I've got HAL covered; that's got to be good enough. It's just got to be!

Posted by: readymade on September 26, 2002 05:32 PM

Put in my vote for it's NOT traffic-related.
We went bonkers some time back with *verb* posts on 00722, and there wasn't a single glitch in that whole humongous thread, even when we had eight or nine posts all going up with the same timestamp, and were loading nine hundred comments with each page view.
Nay, something more sinister is afoot, I fear.

Posted by: Crash on September 26, 2002 05:35 PM

Actually, there is no computer in Back To The Beach. Just The Humonga Cowabunga From Down Undah, which is, like, a giant wave or something.
And, if you really think about it, part of the subtext of many of the best representatives of the New German Cinema movement was that the culture of the West is invading European consciousness. In a sense, the beach movie genre is very much part of this intellectual colonization.

Posted by: kafkaesque on September 26, 2002 05:40 PM

I doubt it's traffic related too... I'm just wondering if all th MT sites happen to be residing on the boxen and it's getting all, ya know, uppity.

Posted by: tj on September 26, 2002 05:40 PM

I doubt it's traffic related too... I'm just wondering if all th MT sites happen to be residing on the boxen and it's getting all, ya know, uppity.
heh, it did it when I posted this

Posted by: tj on September 26, 2002 05:41 PM

wow, i think i offended the server, it's not letting me post my followup

Posted by: tj on September 26, 2002 05:42 PM

that's right bitch

Posted by: the server on September 26, 2002 05:43 PM

On preview...what kaf said. @-)

Posted by: anathema on September 26, 2002 05:43 PM

I hate to correct you on the subject of film, k, but Kim Cattrell didn't appear in the second Mannequin movie. Mannequin the second was cheeze-queen Kirsty Swanson.

Posted by: eyeballkid on September 26, 2002 05:48 PM

Well, I have no clue. (shut up in the peanut gallery, shut up, I say!)
By the way, not that any of you care, I've snuck back on Big Blue. Been there quite a while, too.

Posted by: b****fire on September 26, 2002 05:51 PM

This is pretty important, I'm going to make a call.

Posted by: anathema on September 26, 2002 05:52 PM

*being vewy vewy quiet*

Posted by: anathema on September 26, 2002 05:57 PM

b-fire, I noticed.. i also tipped off the scooby squad and they're stumped.. congrats

Posted by: tj on September 26, 2002 06:03 PM

a couple of things:
- I did not actually see Mannequin 2.
- Bunny, why even bother?

Posted by: kafkaesque on September 26, 2002 06:05 PM

I did not actually see Mannequin 2
The New German Cinema has already won.

Posted by: liam on September 26, 2002 06:15 PM

By the way, I wasn't really being serious about Back To The Beach and New German Cinema, just so everyone doesn't think I am a film snob.

Posted by: kafkaesque on September 26, 2002 06:21 PM

Actually, I am a fan of New German Cinema and it makes for a lonely existence, fated forever to wander through jagged landscapes of stark imagery, murky philosophical utterances, and very, very long takes. Of course, I can always cheer myself up with a Straub/Huillet movie.

Posted by: liam on September 26, 2002 06:40 PM

Liam is my friend.
Would you care to take a road trip?

Posted by: kafkaesque on September 26, 2002 06:42 PM

This is not exactly my area of expertise.
Have you tried lopping parts of the database off with a chainsaw? It works with trees.

Posted by: MarsCrash on September 26, 2002 07:17 PM

Kaf, let me get my big black overcoat and my shades, and I'm ready to roll in search of meaning, while the tech monkeys work on the practical stuff.
Incidentally, in 1998 I went to a small film festival in Finnish Lapland. Two of the other guests were Wim Wenders and Robby Muller. They were both happy and dedicated partyers.

Posted by: liam on September 26, 2002 07:26 PM

Mannequin. Oh, lord, the Way Back Machine is busy today.
Alas, I admit to never seeing the sequel.

Posted by: adam on September 26, 2002 07:38 PM

liam, you may be 9622's answer to Phileas Fogg, dude. All I know of Lapland that that lovely dance they call the lap...
*ahem*
although I do remember my buddy Mike the Magazine Guy bringing over this weird mid 60's looking scifi video in which an outpost in Lapland figured heavily...
I was a tad drubk..details are fuzzy.

Posted by: jonmc on September 26, 2002 07:47 PM

What? The Woppin' Cow that Bungeed from Ma Udders isn't a computer? I'm ashamed that I didn't know the reference one way or another, since I pride myself on having seen a lot of trashy films (and enjoying them). But since I once aspired to film snobbery (film school and everything!) here's a still from my snobbery days.

Posted by: readymade on September 26, 2002 07:47 PM

Uh, this may be a dumb question, but have you asked Ben? The support forums are superuseful, and he's always quick to try to help, even with non-paying MT users....

Posted by: stavrosthewonderchicken on September 26, 2002 07:55 PM

Well I once discussed Moses und Aaron for four hours with Straub and Huillet in 1976 and am sure it's not traffic-related.

Posted by: Miguel on September 26, 2002 08:05 PM

Lapland makes the most of its large reindeer population - reindeer boots, reindeer coats, reindeer suits, reindeer stews and reindeer burgers. The Laps are also very keen on saunas and vodka, often combined, which help to deal with the dayless winters and nightless summers.

Posted by: liam on September 26, 2002 09:10 PM

Kafkaesque, It's a little late now, but I totally got "the Cowabunga from Down Unda." I am a freak for Frankie and Annette.
When drubk, I find myself moaning, "Why-O Why-O Why-O did I ever leave Ohio?"

Posted by: ColdChef on September 26, 2002 09:25 PM

Does anyone have any thoughts or ideas?
The sum of the square roots of any two sides of an isosceles triangle is equal to the square root of the remaining side.
Oh joy, rapture! I've got a brain!

Posted by: tizzie on September 26, 2002 09:57 PM

Oh joy, rapture! I've got a brain!
So do I. And a body, too. They're in the trunk of my car, ya wanna see 'em??

Posted by: jonmc on September 26, 2002 10:08 PM

If figuring out the sides of an isoceles triangle is the only way I have of reassuring myself of having a brain, I am so screwed. *looks into chest to see if I find a heart in this tin shell*
No-one to play "guess my film still?" I know I'm outta date, but I was sure Kafkaesque would get it. Anyone? Anyone?
*crickets*

Posted by: readymade on September 26, 2002 10:30 PM

You got me, readymade. Dunno.

Posted by: kafkaesque on September 26, 2002 10:37 PM

A close friend of mine has a softball (yes, a softball) signed by Werner Herzog. I swear. I know nothing about this server thing, but I do have a convoluted question/statement/whatever. So I post, and get the error. Then I quit my browser, the whole deal, and then get back to Monkey Land and the post is not there and there is no evidence that it even exists anymore. So I do the little pushy-posty thing and it finally goes up. The odd thing is that TCS (yeah, I know) says the post has been up for like 5 minutes already. So is this the case with everyone? You just can't see your own post? Should I have my head examined for basing this on info from TCS? No offense thom, it's just that, well...sometimes...shit ,you know.

Posted by: anathema on September 26, 2002 10:44 PM

"La Jetee" by Chris Marker, inspiration for "Twelve Monkeys." Obscure inside joke. Too obscure, I guess. Sorry.
How 'bout that server problem?

Posted by: readymade on September 26, 2002 10:58 PM

Re: thom's observations, anathema's apprehensions, and server errors.
Yes.
Re: the theory about multiple users posting at the same time cause the errors.
No.
Late last night, I know I was the only one rattling on about Holy Grail quotes over at the cult-thread-within-the-cult-thread. I posted a comment, as an homage to ColdChef (who had posted another quote, which I was thinking of using) and got the error. I closed my browser, and reopened it. I went back to the thread. I read some more, and decided NOT to re-post my original comment, and instead went looking for the script to the King Brian scene. I found it within, oh, about 15 minutes, and posted that new comment, with a link. Then, and only then, did my earlier comment appear on my browser (along with the new one after it).
Doo-dee-doo-doo, doo-dee-doo-doo ...

Posted by: yhbc on September 26, 2002 11:25 PM

commish, do you by chance have something to do with this?
La Jette is overrated. I'll take Sans Soleil over it any day.

Posted by: anathema on September 26, 2002 11:33 PM

But was the vapor post (vapost) only invisible to you? That's the other part of my question. Is that even possible even after quiting the browser? *eep?*

Posted by: anathema on September 26, 2002 11:39 PM

And Marker was at the Midnight Sun Festival that year, too! He was very, very shy.
I don't suppose we could send a monkey with a powerful imagination into the future to get help with the server problem, like in "La Jeteé"?

Posted by: liam on September 26, 2002 11:44 PM

I plead not guilty to the charge of amassing the a cappella armada. At Yale.
The vapost wasn't visible to me when I got back into the site and the thread, but then there was no one else there to see it, of course, so I don't know if it was visible to anyone else. All I know is that when I posted my second comment, well, it also hung up. That's when I did the "Post, damn thee" thingee, and all three showed up at once.

Posted by: yhbc on September 26, 2002 11:45 PM

Witches.

Posted by: ColdChef on September 27, 2002 12:00 AM

BUUURN THEM ALREADY!!!!

Posted by: yhbc on September 27, 2002 12:32 AM

F*ck. That time, I had a basic "BUUURN THEM!!!" posted, which got the error message, and it didn't show up after I did the second one with the "ALREADY", even though I did the same damn thing I did the other night.
Obviously, I'm worrying about this too much.
Good night.

Posted by: yhbc on September 27, 2002 12:34 AM

Yeah....when my "disclosure" post didn't manifest, I thought better of it and decided not to repost. I checked back a time or two-still wasn't there, so I got off the 'puter and went my merry way.
I show up this morning-and there it is.
humph!

Posted by: b****fire on September 27, 2002 07:23 AM

I think the only equivalent to seeing Mannequin 2 would be Weekend at Bernie's 2. Of course I'm guessing, since I saw neither of these films. Although my 8th grade self greatly enjoyed the originals (yeah, she's a mannequin! yeah, he's dead and we're pretending he's alive!), somewhere, deep in my heart of hearts, I knew that there would be no reason, besides the complete squandering of hard earned allowance for absolutely no gratification in return, to see the sequels.
But I can see how they could be used as a trusty measuring tool, though, EBK.

Posted by: witchstone on September 27, 2002 10:24 AM

Tizzie: that's a right triangle.

Posted by: jpoulos on September 27, 2002 10:25 AM

9622.net: I once discussed Moses und Aaron for four hours with Straub and Huillet in 1976 and am sure it's not traffic-related.

Posted by: jpoulos on September 27, 2002 10:26 AM

I use the Streets Of San Francisco meter of measurement.
How Quinn Martin is it? Does it have Carl Malden in it? Pimps? Anyone drive into a lot of cardboard boxes? And so forth.
12 Monkeys rated a 6.8 on the SOSF scale, while carrots rate a dismal .2.

Posted by: dong_resin on September 27, 2002 11:26 AM

In the later episodes, Michael Douglas's hair got an Executive Producer credit.

Posted by: jpoulos on September 27, 2002 11:28 AM

"Okay, your motivation is that you just ate 14 bran muffins and these barrels are going nowhere in the mid-morning traffic. Action!"

Posted by: dong_resin on September 27, 2002 11:53 AM

Oh. My. God. That hair shoulda had a show of its own. "BackComb: Revenge of the Teased"

Posted by: tizzie on September 27, 2002 11:53 AM

"You like gladiator movies?"

Posted by: dong_resin on September 27, 2002 11:57 AM

Woah! I never noticed how much Emilio Estevez looks like Michael Douglas before.

Posted by: witchstone on September 27, 2002 12:06 PM

Post, dammit!

Posted by: witchstone on September 27, 2002 12:07 PM

Miguel Sheen?
can't remember who I'm stealing that joke from...

Posted by: tizzie on September 27, 2002 12:11 PM

The Miguel Sheen is the boozy sweat that collects after a heavy night of slumming with the locals.

Posted by: kafka in a white wine sauce on September 27, 2002 12:31 PM

Miguel Sheen?
can't remember who I'm stealing that joke from...

from me! yay!
damn, i guess my fifteen minutes of fame are all used up now. and i was so looking forward to the E True Hollywood Story about my drug abuse on the set of Showgirls Getting Their GEDs.

Posted by: witchstone on September 27, 2002 12:39 PM

You get used to it.

Posted by: dong_resin on September 27, 2002 12:44 PM

Showgirls Getting Their GEDs?? You were in that?? Oh, witchstone, I love that movie. It changed my life. It made me a better person.
I'm sorry I stole your joke - I only did it because I wanna be like you!

Posted by: tizzie on September 27, 2002 12:51 PM

Don't we all. I've gotta confess I've begun dressing like her.

Posted by: jpoulos on September 27, 2002 01:06 PM

no apology necessary. i want all jokes to be involve someone in the sheen/estevez family.

Posted by: witchstone on September 27, 2002 01:26 PM

"be involve?"
uh oh.

Posted by: witchstone on September 27, 2002 01:34 PM

post, dammit.

Posted by: witchstone on September 27, 2002 01:35 PM

Listen, dammit, you'll do what I say!

Posted by: dammit's mom on September 27, 2002 02:08 PM

ooo, i was on the same wavelength with someone.

Posted by: witchstone on September 27, 2002 02:10 PM

God dammit!

Posted by: It's starting on September 27, 2002 02:10 PM

ooo, i was on the same wavelength with someone.
ooo, it was me! dammit!

Posted by: tizzie on September 27, 2002 02:13 PM

see, even I can't control it

Posted by: god on September 27, 2002 02:38 PM

I Double Dog Damn Thee, Like, For All Eternity And In Perpetuity And All That!
You're So Dead.

Posted by: God on September 27, 2002 02:41 PM

It has begun!
Choose your destiny.

Posted by: Mortal Kombat on September 27, 2002 02:41 PM

I can so totally kick Zeus' ass

Posted by: Raiden on September 27, 2002 02:47 PM

bring it, bitch.

Posted by: Zeus on September 27, 2002 02:59 PM

Dude, you'd seem a lot tougher if changed back from being a swan, you damn walking hormone.

Posted by: Raiden on September 27, 2002 03:36 PM

Oh yeah, nice dress by the way.

Posted by: Raiden on September 27, 2002 03:37 PM

*humps a tree*

Posted by: Zeus on September 27, 2002 03:38 PM

We may have to throw him out of the club if he keeps this up.

Posted by: Thor on September 27, 2002 03:39 PM

By Me! Cut that out!

Posted by: Jove on September 27, 2002 03:40 PM
Why not join in and say something too?

A note about posting images:

We encourage users to post images, especially those hilarous pics of monkeys wearing dresses or programming for Linux. But posting images that reside on someone else's server is considered by many to be bandwidth theft. Our thoughts on the matter, along with some solutions to the problem, can be found here. Thanks.

In an effort to help eliminate spam (and to preserve the sanity of the 9622 Volunteer Simian Spam-Cop Brigade) all threads older than 30 days will now be closed to comments.

Name:


Email Address:


URL:


Comments:


Remember me?