I have moved a production server over to OpenVZ, something that I've done many times before, only this time it has impacted the transaction behaviour of certain operations.
All my tables are innoDB. I haven't changed any parameters from their out of the box state.
Certain requests to JBoss are resulting in transactions which take exactly 10 seconds to complete, but only intermittently. Usually they are lightning fast.
I can't find anything in my.cnf or in Mysql's variables that corresponds to this 10 second delay. I can see the transactions appearing in Innotop, but if I switch to Q - query mode, I am unable to see the full query by pressing f.
There doesn't seem to be any kind of rollback, because even when delayed, the functionality is not broken. JBoss has a transaction timeout of 300s as per the standard config.
I see no limits hit in /proc/user_beancounters (OpenVZ tracks when VM's exceed their resource quotas for those that don't know what this is).
I am struggling to identify where this bottleneck is coming from.