The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Delayed inserts
I got an email from my host today, anyone know how to do this?
Code:
While examining the server, we discovered that your account is using delayed inserts that are stalling for sometime. Could you change the delayed inserts to regular inserts? An example query is given below: 4973 | DELAYED | | mysite_vb | Delayed insert | 185 | Waiting for INSERT | |
#2
|
||||
|
||||
I'm not aware of anything in vBulletin that uses INSERT DELAYED. Are you running anything besides vBulletin?
|
#3
|
|||
|
|||
I don't remember which hack it was, but didn't vb.com support tell you which hack was causing this?
If so, please ask in the support thread of that hack. |
#4
|
|||
|
|||
No, they just said it might be a hack doing it. Its just that this just stated happening and I didn't add any new hacks or mods in a good while.
|
#5
|
|||
|
|||
Disable any hacks & mods one by one to see which one is using delayed inserts. Once you find it, modify it to use real-time inserts as for a forum system you really don't want or need delayed inserts.
|
#6
|
|||
|
|||
Quote:
|
#7
|
|||
|
|||
Yes, I removed that query from the CMS, vbportal. Come to find out this is all due to another user on the box that is running stuff in SQL that keeps making it crash and its making my querys look like delayed ones. Thanks for the responces.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|