JezK
Edit File: my.cnf
[client-server] !includedir /etc/my.cnf.d [mysqld] # Preserve the server-specific error-log path currently used by ng-shost106. log-error = /var/lib/mysql/ng-shost102.tenten.vn.err performance-schema = 0 symbolic-links = 0 # InnoDB innodb_buffer_pool_size = 80G innodb_file_per_table = 1 innodb_log_buffer_size = 64M innodb_io_capacity = 2000 innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT # Connections max_connections = 1000 max_user_connections = 30 thread_cache_size = 100 wait_timeout = 30 interactive_timeout = 30 connect_timeout = 10 net_read_timeout = 30 net_write_timeout = 60 # Per-connection and MyISAM buffers sort_buffer_size = 1M read_buffer_size = 512K read_rnd_buffer_size = 256K join_buffer_size = 256K key_buffer_size = 16M myisam_sort_buffer_size = 16M # Temporary tables and table cache tmp_table_size = 64M max_heap_table_size = 64M table_open_cache = 4000 open_files_limit = 10000 # Query cache and parser allocation query_cache_type = 0 query_cache_size = 0 query_cache_limit = 0 query_prealloc_size = 64K query_alloc_block_size = 16K # Other limits and buffers max_allowed_packet = 268435456 bulk_insert_buffer_size = 4M max_connect_errors = 100 concurrent_insert = 2 max_write_lock_count = 8 net_buffer_length = 16K transaction_alloc_block_size = 8K transaction_prealloc_size = 4K # Logging behavior; retain ng-shost106's own default slow-log path. slow_query_log = 1 long_query_time = 1 # Keep socket authentication disabled. The former plugin-load-add directive # is intentionally omitted because auth_socket.so is absent on ng-shost106. unix_socket = OFF [myisamchk] key_buffer_size = 64M sort_buffer_size = 64M read_buffer = 8M write_buffer = 8M thread_stack = 256K