Update. My rebooted server has gone back to hanging again. There's plenty of memory available -

[Linked Image from lisashea.com]

Using "show engine innodb status" I get further details -

~~~~~~~~~~~
---TRANSACTION 336FF1, not started flushing log
mysql tables in use 1, locked 1
MySQL thread id 9758, OS thread handle 0xf00, query id 161579 localhost 127.0.0.1 root query end
update ubbt_TOPICS
set TOPIC_VIEWS = TOPIC_VIEWS + 1
where TOPIC_ID = 31148
~~~~~~~~~~~

So it's locked up on the set topic_views line.

That's interesting, because that's not the code I thought was causing the lock.

Yup, did another test. Again it's that same spot.

~~~~~~~~~~~~~

---TRANSACTION 3396A7, not started flushing log
mysql tables in use 1, locked 1
MySQL thread id 10903, OS thread handle 0x94c, query id 177666 localhost 127.0.0.1 root query end
update ubbt_TOPICS
set TOPIC_VIEWS = TOPIC_VIEWS + 1
where TOPIC_ID = 20935


~~~~~~~~~~~~~~~~

OK any thoughts where this code is located?

I need to stay on IIS. I have far too much ASP code to rewrite.

Last edited by BellaOnline; 12/17/2012 10:33 PM.
Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts