Welcome to Centmin Mod Community
Become a Member

CentOS 7 Beta Branch switch to MariaDB 10 my.cnf templates

Discussion in 'Centmin Mod Github Commits' started by eva2000, Aug 11, 2014.

  1. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    8:58 AM
    Nginx 1.13.x
    MariaDB 5.5
    switch to MariaDB 10 my.cnf templates

    Continue reading...
     
  2. RoldanLT

    RoldanLT Well-Known Member

    3,829
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    6:58 AM
    1.11
    10.2
    innodb_doublewrite = 1
    is useless since it is default to 1 ;)

    innodb_additional_mem_pool_size
    Will be depreceated as you said here before: MariaDB - MariaDB10 | Page 2 | Centmin Mod Community

    And why did you remove this on your latest config:
    Code:
    [mariadb-10.0]
    # 2 variables needed to switch from XtraDB to InnoDB plugins
    #plugin-load=ha_innodb
    #ignore_builtin_innodb
    
    ## MariaDB 10 InnoDB plugin only
    #innodb_buffer_pool_load_now=1
    #innodb_buffer_pool_dump_now=1
    ## Disabled settings
    performance_schema=OFF
    innodb_stats_on_metadata=OFF
    innodb_sort_buffer_size=32M
    innodb_online_alter_log_max_size=128M
    query_cache_strip_comments=0
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
     
  3. eva2000

    eva2000 Administrator Staff Member

    29,016
    6,585
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,775
    Local Time:
    8:58 AM
    Nginx 1.13.x
    MariaDB 5.5
    i tend to add settings which are tuneable even if they are default - makes it easier to remember the name of the setting when you go to tune them ;)

    yeah innodb_additional_mem_pool_size is removed for .08 beta default installs of MariaDB 10.x only

    and those settings are in latest config for MariaDB 10.x default installs for .08 beta which is what this thread' commit is for switch to MariaDB 10 my.cnf templates · 4b5cdf0 · centminmod/centminmod · GitHub ;)

    you might have tried .08 beta before this commit was made :)

    see the mdb10* cnf files centminmod/config/mysql at 123.08centos7beta01 · centminmod/centminmod · GitHub
     
    Last edited: Aug 13, 2014
    • Like Like x 1