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.
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.
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
sakm wrote: ↑Sat Jun 24, 2017 5:19 pmWhen 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.
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 wrote: ↑Sat Jun 24, 2017 5:19 pmWhen 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
"The good news is hell is just the product of a morbid human imagination.
The bad news is, whatever humans can imagine, they can usually create." - Harmony Cobel
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.
"The good news is hell is just the product of a morbid human imagination.
The bad news is, whatever humans can imagine, they can usually create." - Harmony Cobel