Learn about Centmin Mod LEMP Stack today
Become a Member

Oracle MySQL 8.0 GA Stable Release

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Apr 20, 2018.

  1. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Good news is Oracle has announced that MySQL 8.0 has gone GA Stable with 2x the performance of MySQL 5.7 !
     
  2. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Looks like it's time for me to also read up more on MySQL 8.0 via the official documentation. Only played with early betas way back so lots to learn and read up before thinking of adding MySQL 8.0 support to Centmin Mod :D

    MySQL 8.0 release notes MySQL :: MySQL 8.0 Release Notes
     
    • Like Like x 1
  3. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x

    MySQL 5.7 to MySQL 8.0 Upgrade Notes


    Big one is character set and collation default changes
    FYI, Centmin Mod 123.09beta01 MariaDB 10.1 defaults to uft8 and uft8_general_ci for character set and collation server defaults
    Code (Text):
    mysqladmin var | egrep 'character_set_server|collation' | tr -s ' '
    | character_set_server | utf8 |
    | collation_connection | utf8_general_ci |
    | collation_database | utf8_general_ci |
    | collation_server | utf8_general_ci |
    

    So would need to specify in /etc/my.cnf
    Code (Text):
    [mysqld]
    character_set_server=uft8
    collation_server=utf8_general_ci
    


    Also zlib bundled (along with lz4 and lzma)
    SQL Changes
    Data dictionary changes
    hmm this part can be trickier for some MySQL :: MySQL 8.0 Reference Manual :: 2.11.1.1 MySQL Upgrade Strategies
    And MySQL :: MySQL 8.0 Reference Manual :: 14.7 Data Dictionary Usage Differences

     
    • Informative Informative x 1
  4. buik

    buik Well-Known Member

    1,165
    309
    83
    Apr 29, 2016
    Ratings:
    +910
    Local Time:
    5:37 AM
    Why using MySQL anyway :)
     
  5. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    performance is enticing :)
     
  6. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Interesting New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go

     
  7. buik

    buik Well-Known Member

    1,165
    309
    83
    Apr 29, 2016
    Ratings:
    +910
    Local Time:
    5:37 AM
  8. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Yeah true eventually MariaDB will backport from MySQL 8.0 but probably be a while given what they're doing on MariaDB 10.3 Changes & Improvements in MariaDB 10.3. Centmin Mod will always default to MariaDB 10 for near future and MySQL 8.0 is a wait and see for me - though still need to play with MySQL 8.0 for my general learning and skill set upkeep :D
     
  9. Derek

    Derek Member

    45
    9
    8
    Aug 5, 2016
    Ratings:
    +21
    Local Time:
    11:37 PM
    It sounds like a big chunk of their touted performance increase may be in more rational default settings for variables we tend to tune anyway.

    It might be worth a test to see if a real install sees any significant improvements.
     
  10. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Nah definitely alot of performance improvements under the hood for MySQL 8.0 ! They're real.
     
  11. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Test MySQL 8.0.11 install side by side with MariaDB 10.1.32 on Centmin Mod 123.09beta01 :)

    Code (Text):
    mysqladmin -P 3307 -S /opt/mysql/data/mysql.sock ver
    mysqladmin  Ver 8.0.11 for el7 on x86_64 (MySQL Community Server - GPL)
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Server version          8.0.11
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /opt/mysql/data/mysql.sock
    Uptime:                 3 min 36 sec
    
    Threads: 2  Questions: 7  Slow queries: 0  Opens: 127  Flush tables: 2  Open tables: 103  Queries per second avg: 0.032

    Code (Text):
    ls -lah /opt/mysql/data/
    total 165M
    drwxr-xr-x 5 mysql mysql 4.0K Apr 20 06:25 .
    drwxr-xr-x 3 root  root    17 Apr 20 05:47 ..
    -rw-r----- 1 mysql mysql   56 Apr 20 05:48 auto.cnf
    -rw-r----- 1 mysql mysql  178 Apr 20 05:49 binlog.000001
    -rw-r----- 1 mysql mysql  178 Apr 20 05:51 binlog.000002
    -rw-r----- 1 mysql mysql  178 Apr 20 06:01 binlog.000003
    -rw-r----- 1 mysql mysql  178 Apr 20 06:15 binlog.000004
    -rw-r----- 1 mysql mysql  178 Apr 20 06:23 binlog.000005
    -rw-r----- 1 mysql mysql  178 Apr 20 06:24 binlog.000006
    -rw-r----- 1 mysql mysql  178 Apr 20 06:25 binlog.000007
    -rw-r----- 1 mysql mysql  155 Apr 20 06:25 binlog.000008
    -rw-r----- 1 mysql mysql  128 Apr 20 06:25 binlog.index
    -rw------- 1 mysql mysql 1.7K Apr 20 05:48 ca-key.pem
    -rw-r--r-- 1 mysql mysql 1.1K Apr 20 05:48 ca.pem
    -rw-r----- 1 mysql mysql    5 Apr 20 06:25 centos7.localdomain.pid
    -rw-r--r-- 1 mysql mysql 1.1K Apr 20 05:48 client-cert.pem
    -rw------- 1 mysql mysql 1.7K Apr 20 05:48 client-key.pem
    -rw-r----- 1 mysql mysql 6.4K Apr 20 06:25 error.log
    -rw-r----- 1 mysql mysql 3.2K Apr 20 06:25 ib_buffer_pool
    -rw-r----- 1 mysql mysql  12M Apr 20 06:25 ibdata1
    -rw-r----- 1 mysql mysql  48M Apr 20 06:25 ib_logfile0
    -rw-r----- 1 mysql mysql  48M Apr 20 06:20 ib_logfile1
    -rw-r----- 1 mysql mysql  12M Apr 20 06:25 ibtmp1
    drwxr-x--- 2 mysql mysql  137 Apr 20 05:48 mysql
    -rw-r----- 1 mysql mysql  24M Apr 20 06:25 mysql.ibd
    srwxrwxrwx 1 mysql mysql    0 Apr 20 06:25 mysql.sock
    -rw------- 1 mysql mysql    5 Apr 20 06:25 mysql.sock.lock
    drwxr-x--- 2 mysql mysql 4.0K Apr 20 05:48 performance_schema
    -rw------- 1 mysql mysql 1.7K Apr 20 05:48 private_key.pem
    -rw-r--r-- 1 mysql mysql  452 Apr 20 05:48 public_key.pem
    -rw-r--r-- 1 mysql mysql 1.1K Apr 20 05:48 server-cert.pem
    -rw------- 1 mysql mysql 1.7K Apr 20 05:48 server-key.pem
    drwxr-x--- 2 mysql mysql   27 Apr 20 05:48 sys
    -rw-r----- 1 mysql mysql  10M Apr 20 06:25 undo_001
    -rw-r----- 1 mysql mysql  10M Apr 20 06:25 undo_002
    

    Code (Text):
    mysql -t -e "SHOW ENGINES;"
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
    | InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
    | MyISAM             | YES     | MyISAM 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         |
    | CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
    | ARCHIVE            | YES     | Archive storage engine                                         | 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     |
    | sha256_password            | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |
    | caching_sha2_password      | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |
    | sha2_cache_cleaner         | ACTIVE   | AUDIT              | NULL    | GPL     |
    | CSV                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | MEMORY                     | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | InnoDB                     | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | INNODB_TRX                 | 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_TABLES              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_TABLESTATS          | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_INDEXES             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_TABLESPACES         | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_COLUMNS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_VIRTUAL             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_CACHED_INDEXES      | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | MyISAM                     | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | MRG_MYISAM                 | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | PERFORMANCE_SCHEMA         | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | TempTable                  | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | ARCHIVE                    | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | BLACKHOLE                  | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | FEDERATED                  | DISABLED | STORAGE ENGINE     | NULL    | GPL     |
    | ngram                      | ACTIVE   | FTPARSER           | NULL    | GPL     |
    | mysqlx                     | ACTIVE   | DAEMON             | NULL    | GPL     |
    | mysqlx_cache_cleaner       | ACTIVE   | AUDIT              | NULL    | GPL     |
    +----------------------------+----------+--------------------+---------+---------+
    
     
  12. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Customising the mysql client paths for easier administration/testing of both MariaDB 10.1.32 and Oracle MySQL 8.0.11 side by side on same server :)

    Code (Text):
    mysqladmin ver
    /usr/bin/mysqladmin  Ver 9.1 Distrib 10.1.32-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.1.32-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 19 min 5 sec
    
    Threads: 1  Questions: 6  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.005
    

    Code (Text):
    mysqladmin8 ver
    /usr/local/mysql/bin/mysqladmin  Ver 8.0.11 for el7 on x86_64 (MySQL Community Server - GPL)
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Server version          8.0.11
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /opt/mysql/data/mysql.sock
    Uptime:                 29 min 56 sec
    
    Threads: 2  Questions: 13  Slow queries: 0  Opens: 110  Flush tables: 2  Open tables: 86  Queries per second avg: 0.007
    
     
  13. Derek

    Derek Member

    45
    9
    8
    Aug 5, 2016
    Ratings:
    +21
    Local Time:
    11:37 PM
    OK, I'm very interested in what you discover. I'm still pessimistic - I think the only way they double performance is on some workloads where the initial tuning variables were poorly set by older versions of MySQL, but it'll be nice to know. :)
     
  14. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Well there are improvements in some workloads but regressions against MySQL 5.7 in other workloads but really depends. But improvements in mysql replication are real. Not sure how it fairs against MariaDB 10.1/10.2/10.3 replication.

    Doing real performance tests is hard if you don't have access to dedicated servers (which are solely used for such tests) as VPS servers are subject to neighbour contention so results may not be accurate. My last publication of comparison numbers was just over 7 yrs ago LOL
    Reading back those benchmark comparison articles brings back memories of a different time when server hardware and mysql performance were way different to how they perform these days ! That server I used for benchmark tests - Quad Intel Xeon L7555 1.86Ghz Nehalem-EX processors with 32C/64T cost US$20,000+ to build back in 2011 ! It was these benchmark results that made me decide that Centmin Mod LEMP stacks should switch to MariaDB as the default MySQL server version ;) :D

    Cloud hosting as evolved these days though with both DigitalOcean and Vultr offering up more dedicated core based VPS servers which have less contention and Packet.net and Vultr offering up bare metal dedicated servers charged on hourly basis :) Unfortunately, it still costs time and money to do CentminMod Benchmarking Budget Assistance ;) :)
     
  15. Derek

    Derek Member

    45
    9
    8
    Aug 5, 2016
    Ratings:
    +21
    Local Time:
    11:37 PM
    Eva, are you asking me to set up a physical server for you to test on? ;)
     
  16. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    No not right now... no much free time either way for full on benchmark testing. Just reading the MySQL 8 documentation when i have time to get up to speed right now with regards to the newer/different mysql options MySQL 8 has compared to MySQL 5.7 and MariaDB 10.1/10.2/10.3 :) Some of the new MySQL 8 defaults need to be adjusted to maintain backwards compatibility with older versions if you're doing in place upgrades. Lots to learn :)
     
  17. Derek

    Derek Member

    45
    9
    8
    Aug 5, 2016
    Ratings:
    +21
    Local Time:
    11:37 PM
    Well, let me know. Right now I've got a few dual-E5 Xeon systems with either 144G or 128G RAM sitting in the garage floor. The problem is that they're loud, so I don't want to set them up and have to listen to them forever. ;)
     
    • Informative Informative x 1
  18. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Oh I know how I have one of those too - occupied with other tasks though Benchmarks - Dual Intel Xeon E5-2650v1, 64GB RAM, Asus Z9PE-D8 WS :)
     
  19. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    More differences between MariaDB 10.1.32 vs MySQL 8.0.11 in terms of default innodb_default_row_format which was newly introduced in MariaDB 10.1.32 ([MDEV-14904] Please backport `innodb_default_row_format` to MariaDB 10.1 - JIRA). MariaDB uses COMPACT while MySQL 8.0 uses DYNAMIC defaults (same as MySQL 5.7 starting with MySQL 5.7.9).
    MariaDB 10.1.32 default for Centmin Mod 123.09beta01 installs - Centmin Mod uses innodb_file_format Barracuda and enables innodb_large_prefix by default.
    Code (Text):
    mysqladmin var | egrep 'innodb_file_format|row_format|innodb_large_prefix' | tr -s ' '
    | innodb_default_row_format | compact |
    | innodb_file_format | Barracuda |
    | innodb_file_format_check | ON |
    | innodb_file_format_max | Antelope |
    | innodb_large_prefix | ON |
    

    Example test1 database created with t1 table on MariaDB 10.1.32 defaults to ROW_FORMAT=COMPACT
    Code (Text):
    mysql -e "SELECT TABLE_SCHEMA, TABLE_NAME, ENGINE, ROW_FORMAT FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE = 'InnoDB' AND ROW_FORMAT = 'Compact' AND TABLE_SCHEMA != 'mysql';"
    +--------------+------------+--------+------------+
    | TABLE_SCHEMA | TABLE_NAME | ENGINE | ROW_FORMAT |
    +--------------+------------+--------+------------+
    | test1        | t1         | InnoDB | Compact    |
    +--------------+------------+--------+------------+
    

    Code (Text):
    mysql -e "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 't1' \G" test1
    *************************** 1. row ***************************
      TABLE_CATALOG: def
       TABLE_SCHEMA: test1
         TABLE_NAME: t1
         TABLE_TYPE: BASE TABLE
             ENGINE: InnoDB
            VERSION: 10
         ROW_FORMAT: Compact
         TABLE_ROWS: 4448
     AVG_ROW_LENGTH: 4140
        DATA_LENGTH: 18415616
    MAX_DATA_LENGTH: 0
       INDEX_LENGTH: 2949120
          DATA_FREE: 4194304
     AUTO_INCREMENT: 5555
        CREATE_TIME: 2018-04-24 02:41:30
        UPDATE_TIME: NULL
         CHECK_TIME: NULL
    TABLE_COLLATION: utf8_general_ci
           CHECKSUM: NULL
     CREATE_OPTIONS:
      TABLE_COMMENT:
    


    MySQL 8.0.11 default - seems MySQL 8.0 supports both old Antelope and newer Barracuda file formats so no longer needs a setting to decide and innodb_large_prefix is default to enabled/ON
    Code (Text):
    mysqladmin8 var | egrep 'innodb_file_format|row_format|innodb_large_prefix' | tr -s ' '
    | innodb_default_row_format | dynamic |
    

    This will effect how MySQL 8.0 handles InnoDB tables' max index length and make errors such as these a thing of the past i.e. MariaDB - Index column size too large. The maximum column size is 767 bytes.

    Maybe for new Centmin Mod 123.09beta01 and MariaDB 10.1/10.2 installs, I should also make innodb_default_row_format switch from COMPACT to DYNAMIC too MySQL :: MySQL 8.0 Reference Manual :: 15.10.3 DYNAMIC and COMPRESSED Row Formats ?

    MySQL :: MySQL 8.0 Reference Manual :: 15.8.1.2 The Physical Row Structure of an InnoDB Table
     
  20. eva2000

    eva2000 Administrator Staff Member

    41,375
    9,288
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,251
    Local Time:
    1:37 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Centmin Mod 123.09beta01 has updated MariaDB 10.1/10.2 my.cnf templates to add new innodb_default_row_format variable and set it to default to DYNAMIC instead of COMPACT row formats as per Beta Branch - update MariaDB 10.1 & 10.2 default /etc/my.cnf default for innodb_default_row_format