mysql threads too high
Posted by: Tal Ben-Gal
Date: October 11, 2012 06:23AM

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.

Options: ReplyQuote


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.