The last two days have been maddening for me. On two servers, out of the blue, MySQL is freakin' and freakin' hard. It all started with corrupted tables, to memory preformance issues. I then jacked up some mem values, and now both servers are crashing. I think I might be dealing with two problems (second problem related to the first problem). I posted on the Gentoo forum, but another classic 'talking-to-myself' thread. Man, I miss the days when you'd get several reponses within minutes. My problems/questions seem pretty difficult lately, and that's probably a big reason for the lack of replies.
Below is my basic thread of the problem.. if anyone has any suggestions, please comment!
I'm getting desperate for some MySQL help on one of my servers. It started mysteriously lastnight. One of my applications (code has not changed in serveral months to a year), complained about corrupted tables. Viewing the logs, I was definitely seeing MyISAM corruption, which I could replicate by issuing a OPTIMIZE after the sql performed a UPDATE. Again, this code has been like this for many months. I commented out the OPTIMIZE and repaired the tables, and that seemed to have fixed the problem.