Forgot your password?
typodupeerror
Databases Open Source Oracle Upgrades

Oracle Claims Dramatic MySQL Performance Improvements 168

Posted by timothy
from the breathing-in-those-sulfurous-fumes dept.
New submitter simula67 writes "Oracle wins back some karma from the open source community by releasing MySQL cluster 7.2 with ambitious claims of 70x performance gains. The new release is GPL and claims to have processed over 1 billion queries per minute. Readers may remember the story about Oracle adding commercial extensions to MySQL."
This discussion has been archived. No new comments can be posted.

Oracle Claims Dramatic MySQL Performance Improvements

Comments Filter:
  • by photonyx (2507666) on Thursday February 16, 2012 @03:20PM (#39064137)
    The case when the data set is bigger than RAM amount has not been investigated (link here [blogspot.com], see the comments). The hard drive I/O speed would slow it dramatically, unless it's an expensive array of SSDs.
  • by Anonymous Coward on Thursday February 16, 2012 @03:34PM (#39064353)

    The latest (past year's worth) of PostgreSQL releases automatically rewrite subqueries as joins for you.

    However, MSSQL 2008 performance dropped significantly from prior versions due to the exact opposite --- subqueries are now looped through, where previously they were handled with hash tables internally.

  • by Amadodd (620353) on Thursday February 16, 2012 @03:35PM (#39064377)
    Slightly off-topic, but I recently had the oppurtunity to test the speed of a MySQL in-memory database. I have some frequently queried read-only data that simply would not handle the load in MS SQL and was looking for an in-memory solution. MySQL provided the simplest implementation - simply tell the table to use memory storage and configure the server to allow the amount of data you want to host (~250MB in this case). You also have to remember to reload the data from normal InnoDB tables every time you restart the server. I used the same table structures, keys indexes and stored procedures (almost the same) to query the data and linked it through MS SQL so that my applications never new the difference. On exactly the same hardware the speed increase was at least 50X over MS SQL.
  • Re:Finally! (Score:4, Interesting)

    by Admiral Llama (2826) on Thursday February 16, 2012 @03:46PM (#39064539)

    No, rather it's amazing what happens when you architect the DB such that the entire thing is forcibly held in memory.

If you are good, you will be assigned all the work. If you are real good, you will get out of it.

Working...