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]