A few months ago, we upgraded php to 4.3.10. We immediately began seeing problems with mysql crashing, so we upgraded it to the latest version as well (4.0.22, I believe). Looking at the error log when it crashes, I see the following:
Code: Select all
050228 9:12:23 /usr/local/libexec/mysqld: Out of memory. Restart daemon and try again (needed 6291448 bytes) 050228 9:12:23 /usr/local/libexec/mysqld: Sort aborted 050228 9:12:23 /usr/local/libexec/mysqld: Out of memory. Restart daemon and try again (needed 6291448 bytes) 050228 9:12:23 /usr/local/libexec/mysqld: Sort aborted
We have tried raising the memory limit for sorts, but it just happens again at a higher number (as you can see, we are now at 6M).
I apologize if this is an inappropriate forum to ask this question, as this seems like more of a mysql problem or a php problem than a phpbb problem, but I'm asking here because I know that it's a phpbb sort that is causing the Out of Memory error, because I'm able to recreate it. I simply do a "search" and enter only the * wildcard character as the word I am searching for. Our phpbb_search_wordmatch tables are now about 175 Megs long.
I'm not sure if this is what's causing the problem, or if any number of searches each day could be responsible, but it seems a good start would be to make it so that you can't search for just "*".
I've tried searching for * on other phpbb forums and haven't seen similar problems, though (on this forum, I'm returned a blank screen). I'm not sure, then, what's different about our situation.
Any guidance in how we might fix this problem, or even properly diagnose it (not convinced it's solely the search function responsible) is appreciated. I would prefer to keep as much of our search capabilities intact as possible.