[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
#thread_stack=128KB
#set-variable = table-type=innodb
default-table-type = innodb
port = 3306
socket = /var/lib/mysql/mysql.sock
max_connections = 910
max_connect_errors = 9999999
skip-locking
skip-innodb_doublewrite
key_buffer = 384M
max_allowed_packet = 4M
table_cache = 2049
sort_buffer_size = 12M
read_buffer_size = 12M
myisam_sort_buffer_size = 64M
thread_cache = 48
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
# Master Replication
# ------------------
#log-bin
#server-id=1
# My Inno DB tables
# -----------------
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir =
innodb_data_file_path =
/data1/ibdata1:2000M;/data1/ibdata2:2000M;/data1/ibdata3:2000M;/data1/ibdata4:2000M;/data2/ibdata5:2000M;/data2/ibdata6:2000M;/data2/ibdata7:2000M;/data2/ibdata8:2000M;/data3/ibdata9:2000M;/data3/ibdata10:2000M;/data3/ibdata11:2000M;/data3/ibdata12:2000M;/data4/ibdata13:2000M;/data4/ibdata14:2000M;/data4/ibdata15:2000M;/data4/ibdata16:2000M;/data5/ibdata17:2000M;/data5/ibdata18:2000M;/data5/ibdata19:2000M;/data5/ibdata20:2000M;
# ------ OLD ---
innodb_log_group_home_dir = /data1
innodb_log_arch_dir = /data1
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 1300M
innodb_additional_mem_pool_size = 80M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 20
innodb_table_locks=0
transaction-isolation = REPEATABLE-READ
Javier Armendáriz wrote:
Can you tell us about your config parameters?????
Probably you must set up your max_connections, max_user_connections
http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
Ady Wicaksono escribió:
I have MySQL 5 installed on My Machine,
But it could handle only max about 350 concurrent mysql connection
Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always
got Can't create a new thread (errno 12); if you are not out of
available memory, you can consult the manual for
a possible OS-dependent bug in
Is it mysql bug, incorrect Linux setting or what?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
