Pre-Parse Post/Signatures & Sphinx Search plugins
#51
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..
Hello, Welcome to MyBB Indonesia to get local support
My 'Simple' Unique Plugin here Smile
Reply
#52
Nevermind, fixed. Smile
Reply
#53
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...


Attached Files
.zip   preparsepost.zip (Size: 3.3 KB / Downloads: 94)
Reply
#54
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.
Reply
#55
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
Hello, Welcome to MyBB Indonesia to get local support
My 'Simple' Unique Plugin here Smile
Reply
#56
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);
Reply
#57
nice labrocca, this thread useful in the next few year. For other member Smile
Hello, Welcome to MyBB Indonesia to get local support
My 'Simple' Unique Plugin here Smile
Reply
#58
Am I the only one with twice showing attachments when using the Pre-Parse Post plugin?
Reply
#59
(03-23-2010, 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
Hello, Welcome to MyBB Indonesia to get local support
My 'Simple' Unique Plugin here Smile
Reply
#60
I've updated the Sphinx plugin with 2 minor bug fixes. Thanks to labrocca for finding and reporting them.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)