Delayed inserts

[Langly]

I got an email from my host today, anyone know how to do this?

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 |

[hambil]

I'm not aware of anything in vBulletin that uses INSERT DELAYED. Are you running anything besides vBulletin?

[Marco van Herwaarden]

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.

[Langly]

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.

[Xorlev]

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.

[Marco van Herwaarden]

Originally Posted by Langly

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.

I think they told you even which hack was causing this: http://www.vbulletin.com/forum/showthread.php?p=1128096

[Langly]

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.