XF 1.0 MySQL process got stuck

[Panupat]

Hi.

I got an email from my host admin saying that there seem to be a lot of process getting stuck

Do you think you can switch your database to MyISAM ?
We often have your InnoDB connection getting stuck

98784 DELAYED localhost afxenforo 11 Delaye Waiting for INSERT

Any suggestion? My forum seems to be running fine without any down time as far as I can see. Or maybe it did crash while I'm not browsing.

 

[RobParker]

There's a thread on here if you search for delayed inserts which looks like it might help.

 

[Paul B]

See this thread: http://xenforo.com/community/threads/delayed-insert-issue-with-inmotionhosting.16053/

Your host doesn't know what they're talking about.

 

[Panupat]

Thanks Brogan. Just started reading the thread you post. So it seems like the correct behavior for INSERT_DELAY right? It's waiting for the table to be free of usage before it executes?

So if the host doesn't like it, they can switch off the delay following this page? And the insert will happen without delay?
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_delayed_threads