Zabbix Server和MPM(monitor for mysql)的高速部署
# cat my.cnfport = 3306
socket = /tmp/mysql.sock
#The MySQL Server
#########Basic######
server-id = 1
port = 3306
user = mysql
basedir = /usr/
datadir = /var/lib/mysql
tmpdir = /var/lib/mysql/tmp
socket = /tmp/mysql.sock
skip-external-locking
skip-name-resolve
default-storage-engine = INNODB
character-set-server = utf8
wait_timeout = 100
connect_timeout = 20
interactive_timeout = 100
back_log = 500
event_scheduler = on
explicit_defaults_for_timestamp
#skip-grant-tables
#############binlog##############
log-bin = /var/lib/mysql/logs/mysql-bin
binlog_format = row
max_binlog_size = 128M
binlog_cache_size = 4M
expire_logs_days = 5
##############Slow log####################
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/logs/mysql.slow
long_query_time = 2
###############Per_Thread_Buffers########################
max_connections = 1024
max_user_connections = 1000
max_connect_errors = 10000
key_buffer_size = 32M
max_allowed_packet = 128M
table_open_cache = 3096
table_definition_cache = 4096
sort_buffer_size = 512K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
join_buffer_size = 512K
tmp_table_size = 16M
max_heap_table_size = 16M
query_cache_type = 0
query_cache_size = 0
bulk_insert_buffer_size = 16M
thread_cache_size = 64
thread_stack = 256K
################InnoDB#########################
innodb_data_home_dir = /var/lib/mysql
innodb_autoinc_lock_mode = 2
innodb_log_group_home_dir = /var/lib/mysql/logs
innodb_data_file_path = ibdata1:1G:autoextend
innodb_buffer_pool_size = 256M
innodb_buffer_pool_instances = 1
innodb_log_file_size = 64M
innodb_log_buffer_size = 4M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 10
innodb_sync_spin_loops = 40
innodb_max_dirty_pages_pct = 90
innodb_support_xa = 1
innodb_thread_concurrency = 0
innodb_thread_sleep_delay = 500
innodb_file_io_threads = 4
innodb_concurrency_tickets = 1000
log_bin_trust_function_creators = 1
innodb_flush_method = O_DIRECT
innodb_file_per_table
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_io_capacity = 2000
innodb_file_format = Barracuda
innodb_purge_threads = 1
innodb_purge_batch_size = 32
innodb_old_blocks_pct = 75
innodb_change_buffering = all
transaction_isolation = READ-COMMITTED
页:
[1]