On Sun, Jan 12, 2003 at 08:12:35PM -0700, Rodney Broom wrote: > > I'm trying to delete 5 million rows... > > Do you have to do this often?
Sort of. I have a process that logs to MySQL, and I want to delete old log entries. I haven't been deleting old entries at all recently because it will freeze up everything, though. If I was deleting things regularly, I'd have to delete maybe a couple hundred thousand rows every day. > > ...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? When I say "blocked", I mean e.g. another process tries to SELECT from another table in the database, but it takes way too long. > > 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. My site is always busy. People don't use it as much at night, but there's still many people using it. 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
