Today one of my MySQL servers started to behave really strange: It would process all requests just fine with the exception of one: It wouldn’t allow one of the forums to display any message threads. What it did instead was to hang there until the connection timeout dropped in. Even stranger was the fact that once I used my patched up PHP which has auto-reconnect capabilities the problem went away with the second request. So once the original request timed out and the re-connect kicked in, the result of the query was delivered in no time.
Resolution? Well, I just restartet the whole MySQL server. I suspect this is yet another problem of the 64-bit MySQL servers I’m using. Going to replace them with the 32-bit version step by step now.
