DONE System may be slow,table optimization in the background

Discuss site matters here

Moderators: FishPants, ooRip

Post Reply
User avatar
FishPants
Server WhOOre
Posts: 4661
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

DONE System may be slow,table optimization in the background

Post by FishPants »

FYI queries to the posts table may be slow, or may time out. Now that I've reloaded the posts table, it needs optimization to defrag the indexes.
No.
Top
User avatar
Pyperkub
Posts: 23658
Joined: Mon Dec 13, 2004 5:07 pm
Location: NC- that's Northern California

Re: DONE System may be slow,table optimization in the backgr

Post by Pyperkub »

Submitting posts (for me on black pearl) hangs (though the post is posted). I have better results going to view new posts again.

FWIW.

PS thanks for getting us up again. :wub:
Black Lives definitely Matter Lorini!

Also: There are three ways to not tell the truth: lies, damned lies, and statistics.
Top
User avatar
FishPants
Server WhOOre
Posts: 4661
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: DONE System may be slow,table optimization in the backgr

Post by FishPants »

Pyperkub wrote:Submitting posts (for me on black pearl) hangs (though the post is posted). I have better results going to view new posts again.

FWIW.

PS thanks for getting us up again. :wub:
Yep I ran an optimize on all tables (Not posts, which is the massive table that I notified on before). Taking longer than anticipated, and while it's on tables like topics etc it may slow things down here and there. I'd expect it to be done soon though, a lot of the tables it's optimizing are small (with the exception of the search index and the topics table).
No.
Top
Post Reply

Return to “The Overlords Meta Forum”