Performance Issues - errno 12 on MySQL5.0.45/Windows Server 2003
Posted by:
Chris E
Date: May 19, 2009 04:58AM
Hi,
We've recently been encountering a number of error number 12 (Error Message: "Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug.") on our Windows web server which runs both MySQL 5.0.45 database server and MS IIS V6.0. This has only started occurring over the past couple of weeks (the server has actually run faultlessly under higher load for many months previously) and whilst we will in due course upgrade to the latest distribution of MySQL, we'd prefer not to at this stage as it will involve not insignificant downtime on our live server.
We've been able to reduce the occurences by changing the MySQL server configuration within the my.ini file although we're still experiencing the problem intermittently. Most (95%+) of our interaction with the MySQL is done via ASP using the MySQL Connector/ODBC 5.1 with a small amount of usage through the command-line client on the server.
We've noticed that the problem typically occurs when there are 17 or 18 lines within the output of SHOW PROCESSLIST. Reducing the wait_timeout from 460 to 10 and then to 5 seconds has limited the occurrences we're experiencing though it does still remain an issue.
Our my.ini file contains the following settings:-
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
default-character-set=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=50
query_cache_size=32M
table_cache=256
tmp_table_size=18M
thread_cache_size=16
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=35M
key_buffer_size=25M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=1500M
innodb_log_file_size=24M
innodb_thread_concurrency=24
wait_timeout=5
Our my.ini changes have been:-
* Thread cache increased 8 - 16
* Max connections decreased 200 - 50
* Increased thread concurrency 10-24
* Reduced wait_timeout 460 to 10 sec
* Reduced wait_timeout 10 to 5 sec
Our server specification is:-
* Intel Xeon 5150 2.66GHz
* 4GB RAM
* Microsoft Windows Server 2003 SP2
* MySQL Community Edition 5.0.45
Any help or guidance would be much appreciated.
Subject
Views
Written By
Posted
Performance Issues - errno 12 on MySQL5.0.45/Windows Server 2003
5649
May 19, 2009 04:58AM
2244
May 19, 2009 07:28AM
2208
May 19, 2009 10:25AM
2229
May 19, 2009 08:02PM
2186
May 20, 2009 05:44AM
2207
May 20, 2009 08:51AM
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.