1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Delayed Insert

Discussion in 'Troubleshooting and Problems' started by SandyF, Mar 2, 2011.

  1. SandyF

    SandyF Member

    My host just sent me an email, copy/pasted below.

    An anyone tell me what this means? Thanks!

  2. Walter

    Walter Well-Known Member

    Are you sure your host knows what he does?
    Delayed inserts are a pretty normal way for a software to optimize performance but if he doesn't want delayed inserts he can configure mySQL so that delayed inserts aren't allowed and handled as normal inserts.
  3. Mike

    Mike XenForo Developer Staff Member

    Exactly my thought - those "queries" aren't doing anything.
    MichaelDance likes this.
  4. SandyF

    SandyF Member

    Well, my host just wrote back and informed me:

    So, I don't imagine you are going to rewrite your software any time soon and I need to find another host.
  5. Walter

    Walter Well-Known Member

    The logic of your hosts tech is flawed. He basically says:

    I don't want you to use delayed inserts but I also don't want to switch them off. [​IMG]
    MichaelDance and SandyF like this.
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Reason enough to change host I would have thought.
    MichaelDance and Darkimmortal like this.
  7. SandyF

    SandyF Member

    Feh. I've been with these guys less than a month and only just got my site back to 100% functionality after the last move.

    Anyone have a recommendations for XenForo-friendly hosts in a shared server configuration? I probably have 8-10 people browsing the forums at any given time and around 10-20 new posts a day.

  8. Brogan

    Brogan XenForo Moderator Staff Member

    Where are you based and do you care where the company and/or servers are located?
  9. SandyF

    SandyF Member

    I am USA based, West Coast.

    I'd prefer a company in the US only for phone support reasons. I like to be able to call support if necessary.
  10. Dean

    Dean Well-Known Member

    You could put hostgator on your list, probably on the bottom of your list. They do have phone support and are easy to understand. The trouble with hosting is there is a lot to consider, for instance many don't want or need phone support, and of course many are simply re-sellers of accounts purchased from places like hostgator.

    I say 'bottom' of your list because eventually the little things of their shared hosting will aggravate you, or at least it aggravated me when we were with them. Random sql errors, inconsistent (but quite pleasant) tech support, things like that.
    Dodgeboard likes this.
  11. Brogan

    Brogan XenForo Moderator Staff Member

  12. SandyF

    SandyF Member

    Excellent, thanks. I should have thought to run a search myself, except I was too mentally damaged by the idea of having to move the site. Again.
    It would probably be helpful if there was a thread somewhere with "don't go here" hosts.
  13. SandyF

    SandyF Member

    The following is from my web guy to relate his conversation with the host.
    I spoke with the back-line administration at our host. This is what she told me:

    The configuration of the forum script creates a backup in the SQL request queue on a shared hosting package. She claims that when the "delay insert" delays the request, it stops all other request traffic from all the other sites on the shared server. In other words, they have a single lane road that does not allow the traffic behind to pass-by the stopped vehicle(s).

    From my conversation with her, InMotion has no imagination or even worse, no inclination to attempt any kind of change to the SQL serve to allow a "passing lane" for slower or stopped traffic.

    I am thinking however, (but I do not know how big a deal it is to rescript) it could be a logical enhancement to the Forum script to have a switch to shut-off the delay insert. This kind of change would seem to create more flexibility of the Forum needing to interact with a wide-range of hosting set-ups. Just a thought for the Suggestion Box.
  14. Mike

    Mike XenForo Developer Staff Member

    Unfortunately, the analogy with the road isn't correct. A "delayed" insert is no different from a regular insert in terms of blocking. Really, there isn't any blocking that's appreciable (in the average case; in the extreme case, the blocking with a delayed insert is no different than a regular insert).
  15. Walter

    Walter Well-Known Member

    Sandy, believe Mike. Such an enhancement isn't needed and I've never heard before about a host not allowing delayed inserts.
    SandyF likes this.
  16. SneakyDave

    SneakyDave Well-Known Member

    I've used Futurequest.net for a number of nears for managed, shared hosting, they don't oversell, they're honest, and they've been around since about 1998 I think. It is stable and they know what they're doing, although they have a few quirks (such as PHP safe mode being on, but they have their own replacement for that, for software that requires safe mode to be off).
  17. Akrion

    Akrion Well-Known Member

    I am using InMotionHositng and for the last 2 weeks I am having all kinds of issues with them. Every time I talked to them they told me its a software issue look @ your code. They also mentioned that the DELAYED INSERTS are cousing problems on the shared SQL server.

    Here is the latest quote from their logs:

    6986 Prepare [9] INSERT DELAYED INTO xf_thread_view
    6986 Execute [9] INSERT DELAYED INTO xf_thread_view
    7067 Prepare [10] INSERT DELAYED INTO xf_thread_view
    7067 Execute [10] INSERT DELAYED INTO xf_thread_view
    11508 Prepare [7] INSERT DELAYED INTO xf_thread_view
    11508 Execute [7] INSERT DELAYED INTO xf_thread_view

    So far not impressed with inmotion to say the least ...
  18. Akrion

    Akrion Well-Known Member

    Here is one more:

    "System administration has been tracking higher resource usage on the machine housing your account and has traced these issues to long running mysql queries related to your account. We may be forced to suspend or have already suspended your site in order to stabilize the server.

    Most queries should complete in less than a second. Some of the queries related to your account take a a lot longer than this to complete and seem to be the source of some latency we are seeing in the server's response.

    Here are examples of such queries:

    | 1310 | DELAYED | localhost | myDBName | Delayed insert | 36 | Waiting for INSERT | |
    | 1325 | DELAYED | localhost | myDBName | Delayed insert | 34 | Waiting for INSERT
  19. estranged

    estranged Well-Known Member

    Those hosts simply have no idea what they are doing. They just see the word "delayed" and think "hmm this must be delaying things in server" :D

    But there is no difference in terms of load on the server. In fact it should be lower compared to any vbulletin forum. We moved two large forums to xenforo on our server and server is doing much better. Those logs mean nothing.
  20. Akrion

    Akrion Well-Known Member

    Yep... but how do you explain this to the so called "admins" in inmotion ...

    PS. I obviously need to move my sites to different host etc. but for now I really would like to know the root of my issues ...

Share This Page