?

Log in

No account? Create an account
entries friends calendar profile Previous Previous Next Next
phpBB phpbb_search_wordmatch/phpbb_search_wordlist slow queries - IBNeko's Journal-Nyo~!
ibneko
ibneko
phpBB phpbb_search_wordmatch/phpbb_search_wordlist slow queries
If your phpBB2 forum is running really slow, and mysql's "show processlist;" shows a lot of queries that look like:
SELECT m.word_id
  FROM phpbb_search_wordmatch m, phpbb_search_wordlist w
  WHERE w.word_text..


That may be the remove_common function in includes/functions_search.php, which, as far as I can tell, removes common keywords. Or something like that.

Credit for finding this goes to http://vladimir-shapiro.com/en/blog/2007/12/07/performance-killer-in-phpbb/

I decided it's probably there for some sort of good reason, so I instead of just putting a "return;" at the top of that function, I did a "if (rand(0,1000) != 0) {return;}", which essentially means that once out of every 1000 times that function is called, it'll run through the function and do whatever it does.

This cut my server load average from 25 down to 0.5.
1 happy kitten | Leave catnip
Comments
From: (Anonymous) Date: May 3rd, 2009 09:32 pm (UTC) (Link)

Ugrently need your help!

Hello, my dear friends... I want to download program XRUMER 5.0 PALLADIUM free. Have you any url?
I'm so need this magic program! It's can break captchas automatically! Activate accounts via email automatically too! Absolutely great software! Help me!
And did you hear news - price for XRumer 5.0 Palladium will grow up to $540 after 15 may 2009... And XRumer 2.9 and 3.0 - too old versions, it's cant break modern catpchas and cant break modern anti-bot protections. But XRumer 5.0 Palladium CAN!!!!
So help me for download this great soft for free! Thanks!
1 happy kitten | Leave catnip