Untitled 1/26/2020 2:56:31 AM

[mysqld] #default-character-set=utf8 user=mysql pid-file=/var/run/mysqld/mysqld.pid socket=/var/run/mysqld/mysqld.sock port=693 basedir=/usr datadir=/var/lib/mysql tmpdir=/tmp #bind-address=127.0.0.1 skip-external-locking #skip-locking skip-name-resolve skip-show-database init_connect="SET collation_connection=utf8_unicode_ci" character-set-server=utf8 collation-server=utf8_unicode_ci character_set_server = utf8 collation_server = utf8_general_ci connect_timeout=10 max_connections=200 max_allowed_packet=128M thread_cache_size=8 thread_stack=512K open_files_limit=20000 #table_open_cache=8192 table_open_cache=16384 table_definition_cache=8192 wait_timeout=10800 net_read_timeout=60 net_write_timeout=60 tmp_table_size=12M query_cache_size=0 query_cache_limit=0 #disabled #query_cache_size=8M #query_cache_limit=1M key_buffer_size=64M # was 256M ok join_buffer_size=16M sort_buffer_size=1M read_buffer_size=64K read_rnd_buffer_size=128K bulk_insert_buffer_size=64K general_log_file=/var/log/mysql/query.log general_log=0 slow_query_log_file=/var/log/mysql/slow.log long_query_time=2 log-queries-not-using-indexes=0 slow-query-log=1 log-error=/var/log/mysql/error.log #log-warning=2 expire_logs_days=10 #skip-bdb skip-federated #ignore_builtin_innodb default_storage_engine=InnoDB innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT #innodb_buffer_pool_size=5000M innodb_buffer_pool_size=9G #need 27 innodb_additional_mem_pool_size=20M innodb_file_per_table=1 innodb_file_format=Barracuda innodb_log_buffer_size=24M #was 22 ok # was 16 [!!] InnoDB log waits: 10 #innodb_log_file_size=1024M innodb_log_file_size=1G #innodb_use_sys_malloc=0 innodb_thread_concurrency=4 #innodb_locks_unsafe_for_binlog=1 #innodb_force_recovery=4