mariadb - my.cnf一般配置

    [server]
    [mysqld_safe]
    log-error=/opt/abc/logs/mariadb/error.log
    [mysqld]
    skip-name-resolve
    log-bin=mysql-bin
    server-id=1
    sync_binlog=1
    innodb_flush_log_at_trx_commit=1
    binlog_format=mixed
    character_set_server=utf8
    slow_query_log=on
    long_query_time=2
    log-error=/opt/abc/logs/mariadb/error.log
    key_buffer_size=256
    max_allowed_packet=4M
    thread_stack=256K
    table_cache=128K
    sort_buffer_size=6M
    read_buffer_size=4M
    wait_timeout=86400
    thread_concurrency=8
    max_connections=100000
    lower_case_table_names=1
    user=abc
    basedir=/opt/abc/mariadb/
    datadir=/opt/abc/mariadb/data/
    socket=/opt/abc/mariadb/mysql.sock
    pid_file=/opt/abc/mariadb/mysql.pid
    lc-messages-dir=/opt/abc/mariadb/share/english/
    relay_log=relay-bin
    [galera]
    [embedded]
    [mariadb]
    [mariadb-10.1]