The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
25 views

When tables are locked does MySQL queue queries?

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 ...
0
votes
0answers
163 views

Oracle Transaction recovery: lock conflict caught and ignored

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. ...
0
votes
0answers
22 views

MySQL shared server regular lockup

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 ...