Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual

B.5.5.6 Deleting Rows from Related Tables

If the total length of the DELETE statement for related_table is more than 1MB (the default value of the max_allowed_packet system variable), you should split it into smaller parts and execute multiple DELETE statements. You probably get the fastest DELETE by specifying only 100 to 1,000 related_column values per statement if the related_column is indexed. If the related_column isn't indexed, the speed is independent of the number of arguments in the IN clause.

Download this Manual
User Comments
  Posted by José Manuel on February 3, 2004
Oh lord please, "deletando", "gerenciador", and some more 20 words i saw before throwing up are a complete insult to the portuguese grammar.

This isn't portuguese, this is plain, non-portuguese, out-of-the-ghetto brasilian!!!!!!

There was once a time where what they spoke in Brazil was Portuguese. Not anymore. Change the link of this doc. section to some (any) other thing please.
Sign Up Login You must be logged in to post a comment.