mysql threads too high
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.
Subject
Views
Written By
Posted
mysql threads too high
2491
October 11, 2012 06:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.