What device driver are you using to access the database? Can you run a sql trace or maybe turn on the logging on the server side?
-----Original Message----- From: mos [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 11:05 AM To: MySQL list Subject: MySQL server disconnects when executing simple Select statements++ I have a compiled application that accesses a dedicated MySQL 4.1.1 server with MyISAM tables on Win XP. For some reason when the application is in a loop doing simple single table Select statements, the MySQL server after 48 seconds of processing will upchuck with the error "Can't connect to MySQL server on 'localhost' (10048)". This machine has the server and application on it and no one else is using it. MaxUsedConnections=3 and connections=3974 after it crashes. It is doing about 20 queries per second before it crashes. It usually crashes near the same record. Seconds after the crash if I have another application do a "Show status" I get an error "Lost connection to MySQL server during query". If I wait a few seconds and re-run it, I get the status results. It is running on Win XP AMD 3500+ with 1g ram. There is plenty of memory because the queries are returning only a dozen rows, maybe less. Any idea how I can eliminate the crashing? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
