Hi,
Advertising
I'm running MySQL 5 on a Win2K3 machine (2x3.2Ghz 4Gb RAM) Lately I experience some heavy login problems, "Can't connect to MySQL server on 'localhost' (10048)" and Service error "ERROR: 10060 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. (connection time: 5 sec)". I'm trying to connect thru PHP5. This happens like 200-300 times a day. Please help me with my configuration. // Joakim Status: Uptime: 497170 Threads: 12 Questions: 27327337 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 64 Queries per second avg: 54.966 My.ini: safe-show-database port=3307 join_buffer_size=1M 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=MyISAM max_connections=2000 max_user_connections=200 query_cache_size=32M query_cache_limit=1M query_cache_type=1 table_cache=1024 tmp_table_size=64M thread_cache_size=64 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=64M key_buffer=64M key_buffer_size=129M read_buffer_size=1M read_rnd_buffer_size=256K sort_buffer_size=2M #skip-innodb innodb_additional_mem_pool_size=6M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=3M innodb_buffer_pool_size=250M innodb_log_file_size=50M innodb_thread_concurrency=10 wait_timeout=7200 connect_timeout=10 max_allowed_packet=16M max_connect_errors=1000 bulk_insert_buffer_size=8M [mysqld_safe] open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M
