The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
Tag process in mysql
My mysql is going a little crazy due to this specific tagging process shown in mysqld processlist.
Code:
+-----+------------------+-----------+-------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 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. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|