• 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
    Maxava

    Migrate IBM i with Confidence

    Tired of costly and risky migrations? Maxava Migrate Live minimizes disruption with seamless transitions. Upgrading to Power10 or cloud hosted system, Maxava has you covered!

    Learn More

    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

  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24
  • Big Blue Raises IBM i License Transfer Fees, Other Prices
  • Keep The IBM i Youth Movement Going With More Training, Better Tools
  • Remain Begins Migrating DevOps Tools To VS Code
  • IBM Readies LTO-10 Tape Drives And Libraries
  • IBM i PTF Guide, Volume 27, Number 23

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 © 2025 IT Jungle