Merging the two boards has resulted in about 450 usergroups that we want to clean out. However, when we use the ACP to delete a group, the request hangs and I eventually get:
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
To add some info, I have another Xenforo install running with InnoDB on the same server (though it is smaller) and do not have this issue - I can create a delete usergroups just fine.
Also, I've tried copying this site over to a completely different server and I still encounter the same issue.