Learn about Centmin Mod LEMP Stack today
Register Now

MariaDB MariaDB 10.2.0 Alpha now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Apr 18, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    55,396
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    7:50 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.0. This is an alpha release. See the release notes and changelog for details on this release. Download MariaDB 10.2.0 Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

    The post MariaDB 10.2.0 Alpha now available appeared first on MariaDB.org.

    Continue reading...

     
  2. Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    10:50 AM
    1.9.x
    10.1.x
    The changelog don't show a lot of changes. Gonna try it on a dev server to check how it goes.
     
  3. eva2000

    eva2000 Administrator Staff Member

    55,396
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    7:50 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Wow MariaDB 10.2 branch is here.. though alpha !

    MariaDB 10.2.0 Release Notes - MariaDB Knowledge Base

     
  4. eva2000

    eva2000 Administrator Staff Member

    55,396
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    7:50 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    like this change (y)

    let me know how it fairs :)
     
  5. Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    10:50 AM
    1.9.x
    10.1.x
    Just upgraded my Dev Server from 10.1.13 to 10.2.0 without any problems.
    Code:
    # mysql
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 13
    Server version: 10.2.0-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]> 
    In terms of performance, running a backup of my site, it seems at least as fast as 10.1, if not even faster. But it might be placebo, i don't know.

    Maybe it will be in 10.2 that we will see this coming to life? [MDEV-19] Memory tables: VARCHAR and BLOB support - JIRA
     
  6. eva2000

    eva2000 Administrator Staff Member

    55,396
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    7:50 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    nice.. just time the backup commands from cache populated and not populated scenario :)
     
    Last edited: Apr 19, 2016
  7. Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    10:50 AM
    1.9.x
    10.1.x
    MariaDB 10.2.0 is a bit faster than 10.1.3, for sure. Just a few ms, but it is.

    Runing a backup of my Invision Power Board, the page load time of the View New Content(which have some complex queries), took between 0,66s to 0,74s in the various trys i have done. It never went better than 0,66s.
    Updated to 10.2.0, tried again, and it was between 0,63s and 0,73s. I saw many times in 0,63s and 0,64s, something i have not seen with 10.1.3.

    Ok, we are just talking about a very few ms, but its something.