The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|