Dear all,
I've an error with message :
ERROR 1135: 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.
This error occured when trying to connect to MySQL Server.
Connection using TCP/IP.
here my.cnf :
This File was made using the WinMySQLAdmin 1.3 Tool
[mysqld]
basedir=C:/mysql
datadir=F:/MySQL/data
tmpdir=C:/mysql/temp
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128M
set-variable = flush_time=1800
set-variable = max_connect_error = 100000
set-variable = binlog_cache_size = 100000
innodb_data_file_path=ibdata1:50M;ibdata2:50M
innodb_data_home_dir=F:/MySQL/ibdata
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir=F:/MySQL/iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir=F:/MySQL/iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=350M
set-variable = lower_case_table_names=0
set-variable = innodb_additional_mem_pool_size=30M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-max-nt.exe
user=administrator
password=invalid
QueryInterval=10
Note :
I'm use the mysql with Windows 2000 SP2. This database im used with
Visual Basic 6.0 ADO.
I'm want tunning up the performance.
Mycomputer is :
PIII-1.13 Ghz
Memory RAM 1 Gb.
Harddisk 30 Gb SCSI
and
Athlon 700
Memory RAM 320 Mb.
Harddisk 20 GB IDE.
I want to ask the expert.
How the Configuration can meet my computer spesification ?.
Thanks
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
