List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:March 23 2005 5:45pm
Subject:RE: MySQL server disconnects when executing simple Select stateme
nts++
View as plain text  
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
Thread
MySQL server disconnects when executing simple Selectstatements++mos23 Mar
  • Re: MySQL server disconnects when executing simple Select statements++V. M. Brasseur23 Mar
    • Re: MySQL server disconnects when executing simple Select statements++mos24 Mar
  • Re: MySQL server disconnects when executing simple Select statements++SGreen23 Mar
  • Re: MySQL server disconnects when executing simple Select statements++James Nobis23 Mar
RE: MySQL server disconnects when executing simple Select statements++Victor Pendleton23 Mar