tag:blogger.com,1999:blog-31421954.post1315255235405449817..comments2023-10-30T08:23:12.960-07:00Comments on mySQL DBA, Architecture, Dev, Scale, HA, Code : InnoDB: Number of pending reads 128, pending pread calls 0Dathan Pattishallhttp://www.blogger.com/profile/00356367514107959723noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-31421954.post-23844804202630348762008-02-06T11:13:00.000-08:002008-02-06T11:13:00.000-08:00I had the same thing happen, but restarting didn't...I had the same thing happen, but restarting didn't work. I had to delete all my ibdata files and re-create them. This is easy, you just stop, delete, start. Of course, you lose all your data, but them's the breaks. Hopefully you've got backups.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-15341117892024157252007-11-13T12:21:00.000-08:002007-11-13T12:21:00.000-08:00I found myself in a situation with this error afte...I found myself in a situation with this error after a user tried to query a table while it was being repaired and mysql crashed itself because of a semaphore timeout. <BR/><BR/>In an act of desperation I was able to clear this with a reboot of the server. I'd be curious to see if switching to single user mode remounting the /usr filesystem wold be sufficient.Unknownhttps://www.blogger.com/profile/15166733809526830009noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-62158115204692471092007-08-29T08:12:00.000-07:002007-08-29T08:12:00.000-07:00See how SMART can be useful to you http://www.linu...See how SMART can be useful to you http://www.linuxjournal.com/article/6983Maxim Vekslerhttps://www.blogger.com/profile/12287653867923449024noreply@blogger.com