MyBB Community Forums - search is very slow on my Mybb Forum

Hello Experts,

The search function on my site is taking almost more than 7-8 seconds to load.

I have tuned mysql settings and done optimization at web server but still the search is slow.

I observed that the search mysql query is taking longer time.

Is there any way to tune the search speed on my site from backend or through mysql?.

The slow query is doing some select and join operation.

Thanks in Advance...

I found few tips on this thread http://community.mybb.com/thread-38757.html

like below one

Admin CP -> Configuration -> Show Thread Options -> Show 'Similar Threads' Table -> No

Does this affect search speed by any means?.

Thanks for reading this post.

Anyone can help me here please?.

Can anyone help me please?

Move the message and subject to fulltext and flick the setting, it's the best advice I'd be able to actually give that wouldn't need you hacking the core quite a lot.

Hi Rakes,

Thanks for your advice, It really helped me to speed up the search results.

However, I observed that since after doing this change i have been observing quite high load times on my site. Is this expected?. I saw that CPU usage was quite high and mysql was top consumer.

Thanks in Advance.

(2014-12-16, 07:26 AM)stackmypage Wrote: [ -> ]Hi Rakes,

Thanks for your advice, It really helped me to speed up the search results.

However, I observed that since after doing this change i have been observing quite high load times on my site. Is this expected?. I saw that CPU usage was quite high and mysql was top consumer.

Thanks in Advance.

Yep, you should set a limit to the fulltext as its quite resource heavy.