MySQL server simple insert/update/delete queries are taking a long time to execute
- by ElGabbu
We have a VPS hosting server with a MySQL server running on it. We host several databases for client's websites. Recently we have noticed that insert/update and delete queries are taking a long time to execute sometimes as close as 30 seconds.
I use the following command to see these queries being executed:
watch -n1 mysqladmin proc stat
We have still not been able to track the root of this problem. I would apprecite if anyone had any pointers as to what we can check or improve to resolve the issue.
Thanks