mysql最大连接数512_my.cnf加大MYSQL最大连接数

[mysqld] 学易

set-variable = key_buffer=512M

set-variable = max_allowed_packet=4M

set-variable = table_cache=1024

set-variable = thread_cache=64

set-variable = join_buffer_size=32M

set-variable = sort_buffer=32M

set-variable = record_buffer=32M

set-variable = max_connections=512

set-variable = wait_timeout=120

set-variable = interactive_timeout=120

set-variable = max_connect_errors=30000

set-variable = long_query_time=1

set-variable = max_heap_table_size=256M

set-variable = tmp_table_size=128M

set-variable = thread_concurrency=8

set-variable = myisam_sort_buffer_size=128M

#/mysql所在路径bin/mysqladmin -uroot -p variables