Database Upgrade (mostly) complete
Sat Aug 18 2001

Hi guys,
Sorry for the outage this morning, though it was at least a planned one :-) I hate upgrading things that are working, but we've been waiting for transaction support and in particular row level locking since the beginning of time for MySQL and so this one was especially important.

Its mostly all done now, the database server software is installed and running (else how would you be reading this?) and a major cleanup of old cruft from previous database relics has taken place.

However, at present, all is running almost exactly the same as it used to. This means that we're not yet using the new features. Migration to those will take place today and WILL mean that the system runs incredulously slowly from time to time as the data is migrated to the new tables. In theory, it won't go down again though... I hope...


Please note: We have implemented a new support system which should speed up our ability to help you, especially new people. If you need support for the system, please use the HELP button at the top, or the support address at the bottom of every page...

5 Comments
  • From:
    StillMyst (Legacy)
    On:
    Sat Aug 18 2001

    Thats ok ... :)

    You guys do a great job! Dont worry...

  • From:
    Buggie (Legacy)
    On:
    Sat Aug 18 2001
    er yeah can i order fries with that cheeseburger...
    oh an one of them toy things too.

    Yup.
    thanks.

    buggie

    PS i think u do a great job so there :o)
  • From:
    Lonelyone (Legacy)
    On:
    Sun Aug 19 2001
    Yeah. It really sucks that MySQL doesn't support sub-queries(yet at least).

    I've really been spoiled by Oracle.

    I know it was just an example, but selecting '*' is never a good idea. First, the server has to resolve all the columns, and second of all, you should only request columns that you need. That saves resources, and guarantees the order of the columns, not that you should be relying on that order in any case :)
  • From:
    Xedri (Legacy)
    On:
    Sun Aug 19 2001
    Damn that Murphy's Law...it's a kick in the butt every time :)

    Oh well thanks for all the hard work guys!

    Xedri
  • From:
    Atlas (Legacy)
    On:
    Sun Aug 19 2001
    It must have been all of those parody diaries. The new SQL software couldn't last under the strain.