Zabbix Server和MPM(monitor for mysql)的高速部署

视频的容积

[iyunv@linux-zabbix etc]# cat my.cnf　　
[client]
　　
port = 3306
　　
socket = /tmp/mysql.sock
　　

　　
#The MySQL Server
　　
#########Basic######
　　
[mysqld]
　　
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