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
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
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