From: Ananda Kumar Date: November 4 2011 7:42am Subject: Re: Deleting Records in Big tables List-Archive: http://lists.mysql.com/mysql/226234 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf305639ab607aa304b0e3d963 --20cf305639ab607aa304b0e3d963 Content-Type: text/plain; charset=ISO-8859-1 Why dont you create a new table where id < 2474, rename the original table to "_old" and the new table to actual table name. or You need to write a stored proc to loop through rows and delete, which will be faster. Doing just a simple "delete" statement, for deleting huge data will take ages. regards anandkl On Fri, Nov 4, 2011 at 12:52 PM, Adarsh Sharma wrote: > > Dear all, > > Today I need to delete some records in > 70 GB tables. > I have 4 tables in mysql database. > > my delete command is :- > > delete from metadata where id>2474; > > but it takes hours to complete. > > One of my table structure is as :- > > CREATE TABLE `metadata` ( > `meta_id` bigint(20) NOT NULL AUTO_INCREMENT, > `id` bigint(20) DEFAULT NULL, > `url` varchar(800) DEFAULT NULL, > `meta_field` varchar(200) DEFAULT NULL, > `meta_value` varchar(2000) DEFAULT NULL, > `dt_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, > PRIMARY KEY (`meta_id`) > ) ENGINE=InnoDB AUTO_INCREMENT=388780373 ; > > > Please let me know any quickest way to do this. > I tried to create indexes in these tables on id, but this too takes time. > > > > Thanks > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?**unsub=anandkl@stripped > > --20cf305639ab607aa304b0e3d963--