Hi there, I am running a large site with dedicated servers, I can get more info if required. But we are having an issue where we will publish 1 2 or 3 articles and they will be fine hit "post / publish" and it is nearly instant. Then we get to the 4th and the site will hang for 3 minutes then it will go through. Then the next one will do the same etc.
If we publish "slower" it doesn't seem to be a problem, looking at the database while this is happening it almost seems like locks are not be released and then it snowballs from there and everything gets locked up. We initially had this issue when we were mass publishing a backlog, doing hundreds of articles an hour. But now we do about 10-15 a day not a big deal.
Any ideas what could be causing this? Two days in a row our server had to be rebooted because the mysql database was locked.