From: Andrés Tello
Date: October 11 2012 1:51pm
Subject: Re: mysql threads too high
List-Archive: http://lists.mysql.com/win32/19176
Message-Id: <CAErsY8uskEjX-EyEBEeZH3=89w83JZH=2d8C+O=s_ZEDRKb1mw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=e89a8f3ba0374e73f804cbc8df21

--e89a8f3ba0374e73f804cbc8df21
Content-Type: text/plain; charset=ISO-8859-1

*I bet you are pushing the S:O Limits...
http://blogs.technet.com/b/markrussinovich/archive/2009/07/08/3261309.aspx

Also, do you really need 5510 connections and 100G max sort file size?
Those numbers alone are seems enough to consume all your memory...

*Take a look here.
http://dev.mysql.com/doc/refman/5.0/en/memory-use.html




On Thu, Oct 11, 2012 at 6:39 AM, Tal Ben-Gal <tal@stripped> wrote:

> 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
>

--e89a8f3ba0374e73f804cbc8df21--