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.
Pre-Parse + XCache..
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...
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.
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
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);
nice labrocca, this thread useful in the next few year. For other member
Am I the only one with twice showing attachments when using the Pre-Parse Post plugin?
I've updated the Sphinx plugin with 2 minor bug fixes. Thanks to labrocca for finding and reporting them.