hasslecauser
Technical User
Since I upgraded from MySQL 4.0 to 4.1 on my Windows NT 4 server, I have noticed a serious slowdown in the speed of connecting to the database from the local network, though the speed of database operations is not a problem. What used to be quite fast (less than 1 sec to connect) now takes at least 4.5 secs, with no other activity on the network. When I upgraded, I also increased the machine's memory from 128MB to 512MB, and increased caching to take advantage of that. Here's my my.cnf:
[mysqld]
basedir=c:/mysql/
datadir=d:/mysql-data/
skip-bdb
skip-innodb
key_buffer_size=25M
query_cache_size=20M
query_cache_type=1
read_buffer_size=1M
read_rnd_buffer_size=4M
sort_buffer_size=1M
table_cache=20
thread_cache=8
tmpdir=d:/temp/
I have played around with these options, including using the defaults, but haven't managed to improve connection speed at all.
Can anybody see any improvements I can make?
Any clues would be much appreciated. Thanks.
[mysqld]
basedir=c:/mysql/
datadir=d:/mysql-data/
skip-bdb
skip-innodb
key_buffer_size=25M
query_cache_size=20M
query_cache_type=1
read_buffer_size=1M
read_rnd_buffer_size=4M
sort_buffer_size=1M
table_cache=20
thread_cache=8
tmpdir=d:/temp/
I have played around with these options, including using the defaults, but haven't managed to improve connection speed at all.
Can anybody see any improvements I can make?
Any clues would be much appreciated. Thanks.
