hi,
i installed a phptracker with a mysql database behind it... everything works pretty fine except after a few hours my database begins giving white screen witht he 10048 or 10061 errors...
i know that it are not the processors (using a dual processor server) because they never peak... they always stay around 50%cpu time...
the bttracker is working with maximum 1600 peers for the moment... so this can not give that much traffic...
the strange thing is that it seems too happen every time when my virusscanner is finished... virusscanner is a norton corporate 8...
this is my "my.ini " file from the mysql database
This File was made using the WinMySQLAdmin 1.4 Tool
#11-Dec-03 08:40:56
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
#The size of the buffer used for index blocks. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford; 64M on a 256M machine that mainly runs MySQL is quite common.
key_buffer_size=64M
#The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.
myisam_sort_buffer_size=64
M
#Enter a name for the binary log. Otherwise a default name will be used.
log-bin
# Uniquely identifies the server instance in the community of replication partners.
server-id=1
#Permits the application to give the threads system a hint for the desired number of threads that should be run at the same time
thread_concurrency=8
#The number of open tables for all threads.
table_cache=256
#The number of simultaneous clients allowed.
max_connections=5000
#Max packetlength to send/receive from to server.
max_allowed_packet=8M
#The number of seconds the mysqld server is waiting for a connect packet before responding with 'Bad handshake'
connect-timeout=5
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld
-max-nt.ex
e
user=****
password=******
QueryInterval=10
# The MySQL server
[mysqld]
basedir=C:/mysql
#bind-address=192.168.1.3
datadir=C:/mysql/data
#language=C:/mysql/share/y
our language directory
#slow query log#=
#tmpdir#=
#set-variable=key_buffer=1
6Mport=330
6
#socket=MySQL
port=3306
#socket=MySQL
#(Unknown option:)skip-locking
#(Unknown option:)set-variable = key_buffer=256M
max_allowed_packet=8M
set-variable = table_cache=256
#(Unknown option:)set-variable = sort_buffer=1M
#(Unknown option:)set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64
M
#(Unknown option:)set-variable = thread_cache=8
#(Unknown option:)Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
log-bin
server-id = 1
#The size of the buffer used for index blocks. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford; 64M on a 256M machine that mainly runs MySQL is quite common.
key_buffer_size=64M
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
[mysqldump]
quick
set-variable = max_allowed_packet=16M
i know he is a bit big but i took the "hughe" setting from the mysql source and adjusted it a bit ... maybe there are mistakes there??
can my slow internet connection be a problem?? serving this on a ISDN alike line (115.5 Kbits/sec)...
thanks for any advice to this mysql newbie
TAz