I have a small production website, but it's live 24/7. When running the Optimize, Analyze or Repair commands, MySQL locks the table it is working on. QUESTIONS How would this effect users trying ...
In alert log there are a lot of "Transaction recovery: lock conflict caught and ignored" statements. I've found some information, that this error is caused when there is an active dead transaction. ...
I have a web/ database server with 5 websites on it, all of which execute fairly complex queries regularly. Some of these queries appear in the slow log and take around 0.6-0.8 seconds. However I ...