MySQL Forums
Forum List  »  Performance

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Performance Issues - errno 12 on MySQL5.0.45/Windows Server 2003
5649
May 19, 2009 04:58AM


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.