List:MySQL on Win32« Previous MessageNext Message »
From:Tal Ben-Gal Date:October 11 2012 11:39am
Subject:mysql threads too high
View as plain text  
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

Thread
mysql threads too highTal Ben-Gal11 Oct
  • Re: mysql threads too highAndrĂ©s Tello11 Oct
    • RE: mysql threads too highTal Ben-Gal11 Oct
      • Re: mysql threads too highShawn Green11 Oct
        • RE: mysql threads too highTal Ben-Gal12 Oct
          • RE: mysql threads too highTal Ben-Gal23 Oct
            • RE: mysql threads too highJorge Bastos23 Oct
              • RE: mysql threads too highTal Ben-Gal23 Oct
                • Re: mysql threads too highShawn Green23 Oct
                  • RE: mysql threads too highTal Ben-Gal23 Oct
                    • Re: mysql threads too highShawn Green23 Oct
                      • RE: mysql threads too highTal Ben-Gal23 Oct
                        • RE: mysql threads too highTal Ben-Gal24 Oct