Slow searches on new Linode machine

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Albert Wiersch
Registered User
Posts: 145
Joined: Sat Dec 11, 2004 6:00 pm
Location: Dallas, TX
Name: Albert Wiersch
Contact:

Slow searches on new Linode machine

Post by Albert Wiersch » Fri Jun 23, 2017 10:21 pm

I'm running 3.2.0.

I recently moved to a Linode server at at $20/month level which gives me 2 CPUs and 4GB of RAM. My previous server was more powerful and I don't recall there ever being a problem with search speed.

However, on the new Linode server, searching for something like "apple" can take around 25 seconds which seems rather ridiculous. Shouldn't a 2 CPU system with 4 GB of RAM be able to perform searches much faster? I don't seem to have performance issues with anything else on the server and other forum performance (besides the slow searches) seems perfectly fine. Other searches are rather quick, like a search for "watermelon", although there were 0 matches on that one.

I've already disabled search for guest accounts to reduce the server load. I'm using "phpBB Native Fulltext" for the "Search backend".

How can I improve the search speed? What should I check? Is there a page with tips on optimizing phpBB searches?

Thanks!
Last edited by JimA on Sun Jun 25, 2017 10:42 am, edited 1 time in total.

User avatar
janus_zonstraal
Registered User
Posts: 3743
Joined: Sat Aug 30, 2014 1:30 pm

Re: Slow searches on new Linode machine

Post by janus_zonstraal » Sat Jun 24, 2017 6:50 am

Try mySQL Fulltext and php7
Sorry! My English is bat ;) !!!

sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: Slow searches on new Linode machine

Post by sakm » Sat Jun 24, 2017 12:35 pm

Specs mean nothing!

You need to get the right setup ;)

User avatar
david63
Registered User
Posts: 16710
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Slow searches on new Linode machine

Post by david63 » Sat Jun 24, 2017 12:50 pm

How big is your board?

Have you tried re-building your search index?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

Albert Wiersch
Registered User
Posts: 145
Joined: Sat Dec 11, 2004 6:00 pm
Location: Dallas, TX
Name: Albert Wiersch
Contact:

Re: Slow searches on new Linode machine

Post by Albert Wiersch » Sat Jun 24, 2017 3:19 pm

janus_zonstraal wrote:
Sat Jun 24, 2017 6:50 am
Try mySQL Fulltext and php7
I use PHP 7.1.6.

Is "MySQL Fulltext" known to be better than "phpBB Native Fulltext"?

Albert Wiersch
Registered User
Posts: 145
Joined: Sat Dec 11, 2004 6:00 pm
Location: Dallas, TX
Name: Albert Wiersch
Contact:

Re: Slow searches on new Linode machine

Post by Albert Wiersch » Sat Jun 24, 2017 3:21 pm

sakm wrote:
Sat Jun 24, 2017 12:35 pm
You need to get the right setup ;)
I would think my setup should be good... it seems to work well for everything else. What do you think might be wrong with it? I could always pay more per month to Linode to get more RAM and processors but I think it should be fast enough with what I have now, which it is, except for searches. Note that not all searches are so slow... it can vary a lot depending on the search terms and number of matches.
Last edited by Albert Wiersch on Sat Jun 24, 2017 5:09 pm, edited 1 time in total.

Albert Wiersch
Registered User
Posts: 145
Joined: Sat Dec 11, 2004 6:00 pm
Location: Dallas, TX
Name: Albert Wiersch
Contact:

Re: Slow searches on new Linode machine

Post by Albert Wiersch » Sat Jun 24, 2017 3:24 pm

david63 wrote:
Sat Jun 24, 2017 12:50 pm
How big is your board?

Have you tried re-building your search index?
It's showing 9091 posts with 1987 topics. Database size is 45.25 MiB. That's not that big, is it?

Yes, I have re-built the search index.

User avatar
janus_zonstraal
Registered User
Posts: 3743
Joined: Sat Aug 30, 2014 1:30 pm

Re: Slow searches on new Linode machine

Post by janus_zonstraal » Sat Jun 24, 2017 3:48 pm

Sorry! My English is bat ;) !!!

sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: Slow searches on new Linode machine

Post by sakm » Sat Jun 24, 2017 5:19 pm

Albert Wiersch wrote:
Sat Jun 24, 2017 3:21 pm
sakm wrote:
Sat Jun 24, 2017 12:35 pm
You need to get the right setup ;)
I would think my setup should be good... it seems to work well for everything else. What do you think might be wrong with it? I could always pay more per month to Linode to get more RAM and processors but I think it should be fast enough with what I have now, which it is, except for searches. Note that not all searches are so slow... it can vary a lot depending on the search terms and number of matches.
When I say setup I'm talking how the server is setup if it's not optimised then it can be slow

Albert Wiersch
Registered User
Posts: 145
Joined: Sat Dec 11, 2004 6:00 pm
Location: Dallas, TX
Name: Albert Wiersch
Contact:

Re: Slow searches on new Linode machine

Post by Albert Wiersch » Sat Jun 24, 2017 5:31 pm

sakm wrote:
Sat Jun 24, 2017 5:19 pm
When I say setup I'm talking how the server is setup if it's not optimised then it can be slow
Can you be more specific about these "optimizations"? Or point me to a good link about them?

As far as I know it's already "optimized" enough (as in there is nothing I could do that I know of that would significantly improve performance). Although I could potentially move the databases into RAM though.... but that has drawbacks.

Albert Wiersch
Registered User
Posts: 145
Joined: Sat Dec 11, 2004 6:00 pm
Location: Dallas, TX
Name: Albert Wiersch
Contact:

Re: Slow searches on new Linode machine

Post by Albert Wiersch » Sat Jun 24, 2017 5:34 pm

janus_zonstraal wrote:
Sat Jun 24, 2017 3:48 pm
In 2010 is was ;)
viewtopic.php?f=46&t=2004075
Interesting.... but I wonder if that is still the case? I'm sure a lot has changed in 7 years. Does anyone know what the "official" best "Search backend" is for phpBB 3.2.0 and PHP7?

sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: Slow searches on new Linode machine

Post by sakm » Sat Jun 24, 2017 6:00 pm

Albert Wiersch wrote:
Sat Jun 24, 2017 5:31 pm
sakm wrote:
Sat Jun 24, 2017 5:19 pm
When I say setup I'm talking how the server is setup if it's not optimised then it can be slow
Can you be more specific about these "optimizations"? Or point me to a good link about them?

As far as I know it's already "optimized" enough (as in there is nothing I could do that I know of that would significantly improve performance). Although I could potentially move the databases into RAM though.... but that has drawbacks.
Tweak apache and mysql etc but if you have already done that and performance is good the change the search database and see if that helps

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21680
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Slow searches on new Linode machine

Post by Mick » Sat Jun 24, 2017 7:10 pm

Blimey, for $20/month I would expect my host to be on the ball.
"The more connected we get the more alone we become" - Kyle Broflovski

daviceroy
Registered User
Posts: 14
Joined: Fri Jan 29, 2010 3:48 am

Re: Slow searches on new Linode machine

Post by daviceroy » Sat Jun 24, 2017 7:57 pm

Under the Resources Tab on Linode, there is a Documentation area. Make sure you've optimized MySQL. I believe there is a doc on there for that. Probably will need to tweak some config files to make it run the way you want.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21680
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Slow searches on new Linode machine

Post by Mick » Sat Jun 24, 2017 8:03 pm

May I remind you that server setup is beyond the scope of these forums.
"The more connected we get the more alone we become" - Kyle Broflovski

Post Reply

Return to “[3.2.x] Support Forum”