• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • MySQL 5.4 Brings Scalability, Performance Improvements

    April 28, 2009 Alex Woodie

    Sun Microsystems took a moment last week, as it was getting prepared to be eaten by Oracle, to announce a new release of MySQL, the open source relational database management system it bought for $1 billion just over a year ago. MySQL 5.4 brings scalability enhancements for X64 and Chip Multi-threaded (CMT) servers, while general performance enhancements will help users running the software on all types of servers, including IBM Power Systems boxes.

    When paired with the InnoDB storage engine, which coincidentally is owned by Oracle, MySQL 5.4 can really scale. With InnoDB powering MySQL, Sun says, the duo can scale up to run on 16-way x86 servers and 64-way CMT servers. (Sun has been moving its SPARC chip architecture toward CMT for the last few years.)

    The new database also brings new subquery optimizations and JOIN improvements that can result in up to 90 percent better response times for certain types of analytical queries. “Without any modifications to your applications, MySQL 5.4 will transparently increase the performance and scalability of your applications, to enable them to scale under more demanding user and data processing loads,” said Karen Tegan Padir, vice president of Sun’s MySQL and Software Infrastructure Group, during the keynote address at last week’s MySQL Conference & Expo in Santa Clara, California.

    Other improvements were made in the areas of stored procedures, prepared statements access to information schemas, and DTrace support on Sun Solaris.

    A preview of MySQL 5.4 is currently available for 64-bit versions of Linux and Solaris 10. Sun also intends to support the new database on IBM i OS, Windows, AIX, HP-UX, Mac OS X, and Free BSD. The general availability date for MySQL 5.4 will be announced later this year.

    RELATED STORIES

    Jilted Sun Snapped Up by Oracle for Application Systems

    DB2/400 Storage Engine for MySQL Now Available as Public Beta

    Enterprise Features Gain Focus as MySQL 5.1 Nears Release

    Sun Casts a $1 Billion Net to Catch MySQL

    IBM Details MySQL on System i Offering

    MySQL Database Getting Closer Ties to the System i



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    ARCAD Software

    WEBINAR ROUNDTABLE
    True Git: Are there right and wrong ways to do Git on IBM i?
    February 25, 12 p.m. EST, 5 p.m. GMT

    Are you looking to manage your RPG and COBOL source code under Git? Our experts will reveal the different ways to use Git on IBM i and demonstrate how to measure the real ROI of Git on IBM i.

    Take your IBM i teams to the next level with Git.

    Register today!

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Vision Solutions:  New white paper! Review the full range of Data Protection & Recovery options.
    SafeData:  FREE White Paper - Best Bets for iSeries Rapid Recovery with Virtualization
    Aberdeen Group:  Take the 2009 ERP in Manufacturing survey, get a free copy of complete report

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    NSPI Taps Halcyon to Manage i Hosting Customers New Power6+ Iron: The Feeds and Speeds

    Leave a Reply Cancel reply

Volume 9, Number 17 -- April 28, 2009
THIS ISSUE SPONSORED BY:

Bytware
ProData Computer Services
Maximum Availability
Linoma Software
Guild Companies

Table of Contents

  • Twitter from an AS/400? Kisco Lets You Do It
  • nuBridges Pushes ‘Tokenization’ with New Encryption Tool
  • BCD Adds Features Throughout App Modernization Suite
  • Guardium Adds DB2/400 Support to Database Security Tool
  • Lawson Retrenches as it Reconnects with Customers
  • LANSA Acquires aXes Products; Customers Likely Candidates for RAMP
  • i OS Spool Files Go In, Structured XML Comes Out
  • CCSS Cracks Down on Long-Running Jobs
  • MySQL 5.4 Brings Scalability, Performance Improvements
  • QlikTech Develops a BI Client for iPhone

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM Extends Dynamic Capacity Pricing Scheme To Its Cloud
  • Here’s What You Should Do About The IBM i Skills Shortage
  • Matillion Founder Recounts Midrange Roots
  • Four Hundred Monitor, February 24
  • IBM i PTF Guide, Volume 23, Number 8
  • iTech Solutions Keeps You In The Know With VERIFi
  • Tech Data’s Take On Certified Pre-Owned IT Gear
  • Guru: Prompting Stored Procedures
  • As I See It: Sunshine Or Oxygen?
  • Looking For Some Insight On IBM i Security

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2021 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.