Slashdot Mirror

← Back to Stories (view on slashdot.org)

MySQL 5.1 Released, Not Quite Up To Par

Posted by ScuttleMonkey on from the time-to-fix-the-org dept.

Mad Merlin writes "It's no secret that MySQL 5.1 has been a long time in the making, with the first beta release being in Nov 2005, but MySQL 5.1.30 has finally been released as GA. MySQL users can expect new features such as table/index partitioning, row based replication, a new plugin architecture, an event scheduler and a host of performance improvements from 5.1." Monty also had a blog post outlining some of the challenges faced in 5.1, including crashing bugs and a beta quality to most new features.

3 of 175 comments (clear)

  1. Re:Wow by TheRaven64 · · Score: 4, Informative

    MySQL is very easy to use and configure the first time. Postgres isn't nearly as simple

    I've heard this a few times. I've installed PostgreSQL on Windows, Linux, FreeBSD and OpenBSD. Every time, the process has been:

    1. Install from the package
    2. Run initdb to initialise a new storage location (sometimes done by the package - I think it was under RedHat).
    3. Run createuser and createdb for each DB user and each DB that needed to exist.

    How does MySQL simplify this?

    --
    I am TheRaven on Soylent News
  2. Re:Wow by jmusits · · Score: 4, Informative

    .... Things like "SHOW TABLES" are either considerably more difficult in Postgres or harder to find out. ....

    More difficult? Harder to find out? Consult help by typing \? and you will see this:
    [snip]
    Informational
        \d [NAME] describe table, index, sequence, or view
        \d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
                                      list tables/indexes/sequences/views/system tables
    [snip]

    Then type \dt to show the tables. To me that does not present it seld as more difficult or hard to find out.

    --
    -- 42 --
  3. Re:well by nabsltd · · Score: 4, Informative

    To step away from the metaphor for a second - I have had severity 1 service tickets open with Oracle support for over a day that ended up being unpublished bugs that were fixed with a patch that was not available until you knew you had run into the bug. Sev 1 to be clear is production systems down.

    I'll second this. We just ran into such a bug when trying to restore a database.

    The application connecting to the database was upgraded, and something went wrong when it tried to modify the schema, so we rolled back to the backup taken immediately before the start of this. Normally, this would have been simple, but apparently there's a bug with our version of Oracle that caused the restore to fail. Luckily, it only took an extra couple of hours to work around and we were still in our planned outage window, but it still sucked that it was a bug known to Oracle.

    Of course, we didn't hit the Oracle bug in our development and test systems, because the application didn't fail in the schema update on those, thank's to Mr. Murphy.