On Fri, Feb 06, 2004 at 02:58:50PM +0400, Vinay wrote: > 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. >
The DELETE probably takes a very long time. In the mean time, clients that use the table, will block until the DELETE is finished. If enough clients keep connecting, you'll run into the connection limit sometime. Do the DELETE in small chunks, so it will block your other clients for only a short time. Pause a little in between each chunk, to allow other clients to do some work. In an interactive application, your users will love you for this :) Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
