Join the community today
Become a Member

MariaDB No MySQL logs after MariaDB update to 10.0

Discussion in 'Install & Upgrades or Pre-Install Questions' started by Daniel J. Lewis, Jul 29, 2015.

  1. Daniel J. Lewis

    Daniel J. Lewis Award-winning podcaster and consultant

    72
    8
    8
    Oct 20, 2014
    Ratings:
    +11
    Local Time:
    9:35 PM
    1.8.0
    5.6
    The usual log at /var/log/mysqld.log contains nothing new since updating to 10.0. Running mycnf returns:

    Code:
    #
    # This group is read both both by the client and the server
    # use it for options that affect everything
    #
    [client-server]
    
    #
    # include all files from the config directory
    #
    !includedir /etc/my.cnf.d
    
    
    
    [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=2M
    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
    Is that right, especially that "!" in there?
     
  2. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,758
    Local Time:
    11:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    weird that ain't right at all ! missing alot of settings

    let me check !

    did you edit or adjust your /etc/my.cnf prior to the MariaDB 5.5 to 10.x upgrade ?

    given the contents at top, i assume you have changed settings in /etc/my.cnf
    Code:
    #
    # This group is read both both by the client and the server
    # use it for options that affect everything
    #
    [client-server]
    
    the upgrade menu inserts or adjusts my.cnf settings for MariaDB 10 using anchors of existing settings in /etc/my.cnf. I can imagine if you edited /etc/my.cnf drastically, it could of removed such anchors so the upgrade task didn't have any anchors to reference

    Upgrade menu's relevant sections are lines 81 to 100 for inc/mariadb_submenu.inc and and lines 228 to 403 in inc/mariadb_upgrade10.inc

    You maybe able to find your pre-upgrade MariaDB 5.5 /etc/my.cnf at /etc/my.cnf-original_before_mariadb55upgrade due to auto backup prior to upgrade in line 255 of inc/mariadb_upgrade10.inc

    post the contents of that /etc/my.cnf-original_before_mariadb55upgrade via gist or pastebin link so can see the before upgrade state of your /etc/my.cnf
     
    Last edited: Jul 29, 2015
  3. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    just noticed mine got the same issue, no recent logs also.

    got 4 files

     
  4. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,758
    Local Time:
    11:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    same questions i asked above ;)
     
  5. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    i think I edited prior to 10.0.20, not sure though
     
  6. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,758
    Local Time:
    11:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    post contents of my.cnf-original_before_mariadb55upgrade in CODE tags, gist or pastebin that is your /etc/my.cnf prior to upgrade
     
  7. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    Here's my.cnf-original_before_mariadb55upgrade
    Code:
    [mysqld]
    #character-set-server=utf8
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    #bind-address=127.0.0.1
    # optimized my.cnf for MariaDB 5.5.x
    # by eva2000
    # vbtechsupport.com
    
    tmpdir=/home/mysqltmp
    
    innodb=ON
    #skip-federated
    ##skip-pbxt
    ##skip-pbxt_statistics
    #skip-archive
    #skip-name-resolve
    #old_passwords
    back_log = 75
    max_connections = 300
    key_buffer_size = 32M
    myisam_sort_buffer_size = 32M
    myisam_max_sort_file_size = 2048M
    join_buffer_size = 64K
    read_buffer_size = 64K
    sort_buffer_size = 128K
    table_definition_cache = 4096
    table_open_cache = 2048
    thread_cache_size = 64
    wait_timeout = 120
    connect_timeout = 10
    tmp_table_size = 32M
    max_heap_table_size = 32M
    max_allowed_packet = 32M
    max_seeks_for_key = 1000
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 256K
    bulk_insert_buffer_size = 8M
    query_cache_limit = 512K
    query_cache_size = 16M
    query_cache_type = 1
    query_cache_min_res_unit = 2K
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = MyISAM
    
    log_warnings=1
    slow_query_log=0
    long_query_time=1
    slow_query_log_file=/var/lib/mysql/slowq.log
    log-error=/var/log/mysqld.log
    
    # innodb settings
    ##innodb_extra_rsegments = 4
    innodb_purge_threads=1
    #innodb_doublewrite = 1
    
    innodb_file_per_table = 1
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 48M
    #innodb_additional_mem_pool_size = 32M
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 64M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    innodb_thread_concurrency = 0
    innodb_lock_wait_timeout=50
    #innodb_flush_method = O_DIRECT
    innodb_support_xa=1
    
    # 200 * # DISKS
    innodb_io_capacity = 100
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    
    # mariadb settings
    [mariadb]
    #thread-handling = pool-of-threads
    #thread-pool-size= 20
    #mysql --port=3307 --protocol=tcp
    #extra-port=3307
    #extra-max-connections=1
    
    userstat = 0
    key_cache_segments = 1
    aria_group_commit = none
    aria_group_commit_interval = 0
    aria_log_file_size = 32M
    aria_log_purge_type = immediate
    aria_pagecache_buffer_size = 8M
    aria_sort_buffer_size = 8M
    
    [mariadb-5.5]
    #ignore_db_dirs=
    query_cache_strip_comments=0
    
    innodb_read_ahead = linear
    innodb_adaptive_flushing_method = estimate
    innodb_flush_neighbor_pages = 1
    innodb_stats_update_need_lock = 0
    innodb_log_block_size = 512
    
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mysqld_safe]
    socket=/var/lib/mysql/mysql.sock
    log-error=/var/log/mysqld.log
    #nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 32M
    
    [myisamchk]
    key_buffer = 32M
    sort_buffer = 16M
    read_buffer = 16M
    write_buffer = 16M
    
    [mysqlhotcopy]
    interactive-timeout
    
    [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=2M
    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
    
     
  8. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    here's my.cnf

    Code:
    [mysqld]
    #character-set-server=utf8
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    #bind-address=127.0.0.1
    # optimized my.cnf for MariaDB 5.5.x
    # by eva2000
    # vbtechsupport.com
    
    tmpdir=/home/mysqltmp
    
    innodb=ON
    #skip-federated
    ###skip-pbxt
    ###skip-pbxt_statistics
    #skip-archive
    #skip-name-resolve
    #old_passwords
    back_log = 75
    max_connections = 300
    key_buffer_size = 32M
    myisam_sort_buffer_size = 32M
    myisam_max_sort_file_size = 2048M
    join_buffer_size = 64K
    read_buffer_size = 64K
    sort_buffer_size = 128K
    table_definition_cache = 4096
    table_open_cache = 2048
    thread_cache_size = 64
    wait_timeout = 120
    connect_timeout = 10
    tmp_table_size = 32M
    max_heap_table_size = 32M
    max_allowed_packet = 32M
    max_seeks_for_key = 1000
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 256K
    bulk_insert_buffer_size = 8M
    query_cache_limit = 512K
    query_cache_size = 16M
    query_cache_type = 1
    query_cache_min_res_unit = 2K
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = MyISAM
    
    log_warnings=1
    slow_query_log=0
    long_query_time=1
    slow_query_log_file=/var/lib/mysql/slowq.log
    log-error=/var/log/mysqld.log
    
    # innodb settings
    ###innodb_extra_rsegments = 4
    innodb_purge_threads=1
    ##innodb_doublewrite = 1
    
    innodb_file_per_table = 1
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 48M
    ##innodb_additional_mem_pool_size = 32M
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 64M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    innodb_thread_concurrency = 0
    innodb_lock_wait_timeout=50
    #innodb_flush_method = O_DIRECT
    innodb_support_xa=1
    
    # 200 * # DISKS
    innodb_io_capacity = 100
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    
    # mariadb settings
    [mariadb]
    #thread-handling = pool-of-threads
    #thread-pool-size= 20
    #mysql --port=3307 --protocol=tcp
    #extra-port=3307
    #extra-max-connections=1
    
    userstat = 0
    key_cache_segments = 1
    aria_group_commit = none
    aria_group_commit_interval = 0
    aria_log_file_size = 32M
    aria_log_purge_type = immediate
    aria_pagecache_buffer_size = 8M
    aria_sort_buffer_size = 8M
    
    [mariadb-5.5]
    #ignore_db_dirs=
    query_cache_strip_comments=0
    
    innodb_read_ahead = linear
    innodb_adaptive_flushing_method = estimate
    innodb_flush_neighbor_pages = 1
    innodb_stats_update_need_lock = 0
    innodb_log_block_size = 512
    
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mysqld_safe]
    socket=/var/lib/mysql/mysql.sock
    log-error=/var/log/mysqld.log
    #nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 32M
    
    [myisamchk]
    key_buffer = 32M
    sort_buffer = 16M
    read_buffer = 16M
    write_buffer = 16M
    
    [mysqlhotcopy]
    interactive-timeout
    
    [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=2M
    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
    
    
    [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=2M
    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
    
     
  9. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    why is that this part was doubled?

    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=2M
    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
     
  10. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,758
    Local Time:
    11:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    which centmin mod version did you have ? looks like you ran mariadb 10 update when you already had mariadb 10

    if you used .08 beta it already was mariadb 10
     
  11. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    i was running MariaDB 10 prior to using .08, then updated MariaDB to 10.0.20 using .08 beta
     
  12. RoldanLT

    RoldanLT Well-Known Member

    3,828
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    9:35 AM
    1.11
    10.2
    You should just run yum update then :)
     
    • Like Like x 2
  13. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,758
    Local Time:
    11:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    yup yum update is proper way.. menu option 12 is only for major mysql updates like 5.5 to 10.0 or 10.0 to 10.1

    for you at least because you ran mariadb 10.0 before menu option 12 run, you can just copy and replace the backup file /etc/my.cnf-original_before_mariadb55upgrade at /etc/my.cnf and restart mysql

    Code:
    \cp -a /etc/my.cnf-original_before_mariadb55upgrade /etc/my.cnf
    mysqlrestart
    @Daniel J. Lewis won't be able to do that if he ran mariadb 5.5 prior to menu option 12 upgrade as /etc/my.cnf-original_before_mariadb55upgrade would be mariadb 5.5 settings only without mariadb 10 ones
     
    • Informative Informative x 1
  14. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    now I know, thanks @eva2000 and @RoldanLT

    Any advise how to make MySQL logs running back again?

    Can I delete the doubled lines I posted earlier on my.cnf?
     
  15. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,758
    Local Time:
    11:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    if you copy back the file like i suggested and restart mysql it should work
     
  16. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    @eva2000
    please correct me if I'm wrong
    the command copy the variables or contents in /etc/my.cnf-original_before_mariadb55upgrade
    to replace /etc/my.cnf ?
     
  17. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,758
    Local Time:
    11:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    yup \ disable alias on cp copy command and replace /etc/my.cnf with /etc/my.cnf-original_before_mariadb55upgrade
    Code:
    \cp -a /etc/my.cnf-original_before_mariadb55upgrade /etc/my.cnf
    then restart mysql
    Code:
    mysqlrestart
     
    • Informative Informative x 1
  18. quicksalad

    quicksalad Member

    159
    9
    18
    May 31, 2015
    Ratings:
    +13
    Local Time:
    7:05 AM
    • Like Like x 1
  19. Daniel J. Lewis

    Daniel J. Lewis Award-winning podcaster and consultant

    72
    8
    8
    Oct 20, 2014
    Ratings:
    +11
    Local Time:
    9:35 PM
    1.8.0
    5.6
    Coming back to this, the only changes I made to my.cnf were value changes, I think.

    Code:
    [mysqld]
    #character-set-server=utf8
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    #bind-address=127.0.0.1
    # optimized my.cnf for MariaDB 5.5.x
    # by eva2000
    # vbtechsupport.com
    
    tmpdir=/home/mysqltmp
    
    #skip-innodb
    skip-federated
    #skip-pbxt
    #skip-pbxt_statistics
    skip-archive
    #skip-name-resolve
    #old_passwords
    back_log = 75
    max_connections = 100
    key_buffer_size = 32M
    myisam_sort_buffer_size = 32M
    myisam_max_sort_file_size = 1024M
    join_buffer_size = 256K
    read_buffer_size = 64K
    sort_buffer_size = 256K
    table_definition_cache = 4096
    table_open_cache = 2048
    thread_cache_size = 64
    wait_timeout = 120
    connect_timeout = 10
    tmp_table_size = 96M
    max_heap_table_size = 96M
    max_allowed_packet = 32M
    max_seeks_for_key = 1000
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 512K
    bulk_insert_buffer_size = 8M
    query_cache_limit = 512K
    query_cache_size = 48M
    query_cache_type = 1
    query_cache_min_res_unit = 2K
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = MyISAM
    
    log_warnings=1
    slow_query_log=1
    long_query_time=1
    slow_query_log_file=/var/lib/mysql/slowq.log
    log-error=/var/log/mysqld.log
    
    # innodb settings
    #innodb_extra_rsegments = 4
    innodb_purge_threads=1
    innodb_doublewrite = 1
    
    innodb_file_per_table = 1
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 2100M
    innodb_additional_mem_pool_size = 32M
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 64M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    innodb_thread_concurrency = 0
    innodb_lock_wait_timeout=50
    #innodb_flush_method = O_DIRECT
    innodb_support_xa=1
    
    # 200 * # DISKS
    innodb_io_capacity = 100
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    
    # mariadb settings
    [mariadb]
    #thread-handling = pool-of-threads
    #thread-pool-size= 20
    #mysql --port=3307 --protocol=tcp
    #extra-port=3307
    #extra-max-connections=1
    
    userstat = 0
    key_cache_segments = 1
    aria_group_commit = none
    aria_group_commit_interval = 0
    aria_log_file_size = 32M
    aria_log_purge_type = immediate
    aria_pagecache_buffer_size = 8M
    aria_sort_buffer_size = 8M
    
    [mariadb-5.5]
    #ignore_db_dirs=
    query_cache_strip_comments=0
    
    innodb_read_ahead = linear
    innodb_adaptive_flushing_method = estimate
    innodb_flush_neighbor_pages = 1
    innodb_stats_update_need_lock = 0
    innodb_log_block_size = 512
    
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mysqld_safe]
    socket=/var/lib/mysql/mysql.sock
    log-error=/var/log/mysqld.log
    #nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 32M
    
    [myisamchk]
    key_buffer = 32M
    sort_buffer = 16M
    read_buffer = 16M
    write_buffer = 16M
    
    [mysqlhotcopy]
    interactive-timeout
     
  20. eva2000

    eva2000 Administrator Staff Member

    28,957
    6,575
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,758
    Local Time:
    11:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    do what quicksalad did and copy the backed up pre-upgrade my.cnf to /etc/my.cnf via command

    type in SSH
    Code:
    \cp -a /etc/my.cnf-original_before_mariadb55upgrade /etc/my.cnf
    
    then manually apply all the MariaDB 10 changes again to /etc/my.cnf and see what the resulting /etc/my.cnf looks like - if good restart mysql server

    type in SSH
    Code:
    sed -i 's/skip-pbxt/#skip-pbxt/g' /etc/my.cnf
    sed -i 's/innodb_use_purge_thread = 4/innodb_purge_threads=1/g' /etc/my.cnf
    sed -i 's/innodb_extra_rsegments/#innodb_extra_rsegments/g' /etc/my.cnf
    sed -i 's/innodb_adaptive_checkpoint/innodb_adaptive_flushing_method/g' /etc/my.cnf
    sed -i 's/innodb_additional_mem_pool_size/#innodb_additional_mem_pool_size/g' /etc/my.cnf
    sed -i 's/skip-innodb/innodb=ON/g' /etc/my.cnf
    echo "" >> /etc/my.cnf
    echo "" >> /etc/my.cnf
    echo "[mariadb-10.0]" >> /etc/my.cnf
    echo "# 2 variables needed to switch from XtraDB to InnoDB plugins" >> /etc/my.cnf
    echo "#plugin-load=ha_innodb" >> /etc/my.cnf
    echo "#ignore_builtin_innodb" >> /etc/my.cnf
    echo "" >> /etc/my.cnf
    echo "## MariaDB 10 InnoDB plugin only" >> /etc/my.cnf
    echo "#innodb_buffer_pool_load_now=1" >> /etc/my.cnf
    echo "#innodb_buffer_pool_dump_now=1" >> /etc/my.cnf
    echo "## Disabled settings" >> /etc/my.cnf
    echo "performance_schema=OFF" >> /etc/my.cnf
    echo "innodb_stats_on_metadata=OFF" >> /etc/my.cnf
    echo "innodb_sort_buffer_size=2M" >> /etc/my.cnf
    echo "innodb_online_alter_log_max_size=128M" >> /etc/my.cnf
    echo "query_cache_strip_comments=0" >> /etc/my.cnf
    echo "log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk" >> /etc/my.cnf