Here is the problem. I am getting random table locks in my databases on a new server running Fedora 0.96 and Mysql 3.23.58-7.
It seems that different tables will "lock" -- what I mean by that is when I try to execute a query on them, mysql just freezes up -- it doesn't crash or return errors it just hangs. This can happen on different tables at different times, just a couple of tables on a database, or on an entire database as just happened to me right now. There seems to be no rhyme or reason. Another symptom, at least I think so, is that when I try to restart mysql with "service mysqld restart" I get: Mysql Stopped [OK] Mysql Started [Failed]. ANd when I look at processes running by user mysql, I see a pid with mysqld attached to it. If I kill it via a "kill -9" command another pops up immediately. However, if I then do a mysqld server restart, it shuts down [OK] and then starts [OK] and it all appears to be working again. But then another table locks again and I have repeat this process. On a mildly used server this happening every 5-30 minutes or more frequently and I am just not accessing the tables soon enough to notice. Sometimes I can browse the tables just fine, but trying input or update an entry in the table will hang. IF I cancel that query, I can still browse it. I am thoroughly confused and looking for ANY help you might be able to give me. Ryan Shrout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
