Discover Centmin Mod today
Register Now

MariaDB MariaDB 10.2.3 and 5.5.54 now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Dec 25, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    54,936
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    9:49 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.3 beta and MariaDB 5.5.54 stable (GA). See the release notes and changelogs for details. Download MariaDB 10.2.3 Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Download MariaDB 5.5.54 Release Notes Changelog What is MariaDB 5.5? MariaDB […]

    The post MariaDB 10.2.3 and 5.5.54 now available appeared first on MariaDB.org.

    Continue reading...

     
    Last edited: Dec 25, 2016
  2. eva2000

    eva2000 Administrator Staff Member

    54,936
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    9:49 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    testing MariaDB 10.2.3 beta on Centmin Mod 123.09beta01
    Code (Text):
    mysqladmin  Ver 9.1 Distrib 10.2.3-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.2.3-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 0 sec
    
    Threads: 5  Questions: 1  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.000
    

    Still using Oracle MySQL InnoDB Plugin instead of Percona XtraDB InnoDB Plugin right now.
    Code (Text):
    mysql -t -e "SHOW ENGINES;"
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
    | Engine             | Support | Comment                                                                          | Transactions | XA   | Savepoints |
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
    | MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                            | NO           | NO   | NO         |
    | CSV                | YES     | CSV storage engine                                                               | NO           | NO   | NO         |
    | Aria               | YES     | Crash-safe tables with MyISAM heritage                                           | NO           | NO   | NO         |
    | MyISAM             | YES     | MyISAM storage engine                                                            | NO           | NO   | NO         |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                        | NO           | NO   | NO         |
    | InnoDB             | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
    | SEQUENCE           | YES     | Generated tables filled with sequential values                                   | YES          | NO   | YES        |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
    

    Code (Text):
    mysql -t -e "SHOW PLUGINS;"
    +-------------------------------+----------+--------------------+------------------------+---------+
    | Name                          | Status   | Type               | Library                | License |
    +-------------------------------+----------+--------------------+------------------------+---------+
    | binlog                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
    | mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
    | wsrep                         | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | CSV                           | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_TEMP_TABLE_INFO        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION | NULL                   | GPL     |
    | INNODB_MUTEXES                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
    | INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
    | SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | Aria                          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL                   | GPL     |
    | partition                     | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | METADATA_LOCK_INFO            | ACTIVE   | INFORMATION SCHEMA | metadata_lock_info.so  | GPL     |
    | QUERY_CACHE_INFO              | ACTIVE   | INFORMATION SCHEMA | query_cache_info.so    | BSD     |
    | QUERY_RESPONSE_TIME           | ACTIVE   | INFORMATION SCHEMA | query_response_time.so | GPL     |
    | QUERY_RESPONSE_TIME_AUDIT     | ACTIVE   | AUDIT              | query_response_time.so | GPL     |
    +-------------------------------+----------+--------------------+------------------------+---------+
    

    Code (Text):
    rpm -ql MariaDB-shared
    /etc/my.cnf.d
    /etc/my.cnf.d/client.cnf
    /usr/lib64/libmariadb.so
    /usr/lib64/libmariadb.so.3

    Code (Text):
    rpm -ql MariaDB-compat
    /usr/lib64/libmysqlclient.so.15
    /usr/lib64/libmysqlclient.so.15.0.0
    /usr/lib64/libmysqlclient.so.16
    /usr/lib64/libmysqlclient.so.16.0.0
    /usr/lib64/libmysqlclient.so.18
    /usr/lib64/libmysqlclient.so.18.0.0
    /usr/lib64/libmysqlclient_r.so.15
    /usr/lib64/libmysqlclient_r.so.15.0.0
    /usr/lib64/libmysqlclient_r.so.16
    /usr/lib64/libmysqlclient_r.so.16.0.0
    /usr/lib64/libmysqlclient_r.so.18
    /usr/lib64/libmysqlclient_r.so.18.0.0
     
    Last edited: Dec 25, 2016
  3. Xon

    Xon Active Member

    173
    61
    28
    Nov 16, 2015
    Ratings:
    +229
    Local Time:
    7:49 PM
    1.15.x
    MariaDB 10.3.x
  4. eva2000

    eva2000 Administrator Staff Member

    54,936
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    9:49 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yeah I can imagine :D