From: adburne (adburneasocmedrosario.com.ar)
Date: Fri Feb 06 2004 - 07:04:38 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Vinay, u can create a temporary table

CREATE TEMPORARY TABLE TMP
Select * from ORIGINAL WHERE 'records to preserve';

TRUNCATE TABLE ORIGINAL;

INSERT INTO ORIGINAL SELECT * FROM TMP;

DROP TABLE TMP;

Alejandro.



 
-------Mensaje original-------
 
De: Vinay
Fecha: 06/02/04 08:32:04
Para: mysqllists.mysql.com
Asunto: Problem deleteing records
 
I have a problem with a table that is too big it contains around
35,000,000 lines and each end of month i have to take out about
20,000,000 lines from it
 
so my delete command is :
 
delete from table where column_value<******
on a column that is indexed.
 
But each time i do that i have mysql that have "too many connection
problem" and i have to kill and restart mysql in the middle of the
process.
 
I finish up with a huge table that i must repaire and that takes time
and sometime it does not even work.
 
i have " max connections=1000 " and even this does not seem to be
enough.
 
Does anyone has a better way so that i can delete my records without
damaging my table and having to restart mysql..
 
V!nay
 
 
 
 
 
 
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=adburneasocmedrosario.com.ar

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]