为什么mysql最大连接数始终都是265？

jiangyonghe

操作系统centos4.4,mysql5.0.25

./webbench -c 1500 -t 30 做压力测试时mysql的最大连接数始终都是265？

my.cnf 如下：

[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock
default-character-set = gbk

[mysqld_safe]
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/data/mysql_error.log
pid-file = /usr/local/mysql/data/mysql.pid
           
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
default-character-set = gbk
#init_connect = 'SET NAMES gbk'
skip-locking
#skip-slave-start
key_buffer = 512M
max_allowed_packet = 2M
table_cache = 1024
sort_buffer_size = 32M
read_buffer_size = 2M
read_rnd_buffer_size = 32M
max_length_for_sort_data = 64
myisam_sort_buffer_size = 128M
thread_cache = 8
query_cache_size = 64M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
#skip-name-resolve
set-variable = max_connections=1000
open_files_limit = 51200
ft_min_word_len = 1

low_priority_updates = 1
slave-skip-errors = 1032,1062,126
server-id       = 9
[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

是不是操作系统哪里还有限制啊？

kevinbin

贴上你的测试结果  或许是apache上限制了

Coolriver

你所说的MySQL的最大连接数为265是怎么得到的？
我也没看到你在my.cnf中定义你的连接数。

stormcc

show variables like 'max_connections' ;

聪明笨小孩

也许程序里写了，初始化 就分配256个连接在那里！