What the @#$@@ is going on with NSBB?!?!

[Tim]

Sorry about the downtime lately and the rough edges today as things were getting patched. At least I have found the penultimate problem and have a patch solution in place.

 

NSBB has grown to the point where there are close to 800,000 posts, 480,000 words used and 54,000,000 combinations of words and posts stored in the database. As new posts were added or as people were doing searches, it was completely hosing up the system. Basically, I found the limits of mysql as it is installed on my server. I have temporarily disabled the search function and edited out the portions of code that search the wordlist and matchlist when posts are entered. That should take care of the short term problem, but not the longer term issue as we can't live without a search function forever.

 

I'm working on alternatives and hope to implement something this weekend.

 

Once again, sorry about the inconveniences lately and thanks for your patience.

[Andy]

Great work Tim. For the moment at least, NSBB is perfectly functional and it's thanks to your efforts. :)

[UMFan83]

So it doesnt have anything to do with large pictures in people's signatures like we were speculating on the emergency nsbb board?

[burnt out cubbie fan]

Tisk tisk tisk Tim. No fake swearing using symbols. :D

[SouthSideRyan]

Family Board. :)

[Tim]

So it doesnt have anything to do with large pictures in people's signatures like we were speculating on the emergency nsbb board?

Not so much.

[USSoccer]

So it doesnt have anything to do with large pictures in people's signatures like we were speculating on the emergency nsbb board?

Not so much.

 

Is it a situation where you may have to archive old posts?

[Tim]

So it doesnt have anything to do with large pictures in people's signatures like we were speculating on the emergency nsbb board?

Not so much.

 

Is it a situation where you may have to archive old posts?

Yep, that's precisely what it is coming to. I've been working with the ISP to try and tune mysql to handle the size of that one table, but it hasn't been working very well. Obviously.

 

Any DBA's around?

[UBlink]

So it doesnt have anything to do with large pictures in people's signatures like we were speculating on the emergency nsbb board?

Not so much.

 

Is it a situation where you may have to archive old posts?

Yep, that's precisely what it is coming to. I've been working with the ISP to try and tune mysql to handle the size of that one table, but it hasn't been working very well. Obviously.

 

Any DBA's around?

 

Yeah, but they're holding out for a 5 year / $50 million guaranteed contract.

[Tim]

Hmmm....

 

Instead of archiving old posts, I wonder if I could use google to fully index my site and then use that as a search engine for posts with a "search this site" option.... :-k

 

Just thinking out loud here.

[wvcbxl]

... 480,000 words used and 54,000,000 combinations of words ...

 

My offer to start posting in Dutch and French is still valid if you want to boost those numbers, Tim. :jocolor:

[Tim]

Based on the board performance today after the latest fix, I'm confident enough that I'm doubling the # of allowable sessions per user to eliminate one problem that people have been having lately.

[OnTheBeach]

Hmmm....

 

Instead of archiving old posts, I wonder if I could use google to fully index my site and then use that as a search engine for posts with a "search this site" option.... :-k

 

Just thinking out loud here.

 

Although they use IPB, redsoxnation.net uses the Google search tool now to search the site and it works very well.

[Careless]

... 480,000 words used and 54,000,000 combinations of words ...

 

My offer to start posting in Dutch and French is still valid if you want to boost those numbers, Tim. :jocolor:

