Home arrow MySQL arrow Page 2 - MySQL 5.5 Update Features

MySQL 5.5 Windows Performance Improvements - MySQL

Oracle, the parent company of MySQL through their Sun Microsystems purchase, has announced the release-ready update for MySQL 5.5. This release promises performance gains of up to 360% for read/write on Linux platforms and over 600% on Windows Servers. Read on for a list of the new MySQL features for both Windows and Linux in the GA release.

TABLE OF CONTENTS:
  1. MySQL 5.5 Update Features
  2. MySQL 5.5 Windows Performance Improvements
By: Dev Shed
Rating: starstarstarstarstar / 6
December 17, 2010

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Windows Performance and Daily Use

Remember how you'd have to write a script in C# or PHP if you wanted toload a file of data and transform it into XML if you were going to dealwith your MySQL data imports and exports?  No mas!  MySQL now nativelyloads in XML data through a nifty construct of XML that is simple andeasy to use.

Date conversion from microseconds is insane for any developer,especially since local time on machines can be out of sync if not usingNTP.  Also, not a problem anymore.  MySQL 5.5 has added in the to_seconds() function that will give you back epoch time to work with no matter howthe data is stored, leaving it up to the application-layer to convertthe date into something meaningful.

Windows Performance

OK we've covered the linux side of the house, but what about Windows MySQL users?  Well, you are going to love MySQL 5.5 now...they have a 500% improvement in performance on Windows.  Granted, performance before was pretty sad at times, but you are now on-par it seems with the linux flavor of MySQL.

When you look at these charts of performance of MySQL 5.1 compared to 5.5, there is no comparison.  The problems for Windows 2003 server appears to be the same throughout the MySQL product family, the mutex locks.  Now that it is solved, you will be able to enjoy all the perks of Open Source!

The MySQL 5.5 Windows build also touts a different way of processing Windows API calls natively now inside of MySQL's I/O.  This removes the additional translation layers and resources associated.

Overall Impression

We recommend waiting to see if any patches come out in the next 2 weeks, but plan for a 2011 filled with MySQL 5.5 upgrades regardless of your system running on Linux or Windows.  The gains of this year-in-waiting release really outweigh any risks once you have given the release community some time to bang on the GA.  We're happy that Oracle has kept it's side of the bargain and continued development on MySQL; a critical DB platform on a large percentage of websites around the world.

Good Articles:

Sitepoint Blog: http://blogs.sitepoint.com/2010/12/16/whats-new-in-mysql-55/

InnoDB Blog: http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-performance-improvements-on-windows/

Jeremy Zawodny: http://blog.zawodny.com/2010/04/14/mysql-5-5-4-is-very-exicting/



 
 
>>> More MySQL Articles          >>> More By Dev Shed
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: