centos 6查看mysql配置文件_mysql5.5在centos6上的配置文件

[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

来源:http://www.realzyy.com/?p=1582

本文原创发布php中文网，转载请注明出处，感谢您的尊重！