Oracle presents much Faster MySQL Beta 5.5

Oracle announced the release of faster MySQL 5.5 beta which is claimed to be atleast 2 times faster the its previous stable version MySQL 5.1, which debuted a year ago. After all the controversy behind Oracle and MySQL takeover, Oracle proved that they are really serious about the development of  MySQL. This beta release introduces many new features which were originally planned for MySQL 6.0.

In MySQL 5.1, MyISAM was the default engine which is now being replaced by InnoDB engine, which provides ACID transaction, foriegn keys and row level locking. MyISAM provides only table level locking, and count operations are more expensive in it.

Edward Screven, the chief architect of Oracle, presented MySQL 5.5 Beta at the O'Reilly MySQL conference and said that the switch to InnoDB offers 200% performance improvement and over ten times faster recovery.

On the MySQL developers site, a new article details some other changes in MySQL 5.5. These include better metadata handling during transactions, improved performance and scaling on Windows, semi-synchronous replication, heartbeating and more partitioning options. The MySQL performance schema, a table of information on the low level performance of MySQL, has been introduced and already enhanced to include low level InnoDB statistics.

O'Reilly MySQL CE 2010: Edward Screven

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <img> <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote> <h1> <h2> <h3> <h4> <h5> <h6> <p> <br>
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • Use syntax $$latex$$ to insert LaTeX formulas.
  • Image links with 'rel="lightbox"' in the <a> tag will appear in a Lightbox when clicked on.
  • Search Engines will index and follow ONLY links to allowed domains.

More information about formatting options

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.