Help with MySQL configuration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

 

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux