Hi,

I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is working fine, except some problems.
Sometimes when I try to use access web pages through php pages, mysql says "Connection to server lost" or
"Can't connect to mysql server" or sometimes query error. Query is tested and works fine most of the time.
And when I refresh web page again everything works fine.
Mysql log says nothing.


Is it problem related to mysql in Windows? Also I tested small C program to query mysql tables and it sometimes
hangs. Is there any solution for this kind of problem?



The following is the my.ini file: ------------------------------------------------------------------------------------------------------------- [mysqld] skip-locking

set-variable                   = connect_timeout=30
set-variable                   = net_retry_count=1000000
set-variable    = key_buffer=384M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=3M
set-variable    = sort_buffer=2M
set-variable    = record_buffer=2M
set-variable    = thread_cache=8
set-variable    = thread_concurrency=8
set-variable    = myisam_sort_buffer_size=64M
server-id       = 1

set-variable    = max_connections=5000
set-variable    = query_cache_size=8M
set-variable    = query_cache_limit=8M
set-variable    = thread_cache_size=2M


basedir=D:/mysql datadir=D:/mysql/data log=general.log log-update=update.log myisam-recover=FORCE

[WinMySQLadmin]
Server=D:/mysql/bin/mysqld-max-nt.exe
user=root
password=xxx
-------------------------------------------------------------------------------------------------------------


thanks in advance,


Ganbold


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to