Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB MariaDB 10.2.2 Beta now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Sep 28, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:40 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.2 Beta. This is the first beta release in the MariaDB 10.2 series. See the release notes and changelog for details. Download MariaDB 10.2.2 Beta Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

    The post MariaDB 10.2.2 Beta now available appeared first on MariaDB.org.


    Continue reading...
     
    Last edited: Sep 28, 2016
  2. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:40 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    ooh from Alpha to Beta now :cool::D

    very nice :D
     
    Last edited: Sep 28, 2016
  3. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:40 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Centmin Mod 123.09beta01 prep for MariaDB 10.2 :D

    Code (Text):
    --------------------------------------------------------
         Centmin Mod Menu 123.09beta01 centminmod.com 
    --------------------------------------------------------
    1).  Centmin Install
    2).  Add Nginx vhost domain
    3).  NSD setup domain name DNS
    4).  Nginx Upgrade / Downgrade
    5).  PHP Upgrade / Downgrade
    6).  XCache Re-install
    7).  APC Cache Re-install
    8).  XCache Install
    9).  APC Cache Install
    10). Memcached Server Re-install
    11). MariaDB 5.2/5.5 & 10.x Upgrade Sub-Menu
    12). Zend OpCache Install/Re-install
    13). Install/Reinstall Redis PHP Extension
    14). SELinux disable
    15). Install/Reinstall ImagicK PHP Extension
    16). Change SSHD Port Number
    17). Multi-thread compression: pigz,pbzip2,lbzip2...
    18). Suhosin PHP Extension install
    19). Install FFMPEG and FFMPEG PHP Extension
    20). NSD Install/Re-Install
    21). Update - Nginx + PHP-FPM + Siege
    22). Add Wordpress Nginx vhost + Cache Plugin
    23). Update Centmin Mod Code Base
    24). Exit
    --------------------------------------------------------
    Enter option [ 1 - 24 ] 11
    --------------------------------------------------------
    

    Code (Text):
    --------------------------------------------------------
            MariaDB MySQL Upgrade Sub-Menu         
    --------------------------------------------------------
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
    5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
    6). MariaDB 10.1.x to MariaDB 10.2.x YUM upgrade
    7). Back to Main menu
    --------------------------------------------------------
    Enter option [ 1 - 7 ] 6
    --------------------------------------------------------
    Place holder for now until MariaDB 10.2.x is ready to be added


    and eventually when MariaDB 10.2.x is ready
    Code (Text):
    --------------------------------------------------------
            MariaDB MySQL Upgrade Sub-Menu          
    --------------------------------------------------------
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
    5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
    6). MariaDB 10.1.x to MariaDB 10.2.x YUM upgrade
    7). Back to Main menu
    --------------------------------------------------------
    Enter option [ 1 - 7 ] 6
    --------------------------------------------------------
    

    Code (Text):
    -------------------------------------------------------------------------------
     This script's MariaDB 10.2.x upgrade process is still in beta testing stages.
     So please test on a test server and not a live production server. But if you use
     on live server or if MySQL databases already exist, please back them up before
     running this upgrade script via mysqldump - instructions at:
     http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.
    
     ###################################################################
     ###          IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE          ###
     ###        OR RISK DATA LOSS DUE TO MARIADB 10.2 Changes        ###
     ###################################################################
    
     For each DATABASENAME backup via mysqldump i.e.
    
      mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
    ------------------------------------------------------------------------
    
    Have you backed up your databases ? [y/n] y
    
    MariaDB 10.2.x https://mariadb.com/kb/en/mariadb/what-is-mariadb-102/
    
    !!  Note  !!
    upgrade process can take more >5 minutes.. you may want to shutdown
    nginx server to not show mysql errors to visitors on your site or
    put site(s) into maintenance mode before proceeding with mysql upgrade
    
    Do you want to continue with upgrade to MariaDB 10.2.x ? [y/n] 
    
     
    Last edited: Sep 28, 2016
  4. Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    4:40 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    that will be... this

    Code:
    ngxstop
    upgrade mariadb... (centmin menu)
    ngxstart
     
  5. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:40 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yeah usually how i do it :)

    1st error seems MariaDB 10.2.2 doesn't like one innodb variable = innodb_buffer_pool_populate so need to remove it from [mariadb-10.2] group in /etc/my.cnf :)
    Code (Text):
    ## !! mysql failed to start properly !! ##
    journalctl -xn
    -- Logs begin at Tue 2016-09-27 09:12:18 UTC, end at Tue 2016-09-27 17:05:18 UTC. --
    Sep 27 17:05:16 centos7.localdomain mysqld[7720]: 2016-09-27 17:05:16 139703433668736 [Note] InnoDB: 5.7.14 started; log sequence number 3274811
    Sep 27 17:05:16 centos7.localdomain mysqld[7720]: 2016-09-27 17:05:16 139702724196096 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    Sep 27 17:05:16 centos7.localdomain mysqld[7720]: 2016-09-27 17:05:16 139703433668736 [Note] Plugin 'FEEDBACK' is disabled.
    Sep 27 17:05:16 centos7.localdomain mysqld[7720]: 2016-09-27 17:05:16 139703433668736 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_buffer_pool_populate=0'
    Sep 27 17:05:16 centos7.localdomain mysqld[7720]: 2016-09-27 17:05:16 139703433668736 [ERROR] Aborting
    Sep 27 17:05:18 centos7.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=7/NOTRUNNING
    Sep 27 17:05:18 centos7.localdomain systemd[1]: Failed to start MariaDB database server.

    Test on local virtualbox CentOS 7 test server :)
    Code (Text):
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.2.2-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.2.2-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 3 min 33 sec
    
    Threads: 2  Questions: 2  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.009

    innodb_buffer related settings on MariaDB 10.2.2 beta
    Code (Text):
    mysqladmin var | grep innodb_buffer | tr -s ' '
    | innodb_buffer_pool_chunk_size | 50331648 |
    | innodb_buffer_pool_dump_at_shutdown | ON |
    | innodb_buffer_pool_dump_now | OFF |
    | innodb_buffer_pool_dump_pct | 25 |
    | innodb_buffer_pool_filename | ib_buffer_pool |
    | innodb_buffer_pool_instances | 1 |
    | innodb_buffer_pool_load_abort | OFF |
    | innodb_buffer_pool_load_at_startup | ON |
    | innodb_buffer_pool_load_now | OFF |
    | innodb_buffer_pool_size | 50331648 |


    MariaDB 10.2.2 beta Plugins and Engines
    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 SCHEMA | 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):
    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         |
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+


    default start up messages for MariaDB 10.2.2 beta - on CentOS 7 the error log for MariaDB is via systemd journalctl command
    Code (Text):
    journalctl -u mariadb --no-pager

    Code (Text):
    Sep 27 17:47:15 centos7.localdomain systemd[1]: Starting MariaDB database server...
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] /usr/sbin/mysqld (mysqld 10.2.2-MariaDB) starting as process 13544 ...
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: PUNCH HOLE support available
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Uses event mutexes
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Compressed tables use zlib 1.2.7
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Using Linux native AIO
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Number of pools: 1
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Using SSE crc32 instructions
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Initializing buffer pool, total size = 48M, instances = 1, chunk size = 48M
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Completed initialization of buffer pool
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140384529258240 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Tablespace ID 0 name innodb_system:Default tablespace encryption mode scheme unencrypted
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Highest supported file format is Barracuda.
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Creating shared tablespace for temporary tables
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Tablespace ID 7 name innodb_temporary:Default tablespace encryption mode scheme unencrypted
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    Sep 27 17:47:15 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:15 140385145686144 [Note] InnoDB: Waiting for purge to start
    Sep 27 17:47:16 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:16 140385145686144 [Note] InnoDB: 5.7.14 started; log sequence number 1620325
    Sep 27 17:47:16 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:16 140384432813824 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    Sep 27 17:47:16 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:16 140385145686144 [Note] Plugin 'FEEDBACK' is disabled.
    Sep 27 17:47:16 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:16 140385145686144 [Note] Server socket created on IP: '::'.
    Sep 27 17:47:16 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:16 140384432813824 [Note] InnoDB: Buffer pool(s) load completed at 160927 17:47:16
    Sep 27 17:47:16 centos7.localdomain mysqld[13544]: 2016-09-27 17:47:16 140385145686144 [Note] /usr/sbin/mysqld: ready for connections.
    Sep 27 17:47:16 centos7.localdomain mysqld[13544]: Version: '10.2.2-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
    Sep 27 17:47:16 centos7.localdomain systemd[1]: Started MariaDB database server.

    One warning to take care of
     
    Last edited: Sep 28, 2016
  6. Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    4:40 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    Ok, that we will do manually before upgrading?

    I have that allredy in my.cnf
    So I should not do anything else when I am going to upgrade?

    Code:
    # innodb settings
    innodb_large_prefix=1
    innodb_file_format = Barracuda
     
  7. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:40 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    no need, the centmin.sh menu option 11 submenu option 6 when time comes will take care of it all automatically :D

    though you wouldn't want to downgrade to older MariaDB versions with those settings removed so the warning might remain if you have them.
     
  8. eva2000

    eva2000 Administrator Staff Member

    54,647
    12,230
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,799
    Local Time:
    1:40 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    ah i see why this isn't supported it's an InnoDB XtraDB Percona engine variable, but initial MariaDB 10.2.2 is merged against Oracle MySQL 5.7 InnoDB engine not XtraDB InnoDB. Guess need to wait for the merge of Percona 5.7 XtraDB InnoDB engine.
    had a similar issue with some variables in early MariaDB 10 alphas as well before they merged in support for InnoDB XtraDB from Percona XtraDB.

    can confirm when you check the innodb engine version for MariaDB 10.2.2
    Code (Text):
    mysql -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         |
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+

    For MariaDB 10.1 innodb engine is Percona-XtraDB based
    Code (Text):
    +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
    | 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 | Percona-XtraDB, 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         |
    +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
    


    Compared to Percona 5.7 MySQL
    Code (Text):
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    | Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |
    | CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         |
    | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         |
    | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         |
    | InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
    | MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         |
    | ARCHIVE            | YES     | Archive storage engine                                                     | NO           | NO   | NO         |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |
    | FEDERATED          | NO      | Federated MySQL storage engine                                             | NULL         | NULL | NULL       |
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    
     
    Last edited: Sep 28, 2016