Edit File: my.cnf
# Ansible managed [mysqld] plugin_load_add = ha_rocksdb plugin_load_add = cgroup basedir = /srv/mariadb1186/usr large-pages = on datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock bind_address = * myisam_recover_options = backup,quick,force port = 3306 transaction-isolation = read-committed cgroup_enabled = True pid-file = /var/lib/mysql/mysql.pid local-infile = 0 tmpdir = /var/lib/mysqltmp tmp_table_size = 386M max_heap_table_size = 386M innodb_flush_method = O_DIRECT innodb_buffer_pool_size = 108018427494 max_allowed_packet = 1G query_cache_type = 0 max_connections = 2000 interactive_timeout = 20 wait_timeout = 20 connect_timeout = 20 thread_cache_size = 96 key_buffer_size = 2G max_connect_errors = 5 open_files_limit = 30000000 collation_server = utf8mb4_unicode_ci character_set_server = utf8mb4 table_definition_cache = 2M innodb_strict_mode = 0 sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION log_warnings = 1 innodb_purge_threads = 4 skip-character-set-client-handshake skip-name-resolve userstat = 1 tmp_disk_table_size = 1536M ssl-ca = /var/lib/mysql/ssl/tls-ca-bundle.pem ssl-cert = /var/lib/mysql/ssl/hostinger.crt ssl-key = /var/lib/mysql/ssl/hostinger.key innodb_log_file_size = 30G innodb_flush_log_at_trx_commit = 2 table_open_cache = 50K innodb_buffer_pool_dump_pct = 90 query_cache_size = 0 aria_pagecache_buffer_size = 1G join_buffer_size = 8M innodb_io_capacity = 2000 innodb_io_capacity_max = 4000 innodb_log_write_ahead_size = 4096 innodb_flush_neighbors = 0 innodb_read_io_threads = 32 innodb_write_io_threads = 32 key_cache_segments = 64 innodb_undo_tablespaces = 3 innodb_undo_log_truncate = True max_user_connections = 75 group_concat_max_len = 10485760 core_file rocksdb_allow_to_start_after_corruption = 0 rocksdb_block_cache_size = 5368709120 rocksdb_bulk_load = 0 rocksdb_flush_log_at_trx_commit = 2 rocksdb_merge_buf_size = 67108864 rocksdb_max_row_locks = 1M rocksdb_max_total_wal_size = 3G rocksdb_validate_tables = 0 max_prepared_stmt_count = 100000 slow_query_log = True log_output = TABLE log_slow_query_time = 3 log_slow_min_examined_row_limit = 300000 log_queries_not_using_indexes = False innodb_log_buffer_size = 30G performance_schema = on extra_port = 3300 extra_max_connections = 100 innodb_adaptive_flushing_lwm = 25 innodb_max_dirty_pages_pct = 70 transaction_prealloc_size = 8192 innodb_autoextend_increment = 48 thread_stack = 524288 optimizer_search_depth = 0 symbolic-links = 0 innodb_data_file_buffering = True # Try these if performance is lacking #thread_handling = pool-of-threads #myisam_sort_buffer_size = 64M #sort_buffer_size = 2M #read_buffer_size = 2M #read_rnd_buffer_size = 8M [client] default-character-set = utf8mb4 ssl-verify-server-cert = False [safe_mysqld] pid-file = /var/lib/mysql/mysql.pid open_files_limit = 30000000 [mysqldump] quick max_allowed_packet = 1G [mysql] no-auto-rehash sandbox = true default-character-set = utf8mb4 character_sets_dir = /srv/mariadb1186/usr/share/mysql
Back