Repair / Optimize tables: WSN Support

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

Version: 3.20

Repair / Optimize tables

david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 88
Total Posts: 304

Posted 08/08/05 - 07:55 PM:	#1
Hey Paul, How long do these functions run? David

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 08/09/05 - 10:10 AM:	#2
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.)
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.