Whee!

Update: Added Mousse. 8 servers, 13 CPUs, 17GB of memory, 5TB of disk, 14.5TB bandwidth.

Posted by: Pixy Misa at 10:47 AM | Comments (2) | Add Comment | Trackbacks (Suck)
Post contains 83 words, total size 1 kb.

Processing 0.02 seconds.
7 queries taking 0.0122 seconds, 29 records returned.
Page size 22 kb.
Powered by Minx 0.80 alpha.

The production version of Minx is up and running.

As I was slogging through it, and through the enormous lists of fields that the new version provides, I was thinking this is not going to be fast.

Well, a page of 1000 posts comes up in 220 milliseconds (with Psyco; 300ms without). That doesn't have inline comments, because I've broken the comment handler, but I would hope you aren't using inline comments if you have 1000 posts per page...

That's not slow.

Update: Except it didn't actually include 1000 posts. Bleh. Bug hunt time.

Update: Ah, it's a not-a-bug. It's returning 255 posts. Hint hint. Okay, I'll just tweak that...

Processing 0.71, elapsed 0.8462 seconds.
7 queries taking 0.4891 seconds, 1004 records returned.
Page size 1452 kb.
Powered by Minx 0.81.18 alpha.

Approximately 20ms for a normal page of 25 posts. You can see that this blog takes rather longer than that; that's the effect of the inline comments, which are dynamically sanitised in the old version. The new version does static sanitisation, which should eliminate much of that performance penalty. (Also, I'm not using Psyco on the server, because I ran into a memory leak when I tried it; that's since resolved.)

So I'm through restructuring the code and data.* Now the fun begins!

* Mostly. Still lots of tweaking to do, but the heavy lifting is done.

Posted by: Pixy Misa at 08:40 AM | Comments (4) | Add Comment | Trackbacks (Suck)
Post contains 255 words, total size 2 kb.

Posted by: Pixy Misa at 11:20 PM | No Comments | Add Comment | Trackbacks (Suck)
Post contains 12 words, total size 1 kb.

Bad Example is a typical mid-list blog. It's actively updated, it has a certain number fans, it gets a decent number of readers and comments.

It's been trucking along at 20 to 30GB of bandwidth per month, until last month, when it suddenly spiked to nearly 100GB. So far this month it's over 130GB. And I couldn't work out why.

Until I trawled through the Apache logs.

And found 25,000 hits to the archive page for September '05 in the past five days.

Turns out that page just happens to be the number 2 hit on Google Image Search for "olsen twins nude".* And the number 1 search is obviously an error, so...

So. Here's Pixy's Tip of the Day: Forget all that SEO crap. It doesn't work. Just post pictures of the Olsen twins wearing butterfly pasties, and watch your server go up in smoke.

Posted by: Pixy Misa at 08:26 PM | Comments (2) | Add Comment | Trackbacks (Suck)
Post contains 161 words, total size 1 kb.

I'm hanging it up for the night, er, morning. Unlike Michael Moore in 2004, however, I will not be staying in bed for three days in a catatonic state. I will not need PEST shock therapy. I will not move to Australia.

Posted by: Pixy Misa at 07:44 PM | Comments (8) | Add Comment | Trackbacks (Suck)
Post contains 55 words, total size 1 kb.

50 gigabytes of assorted crep, dozens of applications, over a hundred databases. And, apart from MT Blacklist buggering itself, not all that much went wrong.

Funny thing was that this blog wouldn't work. I thought that a security option in PHP was tripping me up, since accessing minx.cc directly worked fine.

Then it started to work all by itself. Huh.

Posted by: Pixy Misa at 03:12 AM | Comments (7) | Add Comment | Trackbacks (Suck)
Post contains 91 words, total size 1 kb.

Hmm. Problem. If you are using Firefox, the comment editor doesn't work until Sitemeter has loaded. Sitemeter is playing up right now, so you have to wait for it to either load or time out before the comment box works.

Doesn't happen in IE7.

Posted by: Pixy Misa at 08:31 PM | Comments (4) | Add Comment | Trackbacks (Suck)
Post contains 52 words, total size 1 kb.

My forum.

Posted by: Pixy Misa at 03:28 AM | No Comments | Add Comment | Trackbacks (Suck)
Post contains 40 words, total size 1 kb.

Not quite a forum, but I'll fix that tomorr... later today.

Posted by: Pixy Misa at 11:29 AM | No Comments | Add Comment | Trackbacks (Suck)
Post contains 19 words, total size 1 kb.

Works just fine (after fixing a couple of bugs; one with error-checking in the smilifier, and the other... I've forgotten what the other one was).

Now I can start doing some serious testing and tweaking.

Also, it's working via a PHP wrapper, which is, um, one line of code. But that means you can (if you wish) use PHP through Minx.

Posted by: Pixy Misa at 12:42 AM | Comments (4) | Add Comment | Trackbacks (Suck)
Post contains 69 words, total size 1 kb.