Webmastersite.net
Register Log In

Repair / Optimize tables
When do we know if they are done?

Comments on Repair / Optimize tables

david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Aug 08, 2005 - 10:55 PM:

Hey Paul,

How long do these functions run?

David
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 09, 2005 - 1:10 PM:

That's entirely dependent on the size of your database. It takes a millisecond on a small database and many hours on a large database, and something in between on midrange sizes. With my largest database I prefer to run the commands directly from SSH so that I can see when it's done. (Which is not to say I run them often, probably haven't in the last 6 months at least, as on said large database is brings down the site for an annoyingly long time and I've never really been able to measure the benefits.)
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.