Today my server become unresponsive due to a long semaphore wait. From slow query logs i can see that commit, rollback and select(which usually takes...