5.1, Innodb Plugin Release

« previous entry | next entry »
Dec. 3rd, 2008 | 03:56 pm

In MySQL 5.1 related new, Innodb has announced the release of their Innodb Plugin Engine for MySQL.

So why do I blog about it?

Because the Innodb plugin engine is the default engine Drizzle :)

Monty Taylor finished up the work last night to import it into Drizzle, and I just finished my review of the engine and have pushed it into our main branch.

Some of the advantages:

  • Fast index creation: add or drop indexes without copying the data
  • Data compression: shrink tables, to significantly reduce storage and i/o
  • New row format: fully off-page storage of long BLOB, TEXT, and VARCHAR columns
  • File format management: protects upward and downward compatibility
  • INFORMATION_SCHEMA tables: information about compression and locking
  • Link | Leave a comment | Add to Memories | Share

    Comments {5}

    Brian "Krow" Aker

    Re: What about PBXT?

    from: krow
    date: Dec. 4th, 2008 05:10 pm (UTC)
    Link

    It is. Right now we have to ship with something as default, and Innodb is it. We are actively looking at PBXT.

    The hurdles with it are:

    1) It needs to pass all tests (I pushed some fixes for it myself last week).
    2) It needs to work on Solaris.

    Reply | Parent | Thread