首页 > 代码库 > mysql /etc/my.cnf

mysql /etc/my.cnf

[client]
port=3306
socket = /tmp/mysql.sock
default-character-set=utf8
[mysqld]

# 1 general config

port=3306
socket  = /tmp/mysql.sock
datadir = /u02/mysql
binlog_cache_size = 1M
default-storage-engine = innodb
event_scheduler = 1
federated
join_buffer_size = 16M
local-infile=1
#log-slow-queries=/u02/mysql/aslowquery.log
long_query_time = 10
slow_query_log
lower_case_table_names=1
max_heap_table_size = 256M
max_length_for_sort_data = http://www.mamicode.com/2048>

 

mysql /etc/my.cnf