"Lost connection to MySQL server during query" The last time I saw this mysqld was segfaulting on a specific query. The solution was to run an extended repair on the tables in question. http://dev.mysql.com/doc/mysql/en/repair-table.html
I would reccommend against doing this until after hours as this will lock your MyISAM tables. Quoting mos <[EMAIL PROTECTED]>: > 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] > James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450-0263 http://www.academicsuperstore.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
