Some of my MySQL tables frequently become 'in use' and need to be repaired by me before they can be used again.
Why does this happen, and how do I prevent it?
I run a diary service site so sometimes multiple users can write new entries in their diary simultaneously, resulting in the writing to a certain table simultaneously.
Can this be the cause why my table keeps getting locked?
Thank You!
Why does this happen, and how do I prevent it?
I run a diary service site so sometimes multiple users can write new entries in their diary simultaneously, resulting in the writing to a certain table simultaneously.
Can this be the cause why my table keeps getting locked?
Thank You!