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:mos99@stripped]
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/mysql?unsub=1
