Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 27.2Mb
PDF (A4) - 27.2Mb
PDF (RPM) - 26.0Mb
HTML Download (TGZ) - 6.5Mb
HTML Download (Zip) - 6.5Mb
HTML Download (RPM) - 5.6Mb
Man Pages (TGZ) - 152.9Kb
Man Pages (Zip) - 255.1Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
Excerpts from this Manual

B.5.4.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.

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.