we coudl just typo more. (see, it's easy!)

[NCCubFan]

we coudl just typo more. (see, it's easy!)

Mor typoes wuld add mor werds tu thu leest. :D

[wvcbxl]

we coudl just typo more. (see, it's easy!)

Mor typoes wuld add mor werds tu thu leest. :D

 

:lol: :lol: :lol:

 

La plus perdue de toutes les journées est celle où l'on n'a pas ri. (Nicolas de Chamfort) - (a day without laughter is a lost day)

[Banedon]

we coudl just typo more. (see, it's easy!)

Mor typoes wuld add mor werds tu thu leest. :D

 

:lol: :lol: :lol:

 

La plus perdue de toutes les journées est celle où l'on n'a pas ri. (Nicolas de Chamfort) - (a day without laughter is a lost day)

 

"What is that you are saying?" - Steve Martin

[brinoch]

Sweet! Let's add foreign words to this, as well. Make Tim's life even *more* hellish!

[Gracies Girl]

New rule: You have to be a Premium member to post or read posts written in foreign languages. :)

[Careless]

I'd just support a ban on the french language.

[vance_the_cubs_fan]

Rubby Perez Imed me and said he is not in favor of a foreign language ban.

[erik316wttn]

Sorry about the downtime lately and the rough edges today as things were getting patched. At least I have found the penultimate problem and have a patch solution in place.

 

NSBB has grown to the point where there are close to 800,000 posts, 480,000 words used and 54,000,000 combinations of words and posts stored in the database. As new posts were added or as people were doing searches, it was completely hosing up the system. Basically, I found the limits of mysql as it is installed on my server. I have temporarily disabled the search function and edited out the portions of code that search the wordlist and matchlist when posts are entered. That should take care of the short term problem, but not the longer term issue as we can't live without a search function forever.

 

I'm working on alternatives and hope to implement something this weekend.

 

Once again, sorry about the inconveniences lately and thanks for your patience.

 

Would deleting old threads that haven't been active since before Opening Day 2004 be effective? I very much doubt people are going to miss those much.

 

Maybe putting in an "auto delete" feature in threads that have been inactive for, say, 18 months? I'm sure it would give you enough room, at least for now.

 

You could have an archive for the more popular or funny threads, like the famous Nomar thread.

 

Also just thinking out loud.

[adamb0719]

Sorry about the downtime lately and the rough edges today as things were getting patched. At least I have found the penultimate problem and have a patch solution in place.

 

NSBB has grown to the point where there are close to 800,000 posts, 480,000 words used and 54,000,000 combinations of words and posts stored in the database. As new posts were added or as people were doing searches, it was completely hosing up the system. Basically, I found the limits of mysql as it is installed on my server. I have temporarily disabled the search function and edited out the portions of code that search the wordlist and matchlist when posts are entered. That should take care of the short term problem, but not the longer term issue as we can't live without a search function forever.

 

I'm working on alternatives and hope to implement something this weekend.

 

Once again, sorry about the inconveniences lately and thanks for your patience.

 

Would deleting old threads that haven't been active since before Opening Day 2004 be effective? I very much doubt people are going to miss those much.

 

Maybe putting in an "auto delete" feature in threads that have been inactive for, say, 18 months? I'm sure it would give you enough room, at least for now.

 

You could have an archive for the more popular or funny threads, like the famous Nomar thread.

 

Also just thinking out loud.

 

Wasn't around then. Could you let me know what thread that is?

[erik316wttn]

Sorry about the downtime lately and the rough edges today as things were getting patched. At least I have found the penultimate problem and have a patch solution in place.

 

NSBB has grown to the point where there are close to 800,000 posts, 480,000 words used and 54,000,000 combinations of words and posts stored in the database. As new posts were added or as people were doing searches, it was completely hosing up the system. Basically, I found the limits of mysql as it is installed on my server. I have temporarily disabled the search function and edited out the portions of code that search the wordlist and matchlist when posts are entered. That should take care of the short term problem, but not the longer term issue as we can't live without a search function forever.

 

I'm working on alternatives and hope to implement something this weekend.

 

Once again, sorry about the inconveniences lately and thanks for your patience.

 

Would deleting old threads that haven't been active since before Opening Day 2004 be effective? I very much doubt people are going to miss those much.

 

Maybe putting in an "auto delete" feature in threads that have been inactive for, say, 18 months? I'm sure it would give you enough room, at least for now.

 

You could have an archive for the more popular or funny threads, like the famous Nomar thread.

 

Also just thinking out loud.

 

Wasn't around then. Could you let me know what thread that is?

 

It was even about a month before I joined. It started the day we traded for Nomar. Treebeard and such posted a bunch of MSN paint pictures and stuff, kind of providing illustration for the story and how he reacted when we got Nomar.

 

Once the search features get back up I'm sure someone will link to it.

[adamb0719]

Sorry about the downtime lately and the rough edges today as things were getting patched. At least I have found the penultimate problem and have a patch solution in place.

 

NSBB has grown to the point where there are close to 800,000 posts, 480,000 words used and 54,000,000 combinations of words and posts stored in the database. As new posts were added or as people were doing searches, it was completely hosing up the system. Basically, I found the limits of mysql as it is installed on my server. I have temporarily disabled the search function and edited out the portions of code that search the wordlist and matchlist when posts are entered. That should take care of the short term problem, but not the longer term issue as we can't live without a search function forever.

 

I'm working on alternatives and hope to implement something this weekend.

 

Once again, sorry about the inconveniences lately and thanks for your patience.

 

Would deleting old threads that haven't been active since before Opening Day 2004 be effective? I very much doubt people are going to miss those much.

 

Maybe putting in an "auto delete" feature in threads that have been inactive for, say, 18 months? I'm sure it would give you enough room, at least for now.

 

You could have an archive for the more popular or funny threads, like the famous Nomar thread.

 

Also just thinking out loud.

 

Wasn't around then. Could you let me know what thread that is?

 

It was even about a month before I joined. It started the day we traded for Nomar. Treebeard and such posted a bunch of MSN paint pictures and stuff, kind of providing illustration for the story and how he reacted when we got Nomar.

 

Once the search features get back up I'm sure someone will link to it.

 

I think I may have seen it before. I forgot the search was down. I will try to find it once it is up though, thanks.