MyBB Community Forums
Pre-Parse Post/Signatures & Sphinx Search plugins - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Extensions (https://community.mybb.com/forum-201.html)
+--- Forum: Plugins (https://community.mybb.com/forum-73.html)
+---- Forum: Plugin Development (https://community.mybb.com/forum-68.html)
+---- Thread: Pre-Parse Post/Signatures & Sphinx Search plugins (/thread-43165.html)

Pages: 1 2 3 4 5 6 7 8 9 10


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - FBI - 2009-12-29

Thanks Ryan, It solved.

Curiously I make a new forum and test, same problem.
And found Filezilla didn't upload file correctly.
I have to manually delete modified file on server, and upload (not replacing).
Now, run again.


Before preparsed, I have many "Locked Table Query" and made high "max. concurrent connections" MySQL. With your Pre-Parse, last time the forum running 25-50 faster and can handle high 400-700 peak users easily.

Also, without preparse. There is XCache alternative. Installing on server, will increasing 30% more speed (I think).

Damn! very fast. Big Grin
Pre-Parse + XCache..


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - androll33 - 2009-12-30

Nevermind, fixed. Smile


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - querschlaeger - 2010-02-12

Hi,
I'm impressed with the Pre-Parse Post plugin. But for me disk space isn't a critical limiting factor so I modified the plugin a little bit. My modification stores all pre parsed posts in database regardless of how many replies a thread has or how old a post is. This speeds up thread view to the maximum (but database size will grow also).

Feel free to use it.
Hm, there is a unpleasant bug with Pro-Parse Post plugin. When it's activated all attachements are shown twice...


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - labrocca - 2010-03-22

After having severe DB problems all weekend mostly related to search. I have gone ahead and installed Sphinx at HF. I'll be reporting more on this tomorrow. So far so good though and the installation wasn't terrible. Documentation could be a little better.


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - FBI - 2010-03-22

Yes, sphinx installation documentation.

aha, just move to Dedicated Server with 1.1 million posts
No problem at all, search are fully open.
MySQL running well, almost a month, with no rebooting.. and around 60 peak concurrent connection

only Pre-parsed Post installed with tons of plugins.
maybe later, when reach 2-3 millions posts. I will install sphinx


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - labrocca - 2010-03-22

Quote:MySQL running well, almost a month, with no rebooting.. and around 60 peak concurrent connection

I peak at 250 but that's my max connections right now. I'll hit 3 million posts in a few days. I was actually forced to prune about 50,000 activated 0 post members last week in an effort to alleviate some of the problems. I think Sphinx however has really done the job of lowering the MySQL process load greatly.

I was previously doing about 60-80% of CPU constantly whereas now I'm about 10%. That's significant. I think my search is used about 50,000 times per day so that's about 1 every 1.5 seconds I think. I was doing about 400 queries per second now I'm down to 250 again. Although I had a very busy traffic weekend so I'll see how this all works out next weekend. I had 41,000 visits yesterday. My guess is that's about 4 times more than NCAABBS. Also had 19,000 posts.

btw posted some info on my changes: http://www.hackforums.net/showthread.php?tid=328404

And a big thanks to Ryan for this plugin. You probably just saved me 100 hours of setting up a new server.


BUG REPORT:
			if($remaining_time == 1)
			{
				$lang->error_searchflooding = sprintf($lang->error_searchflooding_1, $mybb->settings['searchfloodtime']);
			}
			else
			{
				$lang->error_searchflooding = sprintf($lang->error_searchflooding, $mybb->settings['searchfloodtime'], $remaining_time);
			}
			error($lang->error_searchflooding);

Should be:
			if($remaining_time == 1)
			{
				$lang->error_searchflooding = $lang->sprintf($lang->error_searchflooding_1, $mybb->settings['searchfloodtime']);
			}
			else
			{
				$lang->error_searchflooding = $lang->sprintf($lang->error_searchflooding, $mybb->settings['searchfloodtime'], $remaining_time);
			}
			error($lang->error_searchflooding);



RE: Pre-Parse Post/Signatures & Sphinx Search plugins - FBI - 2010-03-23

nice labrocca, this thread useful in the next few year. For other member Smile


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - querschlaeger - 2010-03-23

Am I the only one with twice showing attachments when using the Pre-Parse Post plugin?


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - FBI - 2010-03-24

(2010-03-23, 06:53 PM)querschlaeger Wrote: Am I the only one with twice showing attachments when using the Pre-Parse Post plugin?

Yes, showing twice Smile


RE: Pre-Parse Post/Signatures & Sphinx Search plugins - Ryan Gordon - 2010-03-30

I've updated the Sphinx plugin with 2 minor bug fixes. Thanks to labrocca for finding and reporting them.