DONE System may be slow,table optimization in the background
- 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
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.
- Pyperkub
- Posts: 23643
- 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
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.
FWIW.
PS thanks for getting us up again.
Black Lives definitely Matter Lorini!
Also: There are three ways to not tell the truth: lies, damned lies, and statistics.
Also: There are three ways to not tell the truth: lies, damned lies, and statistics.
- 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
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).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.
No.