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 07:00 PM | Comments (30) | Add Comment | Trackbacks (Suck)

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? )

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

15 Whoa! Thanks for the entertaining and informative post. It's good to let us know about your experiment. Being fast is a Good thing. I got to go, I have a evening party to attend to, better don my cocktail dresses first. Again, thanks! I will monitor your post for any upcoming updates.

Posted by: Dresses @ at March 12, 2010 06:54 AM

16 Siberian tiger, a Bengal Bengal supra shoes on sale Bengal tiger
and two Amur leopards.Other animals were sent to zoos in Minnesota, South Dakota
North Dakota, while some are being housed in a warehouse in Minot outside of the
the supra footwear for
sale the flood zone.Minot is also home to more than just families and
exotic animals - III nuclear missile silos are also in the flood's path. At
least two silos are are supra
footwear are being protected by sandbags and pumps, but are reported to
be safe.The Associated Press to this article.Gay Marriage Headed to Vote on NY
Senate FloorGay marriage decision

Posted by: supra skytop shoes @ at July 06, 2011 09:28 AM

Hide Comments | Add Comment