mysql5.5在centos6上的配置文件
程序员文章站
2022-05-20 22:18:34
...
[mysqld_safe]pid-file=/mysql/myPORT/run/mysqld.pid[mysql]port=PORTprompt=\\u@\\d \\r:\\m:\\sdefault-character-set=gbk[client]port=PORTsocket=/mysql/myPORT/run/mysql.sock[mysqld]#dirbasedir=/mysql/myPORTdatadir=/mysql/myPORT/datatmpdir=/mys
[mysqld_safe] pid-file=/mysql/myPORT/run/mysqld.pid [mysql] port=PORT prompt=\\u@\\d \\r:\\m:\\s> default-character-set=gbk [client] port=PORT socket=/mysql/myPORT/run/mysql.sock [mysqld] #dir basedir=/mysql/myPORT datadir=/mysql/myPORT/data tmpdir=/mysql/myPORT/tmp lc_messages_dir=/usr/share log-error=/mysql/myPORT/log/alert.log slow_query_log_file=/mysql/myPORT/log/slow.log socket=/mysql/myPORT/run/mysql.sock #innodb innodb_data_home_dir=/mysql/myPORT/log/iblog innodb_log_group_home_dir=/mysql/myPORT/log/iblog innodb_buffer_pool_size=INNODB_BUFFER_POOL_SIZE innodb_buffer_pool_instances=8 innodb_log_files_in_group=4 innodb_log_file_size=1G innodb_log_buffer_size=64M innodb_flush_log_at_trx_commit=1 innodb_additional_mem_pool_size=20M innodb_max_dirty_pages_pct=60 innodb_io_capacity=INNODB_IO_CAPACITY innodb_thread_concurrency=THREADBY4 innodb_read_io_threads=THREAD innodb_write_io_threads=THREAD innodb_open_files=60000 innodb_file_format=Barracuda innodb_file_per_table=1 innodb_flush_method=O_DIRECT innodb_flush_neighbor_pages=0 innodb_change_buffering=inserts innodb_adaptive_flushing=1 innodb_adaptive_flushing_method=keep_average innodb_adaptive_hash_index_partitions=8 innodb_old_blocks_time=1000 innodb_fast_checksum=1 innodb_stats_on_metadata=0 innodb_lazy_drop_table=1 innodb_read_ahead="linear" innodb_use_native_aio=1 innodb_lock_wait_timeout=5 innodb_rollback_on_timeout=0 #innodb_strict_mode=1 transaction-isolation=READ-COMMITTED #myisam key_buffer=64M myisam_sort_buffer_size=64M concurrent_insert=2 delayed_insert_timeout=300 #replication master-info-file=/mysql/myPORT/log/master.info relay-log=/mysql/myPORT/log/relaylog relay_log_info_file=/mysql/myPORT/log/relay-log.info slave_load_tmpdir=/mysql/myPORT/tmp slave_type_conversions="ALL_NON_LOSSY" slave_net_timeout=4 skip-slave-start #binlog log-bin=/mysql/myPORT/log/binlog server_id=1153668 binlog_cache_size=32K max_binlog_cache_size=2G max_binlog_size=500M binlog-format=ROW sync_binlog=1 log-slave-updates expire_logs_days=7 #server default-storage-engine=INNODB character-set-server=gbk lower_case_table_names=1 skip-external-locking open_files_limit=65536 safe-user-create local-infile=0 #sqlmod="STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE" performance_schema=0 log_slow_admin_statements=1 log_slow_verbosity=full log_warnings=1 long_query_time=1 slow_query_log=1 query_cache_type=0 query_cache_limit=1M query_cache_min_res_unit=1K table_definition_cache=65536 table_cache=65536 thread_stack=512K thread_cache_size=256 read_rnd_buffer_size=128K sort_buffer_size=256K join_buffer_size=128K read_buffer_size=128K port=PORT skip-name-resolve skip-ssl max_connections=8192 max_user_connections=8000 max_connect_errors=65536 max_allowed_packet=128M max_long_data_size=128M connect_timeout=8 net_read_timeout=30 net_write_timeout=60 back_log=1024
来源:http://www.realzyy.com/?p=1582