since a couple of days (I had to set up a new webserver, so I can't exactly put my finger on a particular change since when it started) I detected a very high server load on the mysqld and php_cgi process on my server.
MySQL's Slow-log indicates this query in *every* line, so this one seems to be a main cause of the problem:
however I couldn't even spot the 'and p.post_visibility = 1' string anywhere in the phpbb code! Can anyone point me to the right direction please?SELECT COUNT(p.post_id) as count
FROM phpbb_posts p
WHERE p.post_time > ########
AND p.post_visibility = 1
AND p.poster_id != ##;