All,
We are experiencing a strange problem where one minute everything is running
fine on mysql, then the next minute, all queries seem to lockup.
Can anybody provide guidance to me so I can determine the cause of the
lockups?
So far I dump the proc logs every minute via cron. I have found th
I am currently experiencing a problem with MYSQL where critical INSERTs into
my database appear to be held up by reports that are doing SELECTs. Turns
out the particular select uses a LIKE '%value%'. I would think this results
in a sequential search of the entire table (400k records) thereby
I have come across a flawed transaction counter in a mysql application that
I now support. I believe it is flawed because it does not use record
locking to deal with concurrency and was hoping someone could give me ideas
on how to correct.
The transaction counter works like this:
1) Web transa
