mysql 连接数疯长_MYSQL 连接数过多造成挂掉

MYSQL 配置文件

写道

user = mysql

port = 3306

socket = /tmp/mysql.sock

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

open_files_limit = 3072

back_log = 200

max_connections = 600

max_connect_errors = 512

table_cache = 307

external-locking = FALSE

#max_allowed_packet = 512M

sort_buffer_size = 2M

join_buffer_size = 2M

thread_cache_size = 26

thread_concurrency = 8

query_cache_size = 512M

query_cache_limit = 2M

#query_cache_min_res_unit = 2k

default_table_type = MyISAM

thread_stack = 192K

transaction_isolation = READ-COMMITTED

tmp_table_size = 61M

max_heap_table_size = 61M

#/usr/local/mysql/data/slow.log

#/usr/local/mysql/data/error.log

#long_query_time = 1

#log-slow-queries = /web/mysql-slow.log

log_long_format

server-id = 1

log-bin = /usr/local/mysql/data/binlog

binlog_cache_size = 4M

max_binlog_cache_size = 8M

max_binlog_size = 512M

#expire_logs_days = 3

key_buffer_size = 1024M

read_buffer_size = 4M

read_rnd_buffer_size = 16M

bulk_insert_buffer_size = 64M

myisam_sort_buffer_size = 512M

myisam_max_sort_file_size = 10G

myisam_max_extra_sort_file_size = 10G

myisam_repair_threads = 1

myisam_recover

wait-timeout = 150

interactive-timeout = 250

skip-locking

skip-name-resolve

我的myslq设置

分享到：

2011-10-25 10:40

浏览 1688

分类:数据库

评论