Mysql sending data

[headout]

Your board's URL: not needed
Version of phpBB3: 3.0.2
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? conversion
Did you use an automated wizard provided by your host to install phpBB? nope
MODs you have installed: none
When the problem started: since a week of three
Your level of expertise (be honest): tech

Additionally, you may wish to provide the following (where applicable)
Template(s) used: several
Language(s) used: several
Version of PHP used: PHP 5.2.6 (cgi) (built: Jul 1 2008 09:34:04)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
Database and version used: Server version: 5.0.51a-log FreeBSD port: mysql-server-5.0.51a

Since a few weeks, we have a problem with our MySQL server. It affects only the phpBB3 forums. This server is optimized for MySQL5, no other processes are running on this server. According to mysql show processlist there are many processes "sending data". They seem to be in some kind of loop, and even there when there are no visitors on the forums.

Code: Select all

mysql> SHOW FULL PROCESSLIST;\
--------------
SHOW FULL PROCESSLIST
--------------

+-------+----------------------+-------------------------+--------------------+---------
| Id    | User                 | Host                    | db                 | Command | Time | State            | Info                                                                                   |
+-------+----------------------+-------------------------+--------------------+---------
| 62364 | [i]dbuser[/i]     | hostname:63600 | [i]dbname[/i] | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1211468708 |
| 64560 | [i]dbuser[/i]     | hostname:50129 | [i]dbname[/i]  | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1214148386 |
| 64868 | [i]dbuser[/i]     | hostname:50557 | [i]dbname[/i]  | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1214148386 |
| 65198 | headout1_usr9php     | hostname:50984 | headout1_db9phbb3  | Query   |    1 | Sending data     | SELECT * FROM `vrouwenonline_posts`
                 WHERE post_time = 1219049058     |
| 65319 | [i]dbuser[/i]     | hostname:51139 | [i]dbname[/i]  | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1214148386 |
| 66317 | [i]dbuser[/i]     | hostname:59093 | [i]dbname[/i]  | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1214148386 |
| 66524 | [i]dbuser[/i]     | hostname:59363 | [i]dbname[/i]  | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1214148386 |
| 67908 | [i]dbuser[/i]     | hostname:61195 | [i]dbname[/i]  | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1219001863 |
| 70705 | [i]dbuser[/i]     | hostname:54628 | [i]dbname[/i]  | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1220029229 |
| 71559 | [i]dbuser[/i]     | hostname:51727 | [i]dbname[/i]  | Query   |    0 | Sending data     | SELECT * FROM `xsarawrcchampions_posts`
                 WHERE post_time = 1220029229 |
| 71979 | root                 | localhost               | NULL               | Query   |    0 | NULL             | SHOW FULL PROCESSLIST                                                                  |
| 71986 | unauthenticated user | hostname:50717 | NULL               | Connect | NULL | Reading from net | NULL                                                                                   |
+-------+----------------------+-------------------------+--------------------

MyTop shows us:

Code: Select all

 60758      root       localhost headout1_d         0  Query show full processlist
   62364 headout1_             s01 headout1_d         0  Query SELECT * FROM `xsarawrcchampions_posts` WHERE post_time = 1213602221
   64560 headout1_             s01 headout1_d         0  Query SELECT * FROM `xsarawrcchampions_posts` WHERE post_time = 1218876219
   64868 headout1_             s01 headout1_d         0  Query SELECT * FROM `xsarawrcchampions_posts` WHERE post_time = 1218876219
   65319 headout1_             s01 headout1_d         0  Query SELECT * FROM `xsarawrcchampions_posts` WHERE post_time = 1218876219
   66317 headout1_             s01 headout1_d         0  Query SELECT * FROM `xsarawrcchampions_posts` WHERE post_time = 1218876219
   66524 headout1_             s01 headout1_d         0  Query SELECT * FROM `xsarawrcchampions_posts` WHERE post_time = 1218876219
   65198 headout1_             s01 headout1_d         1  Query SELECT * FROM `vrouwenonline_posts` WHERE post_time = 1219813367

Every seconds mytop refreshes, and show us the same queries, with just one difference: post_time is different. This happens on 2 forums. (we host about 1500 forums who all use this db server)
One with 120K posting, the other 24K posting. No mods installed who need an extra sql query.

This is happening since we did the upgrade to phpBB 3.0.2.

[ToonArmy]

phpBB doesn't perform such query.

[headout]

phpBB doesn't perform such query.

Hmm, weird. Thanks anyway.

[headout]

How to trace this query? These forums have just 1 mod installed: the quickreply mod. They are all hosted on the phpbbhs script, which doesn't use this query too, as stated:

Sorry, I have no idea where that code is. Its not in hosting script, and I can't find such code anywhere in phpbb.

So, is there a possibility to trace this quey to find out where the cullprit is?

//edit: got it: it's the rss mod.