In the past two years we use MySql for keeping data for nightly builds of our C++ projects. DB is fairly small, and has a few triggers on it. Recently it began failing on updates rather frequently. We deleted some unnecessary old records and situation improved a little, however failure still happens.
We've tried to look at the error logs, nothing significant there (unless error logging isn't configured correctly).
Can someone give a hint as to where we should look? Are there any diagnostic modes that can help us track the problems?
I'd be happy to elaborate on missing info..