/ Register

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.

Tags:
Previous Thread Next Thread
Loading...
  1. Aug 11, 2014 #1
    eva2000

    eva2000 Administrator Staff Member

    53,614
    12,139
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,683
    Local Time:
    11:44 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    switch to MariaDB 10 my.cnf templates

    Continue reading...
     
  2. Aug 13, 2014 #2
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    9:44 AM
    Mainline
    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. Aug 13, 2014 #3
    eva2000

    eva2000 Administrator Staff Member

    53,614
    12,139
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,683
    Local Time:
    11:44 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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
Previous Thread Next Thread
Loading...

.