Tag process in mysql

[Chadi]

My mysql is going a little crazy due to this specific tagging process shown in mysqld processlist.

+-----+------------------+-----------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id  | User             | Host      | db                | Command | Time | State                | Info                                                                                                 |
+-----+------------------+-----------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 929 | user_vbuser  | localhost | vb_dbname | Sleep   | 3    |                      |                                                                                                      |
| 930 | user_vbuser  | localhost | vb_dbname | Query   | 3    | Copying to tmp table | SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount
                                        FROM tagthread AS tagthread
                                        I |
| 931 | user_vbuser  | localhost | vb_dbname | Query   | 2    | Copying to tmp table | SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount
                                        FROM tagthread AS tagthread
                                        I |
| 932 | user_vbuser  | localhost | vb_dbname | Query   | 2    | Copying to tmp table | SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount
                                        FROM tagthread AS tagthread
                                        I |
| 933 | user_vbuser  | localhost | vb_dbname | Query   | 2    | Copying to tmp table | SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount
                                        FROM tagthread AS tagthread
                                        I |
| 934 | user_vbuser  | localhost | vb_dbname | Query   | 0    | Copying to tmp table | SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount
                                        FROM tagthread AS tagthread
                                        I |
| 935 | root             | localhost |                   | Query   | 0    |                      | show processlist                                                                                     |
+-----+------------------+-----------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
Uptime: 592  Threads: 10  Questions: 13211  Slow queries: 0  Opens: 672  Flush tables: 1  Open tables: 345  Queries per second avg: 22.316

Can someone please explain exactly what's going on up here? I have no taggin plugin installed at all.

--------------- Added [DATE]1266380338[/DATE] at [TIME]1266380338[/TIME] ---------------

I disabled "Enable Search Tag Cloud" in vboptions > Tagging Options

Processes no longer there now.

[Marco van Herwaarden]

If this is on a default installation with no plugins that add these queries, then i would also post this on vB.com (bugtracker??) as these queries can probably be improved upon.

PS This might also be related to the amount of memory available to MySQL, so please also post in the server config forum an optimization request for your server.