From: Tal Ben-Gal Date: October 11 2012 2:07pm Subject: RE: mysql threads too high List-Archive: http://lists.mysql.com/win32/19177 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_000_A7F7E84BE5ED044582D483B279807C4A0B3728DDPPC1MXMBX004ppc_" --_000_A7F7E84BE5ED044582D483B279807C4A0B3728DDPPC1MXMBX004ppc_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks, I try to change it but it made no different, after 1250 mysql threa= ds, no one can connect to the database. In the new ini: max_connections=3D3510 myisam_max_sort_file_size=3D25G ________________________________ From: Andr=E9s Tello [mr.criptos@stripped] Sent: 11 October 2012 14:51 To: Tal Ben-Gal Cc: win32@stripped Subject: Re: mysql threads too high 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 > 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=3D3306 [mysql] default-character-set=3Dlatin1 [mysqld] port=3D3306 basedir=3D"E:/Program Files/MySQL/MySQL Server 5.5/" datadir=3D"E:/Program Files/MySQL/MySQL Server 5.5/data/" character-set-server=3Dlatin1 default-storage-engine=3DINNODB sql-mode=3D"STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=3D5510 table_cache=3D512 open-files-limit=3D4096 tmp_table_size=3D32M thread_cache_size=3D16 #*** MyISAM Specific options myisam_max_sort_file_size=3D100G myisam_sort_buffer_size=3D12M key_buffer_size=3D8M read_buffer_size=3D64K read_rnd_buffer_size=3D256K sort_buffer_size=3D256K #*** INNODB Specific options *** innodb_additional_mem_pool_size=3D8M innodb_flush_log_at_trx_commit=3D1 innodb_log_buffer_size=3D4M innodb_buffer_pool_size=3D512M innodb_log_file_size=3D71M innodb_thread_concurrency=3D26 slow_query_log=3D1 long_query_time=3D1000 expire_logs_days=3D3 thread_stack=3D192k table_definition_cache =3D 1048 innodb_thread_sleep_delay=3D5000 query_cache_size=3D45M query_cache_type=3D1 back_log=3D50 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 cli= ents of ben-gal.net may contain information that is con= fidential and legally privileged. Please do not read, copy, forward, or sto= re this message unless you are an intended recipient of it. If you have rec= eived this message in error, please forward it to the sender and delete it = completely from your computer system. For more information please e-mail ta= l@stripped 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 cli= ents of ben-gal.net may contain information that is confidential and legall= y privileged. Please do not read, copy, forward, or store this message unle= ss you are an intended recipient of it. If you have received this message i= n error, please forward it to the sender and delete it completely from your= computer system. For more information please e-mail tal@stripped --_000_A7F7E84BE5ED044582D483B279807C4A0B3728DDPPC1MXMBX004ppc_--