1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MySQL Cluster 7.2 vs. 7.3 Benchmarks

Discussion in 'MySQL' started by digitalpoint, Nov 27, 2013.

  1. #1
    Well, okay... it's not really "true" benchmarks, but a couple real world things I've observed since upgrading this site to MySQL Cluster 7.3 (ndbcluster storage engine of course).

    Load average on data nodes immediately decreased without any changes to queries or volume of queries. In fact, when you factor in some of the nodes are running unrelated processes (our search engine spider, memcached, php-fpm, etc.), the CPU resources required for data nodes decreased by about 30%.

    It's pretty obvious what day we upgraded to MySQL Cluster 7.3...

    upload_2013-11-27_20-35-0.png

    Another unexpected thing that 7.3 did for us is it seems to handle the IN() operator vastly better within queries (queries that used IN() and took ~10 seconds under 7.2 instantly went to ~0.1 seconds (so an unexpected 100x increase in those queries was definitely welcome).
    SEMrush
     
    digitalpoint, Nov 27, 2013 IP
    bledian93, PoPSiCLe and Devtard like this.
    SEMrush
  2. atinga

    atinga Active Member

    Messages:
    177
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #2
    will also like to perform MySQL Upgrade from v5.1 to v5.5+
    Can I get any help from your end?
     
    atinga, Nov 29, 2013 IP
  3. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,301
    Likes Received:
    2,606
    Best Answers:
    461
    Trophy Points:
    710
    Digital Goods:
    29
    #3
    No, sorry...
     
    digitalpoint, Nov 29, 2013 IP
  4. Md Jahirul Islam

    Md Jahirul Islam Member

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #4
    I will try to make use of it
     
    Md Jahirul Islam, Dec 10, 2013 IP
  5. hip_hop_x

    hip_hop_x Active Member

    Messages:
    522
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    90
    #5
    Do you use something else to cache some of the database queries as well ( except MySql ) ?
     
    hip_hop_x, Dec 10, 2013 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,301
    Likes Received:
    2,606
    Best Answers:
    461
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    Not globally, no.
     
    digitalpoint, Dec 10, 2013 IP