.mytop : db=mysql idle=0 sort=1 usercol_width=8 dbcol_width=13 fullqueries=1 my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [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 = /tmpfs slave-load-tmpdir = /tmp lc_messages_dir = /usr/share/mysql lc_messages = en_US skip-external-locking skip-name-resolve max_connections = 1024 max_allowed_packet = 1G thread_cache_size = 64 bulk_insert_buffer_size = 256M tmp_table_size = 4G max_heap_table_size = 4G wait_timeout = 7200 connect_timeout = 60 myisam_recover = BACKUP key_buffer_size = 16G open-files-limit = 160000 table_open_cache = 8196 table_definition_cache = 8196 myisam_sort_buffer_size = 512M concurrent_insert = 2 read_buffer_size = 2M read_rnd_buffer_size = 8M log_error = /var/log/mysql/error.log log_warnings = 2 slow_query_log = 0 slow_query_log_file = /var/log/mysql/mariadb-slow.log long_query_time = 4 log_slow_verbosity = query_plan server-id = 108 report_host = XXX expire_logs_days = 10 max_binlog_size = 500M read_only default_storage_engine = InnoDB innodb_file_format = Barracuda innodb_log_file_size = 1500M innodb_buffer_pool_size = 96G innodb_log_buffer_size = 16M innodb_file_per_table = 1 innodb_open_files = 800 innodb_flush_method = O_DIRECT innodb_additional_mem_pool_size = 80M innodb_flush_log_at_trx_commit = 2 innodb_lock_wait_timeout = 30 aria_pagecache_buffer_size = 8G innodb_autoinc_lock_mode = 2 delay_key_write = ON group_concat_max_len = 5000 innodb_file_format = Barracuda key_cache_segments = 16 thread_handling = pool-of-threads thread_pool_max_threads = 1500 extra_port = 3307 extra-max-connections = 20 key_cache_block_size = 4K myisam_block_size = 4K mrr_buffer_size = 8M join_cache_level = 6 join_buffer_space_limit = 32M join_buffer_size = 2M transaction-isolation = READ-COMMITTED event_scheduler = 0 innodb_io_capacity = 1200 innodb_flush_neighbor_pages = none innodb_old_blocks_time = 1000 binlog_cache_size = 8388608 binlog_stmt_cache_size = 8388608 group_concat_max_len = 4096 replicate-ignore-table = A_FEDERATED_TABLE federated slave-skip-errors = 1030,1159,1062,1032