The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
What would be causing this query?
What would be causing this query? It seems to run every so often and practically takes down my whole server because it bogs everything down.
mysql -p -e "explain SELECT COUNT(*) AS count FROM post WHERE dateline >= '1115866077'" vbforums which produces 500,000 rows. It seems to run every now and again, and causes MySQL to sit hammering the disk for a while (right now it has been running for over 3 minutes). |
#2
|
|||
|
|||
This query is used to count the number of new posts since last visit. This query could never produce more then 1 row. It is called everytime someone goes to your index.php file.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|