April 17, 2004

YourSQL

Hi-ho everybody!

I ran an experiment yesterday in which I converted the whole MuNu Movable Type database to MySQL to see if it would make a difference in performance.

It does. It makes a big difference.

It seems to be three to five times faster for normal-type stuff, and fourteen times faster in my super-killer stress test.

Now, obviously we want to convert to MySQL ASAP. Only problem is, the conversion program itself is abysmally slow - it took about eight hours to run. And any posts or comments made while it's running will be lost.

So, what I propose to do is this: Next weekend (which is a long weekend for me, fortuitously enough) I will turn off posting and commenting (with a nice friendly message) and convert everything. As soon as it's done, I'll turn everything back on, and you can all jump in and do whatever it is you do.

I'll post a more exact time closer to the day. One thing to be aware of - if you start writing a long post, and then I turn posting off, and then you click save, it will go bye-bye. So what I might do is copy the database and leave posting turned on; that way you can save your post but you will have to copy it manually to the new system (cut-and-paste).

Does any of this make sense to anyone?

Posted by Pixy Misa at April 17, 2004 07:00 PM
Comments
#1

Sounds like a plan. Nothing wrong with making a backup first, but I see no reason why folks can't just be patient. :)

Posted by Ted at April 17, 2004 08:39 PM
#2

Makes sense to me! Just make sure we all know ahead of time what day you'll be doing all that...
(That yer in an opposite time-zone than most of us helps a great deal, too, no? :D )

Posted by Tuning Spork at April 18, 2004 03:43 AM
#3

I'm down with that, as long as we get warning when it happens

Posted by frinklin at April 18, 2004 04:35 AM
#4

I think I get it--the squirrels are running very slowly and they need a new treadmill, so while the flame throwers are being recharged, no one is allowed in their template...

Posted by Susie at April 18, 2004 06:44 AM
#5

Yes.

Posted by Pixy Misa at April 18, 2004 07:40 AM
#6

OOh! Ooh! Happy! Happy! Faster! Faster! Thank you for doing this. That is what makes it so awesome to be a munuvian!

Posted by Alex. at April 18, 2004 10:31 AM
#7

so is this officially Munuvia's first public holiday?

Yay super speed!

Posted by Rob at April 18, 2004 02:35 PM
#8

And it's good that you let us know, otherwise I'd think I just buggered it all up again.

Posted by LeeAnn at April 18, 2004 03:04 PM
#9

Yay, faster! (Been a bit crawly at times lately.)

Posted by Jennifer at April 19, 2004 01:35 AM
#10

faster is gooder. I think I can put off posting for a few hours next w/e.

Posted by SpaceMonkey at April 19, 2004 05:14 AM
#11

Faster skittering would be a good thing, I think.

Posted by Mr Mouse at April 19, 2004 05:38 AM
#12

Speed! All hail speed!

And cookies! All hail cookies, too!

Posted by Jim at April 19, 2004 11:22 AM
#13

Faster pussycat! Kill! Kill!

Sorry. Heh. If I actually HAD cleavage, that would have been even MORE funny.

Or maybe not. Aheh.

I of course, defer to your bidding, Great and All-Powerful Pixy. Jump? How high!? :)

Love,
Em

Posted by Emma at April 20, 2004 12:47 AM
#14

What is this faster pussy cat chant about? I have a hard enough time outrunning them as they are. I am not sure I could do so if they got any faster.

Posted by Mr Mouse at April 20, 2004 03:37 AM
Live Comment Preview
Post a comment









Remember personal info?