SEO

#1 (**permalink**) 02-28-2008, 07:35 AM

RHEL3 (up2date) mysql 4.0

DELETE FROM database.tablename;

This runs for about 30 minutes(expected), and then results with "Lost connection to MySQL server during query".
This has been working for a long time now until today. The only difference is that it it has a LOT more records to delete.

the error log shows:
060410 7:20:59 Aborted connection 285910 to db: 'database' user: 'import' host: `rhost' (Got timeout reading communication packets)
(Actually all of our servers are causing this error to appear.

anybody know what to change.

#2 (**permalink**) 02-28-2008, 07:35 AM

On Mon, 10 Apr 2006 14:04:11 -0400, Troubled User wrote:
>
>
> RHEL3 (up2date) mysql 4.0
>
>
> DELETE FROM database.tablename;
>
> This runs for about 30 minutes(expected), and then results with "Lost
> connection to MySQL server during query". This has been working for
> a long time now until today. The only difference is that it it has a
> LOT more records to delete.
>
> the error log shows: 060410 7:20:59 Aborted connection 285910 to
> db: 'database' user: 'import' host: `rhost' (Got timeout reading
> communication packets) (Actually all of our servers are causing this
> error to appear.
>
> anybody know what to change.

Figure out what's killing your connection and turn it off?

Or just purge a reasonable number of records at at time, that doesn't
outlive whatever the connection limit seems to be:

DELETE FROM tbl WHERE condition LIMIT nnnnn;

where nnnnn is some number of rows that makes you happy.

--
"If Ace [Double] Books ever came out with an edition of The Bible, both
books would be edited down to 40,000 words, and they'd be renamed "Master
of Chaos" and "The Thing With Three Souls."
-- Terry Carr

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode