[mysqld] max_connections=50 datadir=/data/mysql socket=/var/lib/mysql/mysql.sock user=mysql ignore-builtin-innodb plugin-load=innodb=ha_innodb_plugin.so default-storage-engine=INNODB innodb_data_home_dir = /data/mysql innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql log-bin=/var/lib/mysql/zabbixdb-bin binlog_format=mixed relay-log=/var/lib/mysql/zabbixdb-relay-bin expire_logs_days=3 server-id=1 slave-skip-errors=1062 sort_buffer_size=64M table_definition_cache=256 table_open_cache=5000 read_buffer_size = 2M read_rnd_buffer_size = 16M query_cache_type=1 query_cache_size=128M query_cache_limit=1M query_cache_min_res_unit=2K max_heap_table_size=256MB tmp_table_size=256MB innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT innodb_max_dirty_pages_pct=90 join_buffer=64M innodb_buffer_pool_size=20G innodb_log_file_size=512M innodb_log_buffer_size=16M innodb_thread_concurrency=0 thread_cache_size=5 slow_query_log=1 slow_query_log_file=/var/log/mysql.slow.log long_query_time=1 innodb_file_per_table=1 transaction-isolation = READ-COMMITTED innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity=500 innodb_adaptive_flushing = 1 large_pages max_allowed_packet=128M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log_warnings=2