MySql 5.5.28 On windows 2003 server 12GB memory
Every time the MySql threads (in task manager) going above 1250, new users can't connect
to the database
My.ini:
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
basedir="E:/Program Files/MySQL/MySQL Server 5.5/"
datadir="E:/Program Files/MySQL/MySQL Server 5.5/data/"
character-set-server=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=5510
table_cache=512
open-files-limit=4096
tmp_table_size=32M
thread_cache_size=16
#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=12M
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#*** INNODB Specific options ***
innodb_additional_mem_pool_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=4M
innodb_buffer_pool_size=512M
innodb_log_file_size=71M
innodb_thread_concurrency=26
slow_query_log=1
long_query_time=1000
expire_logs_days=3
thread_stack=192k
table_definition_cache = 1048
innodb_thread_sleep_delay=5000
query_cache_size=45M
query_cache_type=1
back_log=50
Please, Please HELP!
Tal.
This e-mail message is intended to be received only by persons entitled to receive the
confidential information it may contain. E-mail messages to clients of ben-gal.net may
contain information that is confidential and legally privileged. Please do not read,
copy, forward, or store this message unless you are an intended recipient of it. If you
have received this message in error, please forward it to the sender and delete it
completely from your computer system. For more information please e-mail tal@stripped
