How to disable PhpBB3 search for guest users?
Often the phpBB3 search functionality is abused by different spambots. They perform searches as guest users.
This significantly increases the size of the search_wordmatch table. It contains pairs of data of which posts include which words from the search_wordlist table. Usually, when the table is large slow MySQL queries are generated.
As a solution disable the search functionality for guest users. This can be done from the phpBB3 admin panel > Users and Groups > Groups’ permissions. Select Guests from the drop-down menu and click on Submit. Click on the Advanced permissions link and then open the Misc tab. Set Never for the Can search board option and confirm the modification by clicking on Apply permissions.
Additionally, you can increase the User search flood interval and the Common word threshold values from the phpBB3 admin panel > General > Search settings.