Toonbots message board: Rumors of my death

toonbots home ] [ message board archive ] [ the toon-o-matic software ] [ forum ]
Michael Sat Feb 9 16:46:38 2002
Rumors of my death

They're exaggerated!

Anyway, last Sunday one of the server processes on my box (yes, the one which serves up, my most stable customer contract, at six years and counting) started ... not answering. I'd restart it, and it would go for an hour or so, then ... not answer any more. Since I'd just made some changes, I figured that was it. It wasn't (undid all of them and it still did that). So there were a couple of getting-bigger-and-maybe-pushing-it kinds of numbers here and there on the machine. Fixed them all. Didn't help.

By this point, two days had passed, with me restarting the server process every hour or so. The restart takes five minutes or so, so I didn't want to do it unless the process had actually locked up (like on a timer or something). Every time I thought I'd had it fixed, and Monday night I even was completely convinced and slept ten hours(!) -- only to get a somewhat apologetic call from the customer the next morning that, no, it wasn't fixed.

So I bit the bullet. The site (as is Vivtek) was running on AOLserver 2.1 against an Illustra database. This was cutting-edge technology in 1994, and when I got to it in late 1996, it was still pretty damned cutting edge. But AOLserver has moved on, to 3.4.2 at last count, and of course Illustra, while feature-laden, was never something you could tune or troubleshoot very well. They got bought out by Informix in '99 or so, and good riddance to'em.

My plan had been to upgrade the site to AOL3.x anyway, and switch to MySQL. Needless to say, I was anticipating this move with some serious trepidation, as there is a *lot* of code I would have to change .... but the server made the decision for me. And now it's almost done. I haven't slept much this week, but by GOD I can't let my own server push me around.

Fortunately, I had another server set up with Solaris 2.8 Intel, running AOLserver 3.2 -- that much worked. And I follow the lists, so I had a nice lead on a MySQL driver, and I'd been putzing around with MySQL anyway in preparation for a database switch.

So anyway, at Techspex we'd been wrestling with unbelievable performance problems -- due to organizational difficulties, we had been unable to address them. Now we had no choice. And now, the database queries I've already converted are ticking along at sub-second response when they used to take upwards of 10 seconds, some of them. It's flat-out eerie.

I may not have slept this week, and my customer may have been reeeeeally nervous, but damn are they happy now! MySQL rocks. Just wanted to share that with y'all. Emsworth, Tirdun, this explains why I haven't even managed to get your contributed episodes up. I had no time to do *anything* but address these issues. And now I'm going to cook me up a big batch of chili.

mouse Sun Feb 10 13:19:41 2002
Re: Rumors of my death

> They're exaggerated!

glad to hear it! ....and here i was worrying you just didn't love us any more.

> Anyway, last Sunday one of the server processes on my box .....

gotta admit - this is one reason i am happy to be a mere programmer, and not a sysadmin (well, that and the fact programmers get paid more)(well, unless one is administering a huge system, in which case your mylanta payments would probably eat up the salary difference). sounds like, once you set yourself to make the change, it went reasonably smoothly - congratulations! (i personally am suffering through a system-wide upgrade to win2000 from NT - only half the workstations are done, the server is last, and i'm hoping not to lose my mind before it all gets completed)(and i'm not even the one doing the upgrade - just trying to make all the parts work during the process)

Tirdun Mon Feb 11 10:15:30 2002
Re: Rumors of my death

> Emsworth, Tirdun, this explains why I haven't even
> managed to get your contributed episodes up.

'sokay. I've been too busy with the MYSQL/Linux/Perl system I've been fighting with for weeks to complain... even though the Elvis Pickle joke had gotten a bit old ;p

Oh, and MYSQL does, indeed, rock. Especially for a nearly-free database.

mouse Mon Feb 11 15:55:27 2002
alt jokes

> even though the Elvis Pickle joke
> had gotten a bit old ;p

we could revive elephant jokes..... why don't elephants ride tricycles? (they have no little finger to ring the bell)

Jenn Tue Feb 12 09:02:15 2002
Re: alt jokes

> we could revive elephant jokes.....

An excellent idea...

What sings and rides a tricycle?

Elvis Cycle!

(And I...don't wanna die. I just wanna ride on my motorcy...cle)

Okay, it wasn't an elephant joke. I've had a headache for three days. Give me a break.

mouse Tue Feb 12 16:07:05 2002
Re: alt jokes

> Give
> me a break.

gladly! what do you want broken?

(sorry, couldn't resist - hope your headache's better)

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.