[client] port = 3307 socket = /opt/mariadb-data/mariadb.sock [mysqld] port = 3307 socket = /opt/mariadb-data/mariadb.sock user = mariadb datadir = /opt/mariadb-data basedir = /opt/mariadb skip-external-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #mine log-error=/opt/mariadb-data/mariadb.err general_log = 1 general_log_file=/opt/mariadb-data/mariadb.log log-bin=mysql-bin binlog_format=mixed server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout