MySQL Forums
Forum List  »  InnoDB

Re: Delete Query Taking Too Much Resources
Posted by: Rick James
Date: September 24, 2012 12:31AM

I'm confused...
> 1) IN the table there always more then 3m of record
> 2) Delete query delete 25000 rows at a time.
Those contradict these:
> AUTO_INCREMENT=1389
The STATUS says there are only about 555 rows.
Please explain.

> 2) Delete query delete 25000 rows at a time.
Don't delete so many at once. See
http://mysql.rjweb.org/doc.php/deletebig

What is the value of innodb_buffer_pool_size?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Delete Query Taking Too Much Resources
996
September 24, 2012 12:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.