$ cat /etc/mysql/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set = utf8 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp default_storage_engine = InnoDB lc_messages_dir = /usr/share/mysql lc_messages = en_US character_set_server = utf8 collation_server = utf8_general_ci skip-external-locking skip-name-resolve connect_timeout = 120 join_buffer_size = 1M key_buffer = 2M key_buffer_size = 61M log_warnings = 2 max_allowed_packet = 32M max_connect_errors = 30 max_connections = 30 max_user_connections = 30 myisam_sort_buffer_size = 1024K query_cache_limit = 128K query_cache_size = 64M query_cache_type = 1 read_buffer_size = 8M read_rnd_buffer_size = 4M sort_buffer_size = 128K bulk_insert_buffer_size = 128K table_open_cache = 64 table_definition_cache = 512 table_cache = 128 thread_stack = 256K thread_cache_size = 128 thread_concurrency = 8 wait_timeout = 3600 tmp_table_size = 64M max_heap_table_size = 128M low_priority_updates = 1 concurrent_insert = 2 max_tmp_tables = 16384 server-id = 8 myisam-recover = BACKUP #log_bin = /var/log/mysql/mariadb-bin #log_bin_index = /var/log/mysql/mariadb-bin.index #expire_logs_days = 1 #max_binlog_size = 100M open_files_limit = 196608 #slow_query_log = 1 #long_query_time = 10 #slow_query_log_file = /var/log/mysql/sql-slow-query.log #log_queries_not_using_indexes # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! sql_mode = NO_ENGINE_SUBSTITUTION # you can't just change log file size, requires special procedure #innodb_log_file_size = 50M innodb_buffer_pool_size = 61M innodb_log_buffer_size = 4M innodb_file_per_table = 1 innodb_open_files = 256 innodb_io_capacity = 512 innodb_flush_method = O_DIRECT innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 8 #innodb_lazy_drop_table = 1 innodb_lock_wait_timeout = 120 [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 open_files_limit = 196608 syslog [mysqldump] quick max_allowed_packet = 32M quote-names [mysql] no-auto-rehash [myisamchk] key_buffer = 1M sort_buffer_size = 64K read_buffer = 4M write_buffer = 4M [isamchk] key_buffer = 1M sort_buffer_size = 64K read_buffer = 4M write_buffer = 4M [mysqlhotcopy] interactive-timeout !includedir /etc/mysql/conf.d/ $