MySQL. I configured 5000 connections but when arriving in 4096 it presents the errors below.
MySQL Connection Failed: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug
It follows below the configuration of the Server and the archive my.cnf
Somebody has an idea of as can have 5000 simultaneous connections without problems?
MemTotal: 2064404 kB Intel Dual processors 2.4 Ghz HT S.O Red Hat 9.0 Kernel 2.4.20-30.9smp
set-variable = max_connections=5000 set-variable = key_buffer=32M set-variable = max_allowed_packet=2M set-variable = table_cache=128 set-variable = sort_buffer=1024K set-variable = net_buffer_length=16K set-variable = myisam_sort_buffer_size=16M #set-variable = log=mysql.log log-bin server-id = 1
# Point the following paths to different dedicated disks #tmpdir = /tmp/
# Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /usr/local/mysql/data/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data/ innodb_log_arch_dir = /usr/local/mysql/data/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high set-variable = innodb_buffer_pool_size=1024M set-variable = innodb_additional_mem_pool_size=4M # Set .._log_file_size to 25 % of buffer pool size set-variable = innodb_log_file_size=110M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50[mysqldump] quick set-variable = max_allowed_packet=32M
[mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates
[isamchk] set-variable = key_buffer=40M set-variable = sort_buffer=40M set-variable = read_buffer=4Mset-variable = write_buffer=4M
[myisamchk] set-variable = key_buffer=40M set-variable = sort_buffer=40M set-variable = read_buffer=4M set-variable = write_buffer=4M
[mysqlhotcopy] interactive-timeout
Daniel Brazil
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
