vb.org Archive - Delayed inserts

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Delayed inserts (https://vborg.vbsupport.ru/showthread.php?t=115344)

Langly

05-11-2006 10:39 PM

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 |

hambil

05-16-2006 11:07 AM

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

Marco van Herwaarden

05-16-2006 11:19 AM

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

05-16-2006 11:23 AM

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

05-16-2006 05:00 PM

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

05-19-2006 09:19 AM

Quote:

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

05-19-2006 10:43 AM

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.

All times are GMT. The time now is 07:15 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01726 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: