RE: Very slow delete for Master / Child tables with millions of rows

2010-03-11 Thread Daevid Vincent
TABLE to reclaim unused space and reduce file sizes when done too. > -Original Message- > From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On > Behalf Of Johan De Meersman > Sent: Thursday, March 11, 2010 7:43 AM > To: Price, Randall > Cc: mysql@lists.mysql.com > Subject: Re: Very

Re: Very slow delete for Master / Child tables with millions of rows

2010-03-11 Thread Krishna Chandra Prajapati
Hi Randall, How much memory is allocated to innodb_buffer_pool_size. Please send your mysql configuration file (my.cnf) Thanks, Krishna On Thu, Mar 11, 2010 at 8:57 PM, Price, Randall wrote: > I am experiencing very slow deletes when I delete a record from a master > table and have cascading d

Re: Very slow delete for Master / Child tables with millions of rows

2010-03-11 Thread Johan De Meersman
If you really have to loop through the entire set deleting record by record, I'm not surprised it's slow. Could you change your application to loop through the records doing "stuff" without deleting (maybe even "do stuff" en masse), and afterwards do a mass delete ? I also have a nagging suspicion