+- Hack Forums (https://hackforums.net)
+-- Forum: Hack Forums Official Information (https://hackforums.net/forumdisplay.php?fid=1)
+--- Forum: Site News (https://hackforums.net/forumdisplay.php?fid=2)
+--- Thread: Site Maintenance (2 Hour Downtime) (/showthread.php?tid=5044981)
Site Maintenance (2 Hour Downtime) - Omniscient - Nov 3, 2015
I'm going to need to run a nearly two hour query to optimize our database search function. I prefer to get it done right now because I'm not going to stay up till 3am doing it in the middle of the night.
I keep making adjustments and optimizations to our database and likely this is one of the final actions I'll need to take that will create this much downtime.
Basically the InnoDB default search stopwords is total crap. It's very minimal and for a forum our size it needs to be a lot more robust. The stopwords are words that the index ignores. Words like "hello" or "the" which not only are pointless to search but pointless to index. The index takes a LOT of resources in both CPU and RAM. So making sure it's optimal is very important. Default max word is also 84 characters which is very long. I'm lowering it to 64 which is still very long but should suit our needs. Long enough to also index crypto txn's too.
I want to get this done before we move to MyBB 1.8x. The more I can optimize the database the better the upgrade should go.
So expect a Site Closed message within the next 30 minutes and sorry for more downtime but this is just part of such a large structural change to the site.
Thanks.
* - Davy - Nov 3, 2015
What needs to be done needs to be done I guess!
Guess I have a life for the next 2 hours kappa
* - prada ⠀ - Nov 3, 2015
you have my permission to do it
* - SavageAF - Nov 3, 2015
Well it's nice that you're going to tell everyone, and we understand that some things have to be done for a better future, so yea, idk what we supposed to say other than that
* - TNF. - Nov 3, 2015
What a timing. I was about to sleep.
* - Optimized - Nov 3, 2015
Ok Omni sounds good
you used the word optimize a lot
Thanks for the shoutout.
Good luck hope it all goes well
* - Maximum - Nov 3, 2015
Perfect time to go outside and do shit, thanks.
* - Who Soup - Nov 3, 2015
(Nov 3, 2015 02:11 PM)Prada Wrote: you have my permission to do it
^Lmao
Sounds like you know what your doing though omni, looking forward to this update
* - DOSH - Nov 3, 2015
Alright then, I guess I'll have to do something else.
* - Fʀᴀɴᴋɪᴇ - Nov 3, 2015
Hey I just wanted to point out that when you search the words "secure skype", only like two pages of results show up and I don't know if that is just supposed to happen but it kind of threw me off a bit because I know there are way more threads about Skype then two pages worth
* - Krew - Nov 3, 2015
Perfect time to play some Hotline Miami 2 then!
* - funtela - Nov 3, 2015
Thanks again for keeping this site updated Omni!
* - Seifer - Nov 3, 2015
Kinda glad, needed to get some work done anyways x-x
* - hаckеr - Nov 3, 2015
Good to know. Thanks for the notice.
* - Cammy - Nov 3, 2015
This will give me the opportunity to watch some more The Office