From: Philip Mak <[EMAIL PROTECTED]>

> I'm trying to delete 5 million rows...

Do you have to do this often?


> ...access to the other tables in the database are blocked...

How do you mean "blocked"? Do you mean that you're getting an error message someplace, 
or that other operations take way too long, or something else?


> Any suggestions on how I can delete those rows without causing a lot
> of downtime?

Do the big operations at a time when your site isn't busy. Like at night.



> sql (stupid filter...)

Yes, but at least they're trying.


---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/

sql



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to