Dear Sir,
For many times, I encountered the same problem as the follow. Maybe it is a
general question for you. Would you please reply me the method to correct
the program?
Because the network reason, please reply to "[EMAIL PROTECTED]".
Best Regards,
Freda
----------------------------------------------------------------------------
--
Error prompt==========after running several days,ODBC configuration Windows
appear and stay there,
application blocked.
Once start the MySql server again, it is normal.
MySQL Version=========MySql 3.23.30
MyODBC Version========ODBC 2.50.29
ODBC configuration====all tags off
Pletform OS===========Microsoft NT/2000
Pletform CPU==========PII/PIII
Pletform Memory=======256KB
Pletform HD===========30GB
Application===========multi-threads read/write database, running in the same
machine with MySql server.
Language==============VC 6.0
Users=================Max 5 users
Running period========several days
My.cnf=====
My.cnf===============================================================
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
default-character-set=latin1
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = flush_time=1800
set-variable = connect_timeout=2000
set-variable = max_connections=16384
set-variable = max_connect_errors=65536
set-variable = delayed_insert_limit=10000
set-variable = delayed_insert_timeout=6000
set-variable = long_query_time=1000
set-variable = max_delayed_threads=500
set-variable = table_cache=256
set-variable = back_log=500
set-variable = wait_timeout=2073600
#set-variable = max_user_connections=0
low-priority-updates
log-update
log
# Uncomment the following row if you move the MySQL distribution to another
# location
#basedir = d:/mysql/
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable= key=16M
[client_fltk]
help_file= c:\mysql\sql_client\MySQL.help
client_file= c:\mysql\MySQL.options
history_length=20
database = test
queries_root= c:\mysql\queries
last_database_file= c:\mysql\lastdb
===========================================================================
MySql.err====
MySql.err==================================================================
010531 16:28:50 Aborted connection 11960 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010531 16:40:09 Aborted connection 12187 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010531 16:53:16 Aborted connection 12257 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010531 16:59:19 Aborted connection 12330 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010531 17:31:16 Aborted connection 12953 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010531 17:46:35 Aborted connection 13112 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010601 17:05:32 Aborted connection 17760 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010601 18:14:35 Aborted connection 17821 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 27416 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12387 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12430 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12513 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12583 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12558 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12603 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12632 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12652 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 12855 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 13349 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 14676 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 14810 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 14835 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:14 Aborted connection 15510 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 15530 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 15558 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 17552 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 17522 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 17849 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 17860 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 17508 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 17533 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 18400 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 18472 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 20911 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 21031 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 23154 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 24334 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 25062 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 25045 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 25414 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 25438 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:38:15 Aborted connection 26269 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:42:58 Aborted connection 27413 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:45:14 Aborted connection 27580 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:46:16 Aborted connection 27747 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 16:46:32 MySql: Normal shutdown
010604 16:46:32 MySql: Shutdown Complete
MySql: ready for connections
010604 17:27:34 Aborted connection 419 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 17:27:36 Aborted connection 417 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 17:35:32 Aborted connection 618 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 17:36:37 Aborted connection 624 to db: 'ctidb' user: 'root' host:
`localhost' (Unknown error)
010604 17:37:03 MySql: Normal shutdown
010604 17:37:03 MySql: Shutdown Complete
MySql: ready for connections
============================================================================
==========
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
